LoL @ Oracle. It works great with Postgres!
--- "Power-Netz (Schwarz)" <[EMAIL PROTECTED]> wrote:
> > If you are using JDBC 1.2 you can do it like this (snippet):
> >
> > //declare your Statement to return a scroll insensitive result set
> > //before you make the query
> > stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
> > ResultSet.CONCUR_READ_ONLY);
> >
> > //get the number of rows by scrolling to the last row,
> > //getting its number, then returning to the start:
> > try {
> > resultSet.last();
> > numberOfRows = resultSet.getRow();
> > resultSet.beforeFirst();
> > } catch (Exception e) {
> > e.printStackTrace();
> > }
>
> This will only work, IF the underlying driver really supports all
> methods
> offered by JDBC. !this is not for sure! -> see ORACLE who did not
> implement
> all resultset navigation methods.
>
>
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mai��
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
