[Hibernate-issues] [Hibernate-JIRA] Created: (HB-565) HSQLDB Select Query Doesn't work with Dialect

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
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: Unassigned
   Priority: Critical

    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:39 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