File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

PreparedStatement query

 
wrushasen dakhane
Ranch Hand
Posts: 47
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have 2 questions...

1. Where does the compiled preparedStatement stays?


2. When we are running thr the ResultSet i.e rs.next and the database connectivity is lost how the resultset work will it display the remaining records or it will start again?


Best Regards,
Wrushu
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33697
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Wrushu,
1) In Java's memory from the driver. Note there is also a database execution plan which is stored on the database.
2) Usually it will throw an exception forcing you to handle it. Most people handle it by starting over, but you could write some code for the re-query to start where you left off.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic