Message:
The following issue has been closed.
Resolver: Gavin King
Date: Wed, 17 Dec 2003 10:44 AM
This is a bug in your build of HSQL. Use the build in Hibernate CVS.
---------------------------------------------------------------------
View the issue:
http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-565
Here is an overview of the issue:
---------------------------------------------------------------------
Key: HB-565
Summary: HSQLDB Select Query Doesn't work with Dialect
Type: Bug
Status: Closed
Priority: Critical
Resolution: REJECTED
Project: Hibernate2
Components:
core
Versions:
2.0 final
Assignee:
Reporter: Deepak Singh
Created: Wed, 17 Dec 2003 10:39 AM
Updated: Wed, 17 Dec 2003 10:44 AM
Environment: Webserver: Tomcat 5.1
DB: HSQL 1.7.2 Aplha T and also tried on HSQL 1.7.1 on
OS: Windows XP
JDK:1.4.1_01-b01
Hibernate Version: Hibernate 2 final
Description:
This happened when I tried to use:
hibernate.dialect=net.sf.hibernate.dialect.HSQLDialect
Wrong data type: TOP m in statement [select top ? user0_.userName as userName, user0_.password as password from USER user0_ where (user0_.userName=? )]
And if I don't use a Dialect the Application works fine.
Caused by: net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:45)
at com.rhi.bob.hb.db.GenericDao.doQuery(GenericDao.java:456)
at com.rhi.bob.hb.db.GenericDao.find(GenericDao.java:333)
... 33 more
Caused by: java.sql.SQLException: Wrong data type: TOP m in statement [select top ? user0_.userName as userName, user0_.password as password from USER user0_ where (user0_.userName=? )]
at org.hsqldb.jdbcDriver.throwError(Unknown Source)
at org.hsqldb.jdbcPreparedStatement.<init>(Unknown Source)
at org.hsqldb.jdbcConnection.prepareStatement(Unknown Source)
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:233)
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:61)
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:699)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:180)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:128)
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
|
