Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Hxtt Access v2.0 with HxttAccessDialect for Hibernate
Karl Gruber
2006-09-13 06:07:31.0
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.0</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 width="78" align="left">Address:</td> <td width="579" align="left">9 Station Rd., Xiangtan City, Hunan Province, P.R. China</td> </tr> <tr> <td align="left">Postcode:</td> <td align="left"> 411100</td> </tr> <tr> <td align="left">Phone:</td> <td align="left">(86)731-58225727</td> </tr> <tr> <td align="left">Fax: </td> <td align="left">(86)731-58225727</td> </tr> <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 © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | <a href=/en/privacy.html target=_blank>Privacy</a> | <a href=/en/legal.html target=_blank>Legal</a> | <a href=/sitemap.xml target=_blank>Sitemap</a></font> </div> </body> </html>