File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Using populate in CachedRowSet

 
renu richard
Ranch Hand
Posts: 116
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
In my application, i am reading the data from the database and then displaying it in another JSP.

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.


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
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 116
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
glad to know that you found the problem

Shailesh
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic