Have you investigated the RowSet classes available with JDBC 2.0? This
might allow you to decouple your data from a particular database connection.

At 11:57 AM 6/28/2000 -0700, you wrote:
>William Crawford wrote:
>
>[Applications in which a database connection is allocated to a user for
>the duration of a session]
>
> > I'd be interested in hearing about apps where this kind of system was
> > required - I'm sure there are some out there.
>
>
>I'm working on such an app at the moment. Users are able to view the
>result sets they've created during the course of a session, go back to
>previous results, and combine previous results. For example, you can
>create a new result set which contains elements which are in both sets 1
>and 2, or in set 1 and not in set 2, or restrict a search to the
>elements of set 2 (select * from set 2 where ...). Since result sets are
>tied to a particular database connection, users have to have their own
>connection to do this.
>
>
>Gennis
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

---
William Crawford                                        + 01 617 577 7844
Invantage, Inc                                            [EMAIL PROTECTED]

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to