Using populate in CachedRowSet

[renu richard]

Hi,
In my application, i am reading the data from the database and then displaying it in another JSP.

Pgm 1:
DBPool.executeQuery(sqlQuery.toString(),DSN,loRS);
if(loRS.next()){
loginVO.setCount(2);
loginVO.setFirstname(loRS.getString("first_name"));
loginVO.setLastname(loRS.getString("last_name"));
loginVO.setPhone(loRS.getInt("phone"));
          }
 else {
 System.out.println("nothing retunred in loRS")}

In program 1, i am calling the executeQuery method, which is getting the connection object and then exectuing the query.


Program 2 shows how the executeQuery method is defined.

Pgm 2 :
public static boolean executeQuery(String asSQL,String asDSN,CachedRowSet aoCRS){
loStatement = loConn.createStatement() ;
loRS = loStatement.executeQuery(asSQL) ;
aoCRS.populate(loRS) ;
System.out.println("count in DBPOOL: "+aoCRS.size());   >>>>> returing the size as 1
}

Now the problem is, eventhough aoCRS.size() is retuning size as 1, the line loRS.next() is not getting executed and the it is going to the else part.
Could you please help me on this.

[ November 10, 2008: Message edited by: renu richard ]
[ November 10, 2008: Message edited by: renu richard ]

[Shailesh Chandra]

Did you check how many rows are there in resultset, also you can refer one example here http://ilovej2ee.blogspot.com/2008/01/using-cachedrowset-in-java.html

Shailesh

[renu richard]

Hi Shailesh,
Thanks for that wonderful example.
The problem in my code was that for debugging i have used next method somewhere already in my application. So, when i tried using the next method again it is called again but there are no rows to execute. Thats why it failed.

[Shailesh Chandra]

glad to know that you found the problem

Shailesh