Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Hxtt Access v2.0 with HxttAccessDialect for Hibernate
Karl Gruber
2006-09-13 06:07:31
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) <br> .setFirstResult(0) <br> .getResultList(); <br> <br>Hibernate generates the following sql statement that results in an error: <br> <br>13:41:01,546 INFO [STDOUT] Hibernate: select title0_.TITLEID as TITLEID128_, title0_.TITLENAME as TITLENAME128_ from TITLES title0_ limit ? <br> <br>The error is: <br> <br>13:41:01,578 WARN [JDBCExceptionReporter] SQL Error: 172032, SQLState: 2A000 <br>13:41:01,578 ERROR [JDBCExceptionReporter] Syntax error: Stopped parse at limit <br>... <br>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 <br>... <br>Caused by: javax.ejb.EJBException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query <br>... <br>Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query <br>... <br>Caused by: org.hibernate.exception.GenericJDBCException: could not execute query <br>... <br>Caused by: java.sql.SQLException: Syntax error: Stopped parse at limit <br> at com.hxtt.global.SQLState.SQLException(Unknown Source) <br> at com.hxtt.a.b.a(Unknown Source) <br> at com.hxtt.a.b.a(Unknown Source) <br> at com.hxtt.a.b.f(Unknown Source) <br> at com.hxtt.sql.bl.l(Unknown Source) <br> at com.hxtt.sql.ag.if(Unknown Source) <br> at com.hxtt.sql.dd.<init>(Unknown Source) <br> at com.hxtt.sql.bl.a(Unknown Source) <br> at com.hxtt.sql.bl.prepareStatement(Unknown Source) <br> at com.hxtt.sql.bl.prepareStatement(Unknown Source) <br> at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepareStatement(BaseWrapperManagedConnection.java:349) <br> at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareStatement(BaseWrapperManagedConnection.java:344) <br> at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:187) <br> at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:497) <br> at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:415) <br> at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139) <br> at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561) <br> at org.hibernate.loader.Loader.doQuery(Loader.java:661) <br> at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) <br> at org.hibernate.loader.Loader.doList(Loader.java:2145) <br> ... 191 more <br> <br>My questions are: <br>1. Is this a Hxtt Access v2.0 or a Hibernate-HxttAccessDialect problem? <br>2. Does MS Access support this 'limitation'? <br> <br>Best regards, <br> <br>Karl Gruber <br> </td> </tr> <tr class="support_issue_list_title"> <td width="60%" style=" font-size: 13px; font-weight:bold; color: #800000; "><div align="justify">Re:Hxtt Access v2.0 with HxttAccessDialect for Hibernate</div></td> <td width="20%" style=" font-size: 12px; color: #008000; " nowrap><div align="justify">HXTT Support</div></td> <td width="20%" style=" font-size: 12px; color: #000000; " nowrap><div align="justify">2006-09-13 07:23:04</div></td> </tr> <tr class="support_issue_list_content" style=" font-size: 12px;"> <td colspan="3"> >1. Is this a Hxtt Access v2.0 or a Hibernate-HxttAccessDialect problem? <br>HxttAccessDialect problem. Thanks for your response. Please download the latest support package now. <br> <br>>2. Does MS Access support this 'limitation'? <br>Maybe no. </td> </tr> </table> <hr class="introducebold"/> <table width="95%" bgcolor="#E7FDFE" class="srchissue"> <tr><td nowrap> <form name="searchissue" action="search_support.jsp" target="search_support" method="post"> <input type="hidden" name="product" value="access"> Search Key <input type="text" name="srchkey" value="">  Search by <select name="srchopt"> <option value="1">Email</option> <option value="2">Subject</option> <option value="3" selected>Message</option> </select> <input type="submit" value="Search" onClick="MM_validateForm('srchkey','please input search condition','R');return document.MM_returnValue" > <a class="introduce" href="search_support.jsp?product=access&maxcount=50" target="search_support">Last 50 Questions</a> </form></td> <!--<td nowrap> <form name="searchissue1" action="search_support.jsp?product=access&maxcount=50&srckkey=%" target="search_support" method="post"> <input type="hidden" name="product" value="access"> <input type="hidden" name="maxcount" value="30"> <input type="hidden" name="srchkey" value="%"> <input type="submit" value="Last 30 Question"> </form> </td> --></tr></table> <br><br><br><br><!-- SiteSearch Google --> <form method="get" action="http://www.google.com/custom" target="google_window"> <table border="0" bgcolor="#ffffff"> <tr><td nowrap="nowrap" valign="top" align="left" height="32"> <a href="http://www.google.com/"> <img src="http://www.google.com/logos/Logo_25wht.gif" border="0" alt="Google" align="middle"></img></a> </td> <td nowrap="nowrap"> <input type="hidden" name="domains" value="www.hxtt.com"></input> <label for="sbi" style="display: none">Enter your search terms</label> <input type="text" name="q" size="31" maxlength="255" value="" id="sbi"></input> <label for="sbb" style="display: none">Submit search form</label> <input type="submit" name="sa" value="Search" id="sbb"></input> </td></tr> <tr> <td> </td> <td nowrap="nowrap"> <table> <tr> <td> <input type="radio" name="sitesearch" value="" checked id="ss0"></input> <label for="ss0" title="Search the Web"><font size="-1" color="#000000">Web</font></label></td> <td> <input type="radio" name="sitesearch" value="www.hxtt.com" id="ss1"></input> <label for="ss1" title="Search www.hxtt.com"><font size="-1" color="#000000">www.hxtt.com</font></label></td> </tr> </table> <input type="hidden" name="client" value="pub-7813278216411667"></input> <input type="hidden" name="forid" value="1"></input> <input type="hidden" name="ie" value="UTF-8"></input> <input type="hidden" name="oe" value="UTF-8"></input> <input type="hidden" name="safe" value="active"></input> <input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#336699;VLC:663399;AH:center;BGC:FFFFFF;LBGC:336699;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;FORID:1"></input> <input type="hidden" name="hl" value="en"></input> </td></tr></table> </form> <!-- SiteSearch Google --> <br> </td> <td></td> </tr> </table> <script> //if (window.screen.availWidth<=800) // document.all("mainTable").width="100%"; //else // document.all("mainTable").width="80%"; </script> <table width="492" border="0" align="center" cellpadding="0" cellspacing="0" id="contactTable" style="font-size: 10pt; color: #3366CC"> <tr> <td align="left" valign="top">Email:</td> <td align="left" valign="top"><img border="0" src="/image/email.gif" align="top" width="20" height="20"><a href="mailto:webmaster@hxtt.com">webmaster@hxtt.com</a></td> </tr> <!-- <tr> <td align="left" background="/image/email_bottom.gif"> </td> <td align="left" background="/image/email_bottom.gif"> </td> </tr>--> </table><div align="center" class="contactUs"><font color="#A042FF">Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | <a href=/en/privacy.html target=_blank>Privacy</a> | <a href=/en/legal.html target=_blank>Legal</a> | <a href=/en/refund.html target=_blank>Refund</a> | <a href=/sitemap.xml target=_blank>Sitemap</a></font> </div> </body> </html>