JDBC 2.0 is part of Java2 (i.e. jdk 1.2.x), but you must get the JDBC 2.0
drivers from the Database vendor, and at the moment there aren't very many
available. What Database are you using? And, what do you mean that "count
is not working"?
(*Chris*)
----- Original Message -----
From: Gautam Batra <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 07, 1999 6:41 AM
Subject: Re: Total No. of records
> Hi can someone tell me where can i get JDBC 2.0 driver or is it part of
> jdk1.2.1 ?
>
> count is not working !
>
> Gautam
> ----- Original Message -----
> From: Joe Sam Shirah <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 07, 1999 5:30 PM
> Subject: Re: Total No. of records
>
>
> > >Use a database specific feature such as Oracle's COUNT
> >
> > The COUNT() column function, SELECT COUNT(*) FROM... is standard
SQL.
> >
> > If one is fortunate enough to have a JDBC 2.0 driver ( can you say
> > AS.400? ) one can also use
> >
> > resultset.last();
> > int rownumber = resultset.getRow();
> >
> >
> >
> > Joe Sam Shirah
> > Autumn Software
> >
> >
>
___________________________________________________________________________
> > 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
> >
>
>
___________________________________________________________________________
> 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
>
___________________________________________________________________________
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
