Hi all
I have also encounterred the same problem.
I've trace the / hibernate /
Hibernate2/src/net/sf/hibernate/dialect/InformixDialect.java
at
http://cvs.sourceforge.net/viewcvs.py/hibernate/Hibernate2/src/net/sf/hibernate/dialect/InformixDialect.java?rev=1.14&view=markup
I guess the issue is in the function as follwoing:
public String getLimitString(String querySelect, boolean hasOffset, int
limit) {
if (hasOffset) throw new
UnsupportedOperationException("informix has no offset");
return new StringBuffer( querySelect.length()+8 )
.append(querySelect)
.insert( getAfterSelectInsertPoint(querySelect), "
first ?" )
.toString();
}
Why is the parameter "limit" passing in without any effect but just writing
"first ? " ?
Will any other module do setInt(limit) elsewhere ?
urgent....too...
Best Regards,
Ahsiu
>>----------- Original Message ----------------
>> 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)
>> ......
--
Chang Heng-Hsiu
Organization : Institute for Information Industry
Department : Advanced e-Commerce Institute
Tel: 886-2-87326222 ext. 329
FAX: 886-2-23770776
E-Mail: [EMAIL PROTECTED]
Addr : 17FL.-A, No.333, Sec.2, Duenhua S. Rd, Taipei 106, Taiwan
-------------------------------------------------------
This SF.Net email is sponsored by: InterSystems CACHE
FREE OODBMS DOWNLOAD - A multidimensional database that combines
robust object and relational technologies, making it a perfect match
for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
