Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Dis-connected resultset

 
tim_shea
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there a way I could make a DB call using JDBC to any DB. Get a Statement back and then close my connection to the DB. And still have the data in the Statement.
Or, am I stuck having to transfer this data out of the ResultSets into other objects before closing the connection?
 
jayram
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
tim,
I think you need to use CachedRowSet for this purpose. Plz checkout this article for more
http://developer.java.sun.com/developer/Books/JDBCTutorial/chapter5.html
Cheers
Jayram
 
David O'Meara
Rancher
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"tim_shea",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp.
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please edit your profile and select a new name which meets the requirements.
Thanks.
Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic