Hello,
I'm testing the trial-version of Hxtt Access v2.0 Driver and the HxttAccessDialect for Hibernate with JBoss4.0.4.GA, EJB3.0 and MSAccess 2000.
With the following code-sample I try to select only the first 20 results:
titleList = (List) query.setMaxResults(20)
.setFirstResult(0)
.getResultList();
Hibernate generates the following sql statement that results in an error:
13:41:01,546 INFO [STDOUT] Hibernate: select title0_.TITLEID as TITLEID128_, title0_.TITLENAME as TITLENAME128_ from TITLES title0_ limit ?
The error is:
13:41:01,578 WARN [JDBCExceptionReporter] SQL Error: 172032, SQLState: 2A000
13:41:01,578 ERROR [JDBCExceptionReporter] Syntax error: Stopped parse at limit
...
Caused by: javax.faces.el.EvaluationException: /findTitle.xhtml @44,46 action="#{titleFinder.findFirstPage}": javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
...
Caused by: javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
...
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
...
Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
...
Caused by: java.sql.SQLException: Syntax error: Stopped parse at limit
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.f(Unknown Source)
at com.hxtt.sql.bl.l(Unknown Source)
at com.hxtt.sql.ag.if(Unknown Source)
at com.hxtt.sql.dd.(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.prepareStatement(Unknown Source)
at com.hxtt.sql.bl.prepareStatement(Unknown Source)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349)
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344)
at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:661)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 191 more
My questions are:
1. Is this a Hxtt Access v2.0 or a Hibernate-HxttAccessDialect problem?
2. Does MS Access support this 'limitation'?
Best regards,
Karl Gruber
|
>1. Is this a Hxtt Access v2.0 or a Hibernate-HxttAccessDialect problem?
HxttAccessDialect problem. Thanks for your response. Please download the latest support package now.
>2. Does MS Access support this 'limitation'?
Maybe no.
|