Two Laptop Bag
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

RowSet.. and SQL2k

Hanna Habashy
Ranch Hand

Joined: Aug 20, 2003
Posts: 532
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?

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:
subject: RowSet.. and SQL2k
It's not a secret anymore!