yep, we faced the same problem :-)
And I'm trying to do exactly what you describe. Build a library with
resultset caching (an vector of vectors of Objects or something like it).
One great thing about it is that caching becomes very easy.
Dynamically creating update/insert statements, handling null values,
date-string and back conversion ... are some of the more tricky items.
Geert 'Darling' Van Damme
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Radhakrishnan, Sanjay (c)
> Sent: dinsdag 4 januari 2000 19:58
> To: [EMAIL PROTECTED]
> Subject: Off Topic: JConnect and Updatable result sets
>
>
> We are using a Sybase database in our application(which uses
> JSPs). JConnect
> is the JDBC driver from Sybase. Jconnect 5.2 claims that it is compliant
> with JDBC 2.0, but does not fully implement scrollable resultsets and even
> the Updatable resulsets doesn't work well either.
>
> In such a scenario, how should one implement scrollable and
> updatable result
> sets.
>
> Do we have to build our own library, may be build a vector object/class
> which resembles the resultset and do all data manipulation inside
> the vector
> object and let the Vector generate update statements or Are there any off
> the shelf library/product which will do the same thing.
>
> I'm sure most of you guys must have faced this problem.
>
> Appreciate your help
>
> Thanks
> Sanjay
>
> ==================================================================
> =========
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
