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
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