• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to use disconnceted architecture using JDBC in java

 
Dhiren Lodhia
Greenhorn
Posts: 14
  • 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
  • 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
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic