Hi,
I also ran into similar trouble when I was using Informix
drivers with JDBC-ODBC version.
I did not get answer from anyone including Advance-Java group.
Result, work around.
- Created a tempcount table with int count field
- insert into tempcount select count(*) ...
- selct count from tempcount
- delete tempcount ...
Like it or not, this is what I ended up into...
Seems you have same situation..
Satyen
! ! From [EMAIL PROTECTED] Sun Aug 8 16:47 EDT 1999
! ! MIME-Version: 1.0
! ! Content-Transfer-Encoding: 7bit
! ! X-Priority: 3
! ! X-MSMail-Priority: Normal
! ! X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
! ! Date: Sun, 8 Aug 1999 13:06:02 -0700
! ! From: Chris Pratt <[EMAIL PROTECTED]>
! ! Subject: Re: Total No. of records
! ! To: [EMAIL PROTECTED]
! !
! ! >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
! !
___________________________________________________________________________
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
