I am using Hibernate 2.1.7.

Webspphere 5.0.2.6.

Db2 V 08.01.0000

DB2 JDBC Driver 08.01.0000

I have made sue the db2java.zip is the same on the client and the server.

It gives me the following error:


[4/4/05 14:11:05:441 PDT] 66f107ca SystemOut O Hibernate: select aclentryim0_.C_ID as C_ID0_, aclentryim0_.C_ENTRYID as C_ENTRYID0_, aclentryim0_.C_ACTION as C_ACTION0_, aclentryim0_.C_PRINCIPAL as C_PRINCI4_0_, aclentryim0_.C_PRINCIPALTYPE as C_PRINCI5_0_, aclentryim0_.C_PERMISSION as C_PERMIS6_0_, aclentryim0_.C_PERMISSIONTYPE as C_PERMIS7_0_ from T_ACLENTRIES aclentryim0_ where aclentryim0_.C_ID=? and aclentryim0_.C_ENTRYID=?
[4/4/05 14:11:05:781 PDT] 66f107ca JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: HY010
[4/4/05 14:11:05:871 PDT] 66f107ca JDBCException E net.sf.hibernate.util.JDBCExceptionReporter [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
[4/4/05 14:11:05:952 PDT] 66f107ca JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: HY010
[4/4/05 14:11:05:962 PDT] 66f107ca JDBCException E net.sf.hibernate.util.JDBCExceptionReporter [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
[4/4/05 14:11:06:002 PDT] 66f107ca HibernateDao W com.postx.sec.acl.HibernateDao TRAS0014I: The following exception was logged net.sf.hibernate.exception.GenericJDBCException: could not initialize collection: [com.postx.sec.acl.Acl.aclEntries#101]
at net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:81)
at net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:30)
at net.sf.hibernate.collection.AbstractCollectionPersister.convert(AbstractCollectionPersister.java:728)
at net.sf.hibernate.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:291)
at net.sf.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:3303)
at net.sf.hibernate.collection.PersistentCollection.forceInitialization(PersistentCollection.java:336)
at net.sf.hibernate.impl.SessionImpl.initializeNonLazyCollections(SessionImpl.java:3156)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
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:1553)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)[i]


I ran the querry in the Command Center and it ran successfully.

I have seen some posts with similar errors before any resolution?

I am seeing the same error under the same conditions:


[5/8/08 4:29:02:213 EDT] 17df1d2 JDBCException W org.hibernate.util.JDBCExceptionReporter SQL Error: -99999, SQLState: HY010
[5/8/08 4:29:02:213 EDT] 17df1d2 JDBCException E org.hibernate.util.JDBCExceptionReporter [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
[5/8/08 4:29:02:215 EDT] 17df1d2 SystemOut O ERROR [Servlet.Engine.Transports : 0]: class-com.labcorp.aca.stars.dao.hibernate.AccountDAOHibernate: method-findAllAddressUpdateAccounts - find all temp change accounts failed
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2214)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
at org.hibernate.loader.Loader.list(Loader.java:2090)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java(Compiled Code))
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at com.labcorp.aca.stars.dao.hibernate.AccountDAOHibernate.findAllAddressUpdateAccounts(AccountDAOHibernate.java:245)


Any explanation?