Hi, I am using OJB-PB and DB2 7.2. I deployed the web-app on two different computer. At home, I use Db2 7 Personal Edition and everything works without complains. At my company we have DB2 UDB 7 and I deployed the app there too. However, when I try to do any database operation I get the following exception:
Caused by: org.apache.ojb.broker.PersistenceBrokerSQLException: COM.ibm.db2.jdbc.DB2Exception: [IBM] [CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010 at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown Source) at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown Source) at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unkn own Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknow n Source) at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(Unknown Source) ... 50 more Caused by: COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0125E Function sequence error. SQLST ATE=HY010 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe nerator.java: 250) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe nerator.java: 193) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen erator.java:4 32) at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java :1124) Does anyone have a clue why this exception is being thrown? for more information I provide an excerpt of the collection-descriptor: <jdbc-connection-descriptor jcd-alias="default" default-connection="true" platform="Db2" jdbc-level="2.0" driver="COM.ibm.db2.jdbc.app.DB2Driver" protocol="jdbc" subprotocol="db2" dbalias="tintra" username="xxxx" password="xxxx" eager-release="false" batch-mode="false" useAutoCommit="2" ignoreAutoCommitExceptions="false"> <connection-pool maxActive="21" validationQuery="" /> - <!-- SequenceManger Implementierung fuer Tabellen mit Identity Columns --> <sequence-manager className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl" /> </jdbc-connection-descriptor> Dirk --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]