Have you taken a look at the early release of the rowset api from sun.
It does caching of results so that they are scrollable, it also does all
of the database connections in the background so that it only makes
connections as needed for updating and making new queries instead of
constantly maintaining an open connection, this might help with making
sure the connection gets closed if an error occurs.
http://developer.java.sun.com/developer.Books/JDBCTutorial/chapter5.html
---------------------------------------------------------------------
Rich Catlett [EMAIL PROTECTED] | Confuscious say "Man who stand |
Programmer | on toilet, high on pot!" |
| |
---------------------------------------------------------------------
On Tue, 24 Jul 2001, Ciot, Thierry wrote:
> I would think it is a very useful feature. Right now I am looking at how to
> display rows using a "paging" mechanism (that is, for example, 10 rows at a
> time).
>
> How would you go about doing this with the current tag lib?
>
> With scrollable record set we could have something like:
>
> <jdbc:connection id="conn1">
> <jdbc:url>jdbc:odbc:test</jdbc:url>
> <jdbc:driver>sun.jdbc.odbc.JdbcOdbcDriver</jdbc:driver>
> </jdbc:connection>
>
> <jdbc:statement id="stmt1" conn="conn1">
> <jdbc:query><%= query %></jdbc:query>
> <jdbc:resultSet id="myRS" loop="true" beginat="20" endat="30">
> <tr>
> <td><jdbc:getColumn position="3"/></td>
> <td><jdbc:getColumn position="1"/></td>
> </tr>
> </jdbc:resultSet>
> </jdbc:statement>
>
>
> What do you think?
>
> Thierry.
>
> -----Original Message-----
> From: Morgan Delagrange [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 23, 2001 12:05 AM
> To: {[EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: DBTags and scrollable result sets
>
>
>
> Ciot, Thierry wrote on 7/20/01 2:38 pm:
>
> >Hi,
> >
> >Is there any plan to add
> >scrollable result sets support
> >in DBTags?
> >
> >Thanks, Thierry.
>
> Nothing definite. :) That specific feature hasn't actually come up as of
> yet, but it does sound like a good one.
>
> Morgan
>
