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

how to use disconnceted architecture using JDBC in java

 
Dhiren Lodhia
Greenhorn
Posts: 14
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi every one,

i want to know how can we use disconnected database architecture using JDBC in java. i.e what i mean is something like DataSet in .Net.
when we take data in ResultSet & when i want to take data from ResultSet the database connection has to be OPEN else it gives error.
i want to take data from database onces and then close Connection then use data!!!
I have Heard about class called CachedRowSet,What is that exactly & how to use it??
please give a small & simple example if possible...........

Thanks in Advance
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, CachedRowset is the answer for you ! You can use the CachedRowset even after closing the connection.

On a quick search on google will give you many results. I recommend you to read this http://www.javaworld.com/javaworld/jw-02-2001/jw-0202-cachedrow.html

Thanks,
Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic