G
Garg
Hi All,
I am facing a small and i am not able to find the direction in which i
should move.
I am using IntraSystem Cache as a DataBase and declaired Explicit
cursor there.
I tried with the simple database connection as followes
String url = "jdbc:Cache://127.0.0.1:" + port + "/User/
log.txt";
String user = "_SYSTEM";
String password = "SYS";
String stQueryP = "{call ABC.XYZ_ByPQR}";
Class.forName ("com.intersys.jdbc.CacheDriver");
Connection dbconnection =
DriverManager.getConnection(url,user,password);
CallableStatement cstmt =
dbconnection.prepareCall(stQueryP);
int j = 0;
while (rs.next())
{
System.out.print(j);
System.out.println(" " + rs.getString(1) + " " +
rs.getString(2));
j++;
}
I am getting unlimited records and all are null only.
Can anyone please suggest me how should i move forward.
Should i need to declare cursor in java also.
Thanks
Tarun Garg
I am facing a small and i am not able to find the direction in which i
should move.
I am using IntraSystem Cache as a DataBase and declaired Explicit
cursor there.
I tried with the simple database connection as followes
String url = "jdbc:Cache://127.0.0.1:" + port + "/User/
log.txt";
String user = "_SYSTEM";
String password = "SYS";
String stQueryP = "{call ABC.XYZ_ByPQR}";
Class.forName ("com.intersys.jdbc.CacheDriver");
Connection dbconnection =
DriverManager.getConnection(url,user,password);
CallableStatement cstmt =
dbconnection.prepareCall(stQueryP);
int j = 0;
while (rs.next())
{
System.out.print(j);
System.out.println(" " + rs.getString(1) + " " +
rs.getString(2));
j++;
}
I am getting unlimited records and all are null only.
Can anyone please suggest me how should i move forward.
Should i need to declare cursor in java also.
Thanks
Tarun Garg