java.sql.SQLException: Exhausted Resultset
Hi All
I got this error msg "java.sql.SQLException: Exhausted Resultset" when i tried to run my program.
Have read from somewhere that i missed out typing a ResultSet.next(); before calling it out.
However i have already added in ResultSet.next();
Kindly advice on how to solve this problem.
Thanks
Below are some sample codes where out is this:
[2007-06-06 14:14:35] Fully filled trades found
[2007-06-06 14:14:35] Customer ID: 0000123
[2007-06-06 14:14:35] Ref No: 20070606000000021
[2007-06-06 14:14:35] Error in trigger [Error] java.sql.SQLException: Exhausted Resultset
This part is the sample code :
ResultSet rsFilled = psFillAlert.executeQuery();
ResultSet rsUserDetails =null;
//partial filled
ResultSet rsPartialFilled = psPartialFillAlert.executeQuery();
ResultSet rsUserDetails2 =null;
tndg.setRS(rsFilled);
tndg.setRS(rsPartialFilled);
while(tndg.hasNextDoc()){
try{
eventlog.writeln("Fully filled trades found ");
rsFilled.next();
eventlog.writeln("Customer ID: " + rsFilled.getString("cust_id"));
eventlog.writeln("Ref No: " + rsFilled.getString("ref_no"));
userlog.writeln("Fully filled trades found ",false);
userlog.writeln("Customer ID: " + rsFilled.getString("cust_id"),false);
userlog.writeln("Ref No: " + rsFilled.getString("ref_no"),false);
eventlog.writeln("Partially filled trades found ");
rsPartialFilled.next();
eventlog.writeln("Customer ID: " + rsPartialFilled.getString("cust_id"));
eventlog.writeln("Ref No: " + rsPartialFilled.getString("ref_no"));
userlog.writeln("Partially filled trades found ",false);
userlog.writeln("Customer ID: " + rsPartialFilled.getString("cust_id"),false);
userlog.writeln("Ref No: " + rsPartialFilled.getString("ref_no"),false);
Message was edited by:
peachtea
