aspose file tools*
The moose likes JDBC and the fly likes RowSet.. and SQL2k Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
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 agree. Here's the link: http://aspose.com/file-tools
 
subject: RowSet.. and SQL2k