I am getting the following error while performing a query. Has anyone experienced this and how did you resove it? Thanks!

Dec 28, 2004 6:03:43 PM net.sf.hibernate.JDBCException <init>
SEVERE: Could not execute query
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Unsupported method: ResultSet.absolute
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.validateScrollable(Unknown Source)
at com.microsoft.jdbc.base.BaseResultSet.absolute(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.absolute(DelegatingResultSet.java:254)
at com.opensourceconnections.msjdbcproxy.ResultSetProxy.absolute(ResultSetProxy.java:314)
at net.sf.hibernate.loader.Loader.advance(Loader.java:629)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:803)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:846)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at ....... ( the rest is in my classes)

Use jTDS, its a better driver for MSSQlServer

Yes, I agree jTDS is a better driver. We will replace the MS driver as soon as time permits for proper testing.

I discovered the cause of the problem though:

The developer working on the client side of our web services app was passing in a zero for a page number during a search. It appears the minimum value for a page is "1" not "0" which caused the driver to throw an exception. It would be nice if Hibernate would catch this error and give a more difinitive error message rather than throwing it up through the stack.