>From what I understand, Microsoft Access is not really a SQL database, so it
may not conform to the SQL Standards. It's a navigational database that is
made to look like a relational database by the Jet engine that Microsoft
uses for their ODBC system. ResultSet.previous(), and ResultSet.absolute(4)
are JDBC 2.0 calls, which aren't going to be supported by the JDBC 1.0
driver that you have for MS Access. I guess, unless you can find an method
specific to MS Access, the only way to do it is to run through the ResultSet
and count them up.
(*Chris*)
----- Original Message -----
From: Gautam Batra <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 08, 1999 12:23 AM
Subject: Re: Total No. of records
> Hi Chris !
>
> I am using MS ACCESS ( from Office Premium 2000)!
>
> I tried to use count(*) from.... but error keeps coming...and I tried
> various syntaxes ( if I was going wrong there ).
>
> I am out actually ...I will get the errors tomorrow...However, I have
tried
> to use resultset.previous(), resultset.absolute(4) and I get the error
> java.lang.UnsupportedOperationException when I run the servlet.
>
> what drivers can I use with MS ACCESS ?
>
> Thankx
>
> Gautam
>
>
> >From: Chris Pratt <[EMAIL PROTECTED]>
> >Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> > Servlet API Technology." <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Total No. of records
> >Date: Sat, 7 Aug 1999 14:13:40 -0700
> >
> >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
>
>
> ______________________________________________________
> Get Your Private, Free Email at http://www.hotmail.com
>
>
___________________________________________________________________________
> 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
