This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes RowSet.. and SQL2k Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "RowSet.. and SQL2k" Watch "RowSet.. and SQL2k" New topic
Author

RowSet.. and SQL2k

Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
hi:
I am connecting to SQL2k dbms. I want to cach the ResultSet in the memory, so it can be accessed after the connection is closed. I want to use any flavor of RowSet interface, but I don't think SQL2k driver provides implementation for the RowSet interface.
Does anyone know where can I find such a class? also, I can't find the SQL2k jdbc driver api on microsoft web site. Do they provide an api for thier driver? Are they any other ways to bring the ResultSet data to the memory, so that it can be accessed even after its statement and the connection are closed?
thanks


SCJD 1.4<br />SCJP 1.4<br />-----------------------------------<br />"With regard to excellence, it is not enough to know, but we must try to have and use it.<br />" Aristotle
Dana Hanna
Ranch Hand

Joined: Feb 28, 2003
Posts: 227
The SQL2K driver is on the MS site somewhere. As far as making it work, getting an API, or finding support - don't get your hopes up. You're lucky to have them even write the Driver.
Good luck getting them to place nice with Java!
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: RowSet.. and SQL2k
 
It's not a secret anymore!