Hi everybody,
I am doing the following query using Hibernate 2.1.6 with an Informix
database
Query query = aHibernateSession.createQuery(hql);
query.setMaxResults(1);
setBoundVariables(query);
query.list();
When query.list() method is executed, I got the following error message (see
below). When I don't set the Max Results, I have no error. I saw that the
generated SQL contains the "select first" string and my Informix database
support it. Can somebody help ?
Please it is urgent....
Regards . Yvan
Hibernate: select first ? bankpjo0_.user_nr_bk as user_nr_bk,
bankpjo0_.bankname as bankname, bankpjo0_.userbk_nr as userbk_nr from srusbk
bankpjo0_ where (bankpjo0_.userbk_nr=? )and(bankpjo0_.user_nr_bk=? )
Message: java.sql.SQLException: A syntax error has occurred.
Class: org.apache.commons.dbcp.DbcpException
Stack trace:
org.apache.commons.dbcp.DbcpException: java.sql.SQLException: A syntax error
has occurred.
at
org.apache.commons.dbcp.PoolingConnection.makeObject(PoolingConnection.java:
191)
at
org.apache.commons.pool.impl.GenericKeyedObjectPool.borrowObject(Unknown
Source)
at
org.apache.commons.dbcp.PoolingConnection.prepareStatement(PoolingConnection
.java:128)
at
org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConn
ection.java:187)
at
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:257)
at
net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java:232)
at
net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java:65)
at
net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java:779)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:265)
at
net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader
.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:1033)
at net.sf.hibernate.loader.Loader.list(Loader.java:1024)
at
net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1544)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
......
-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
