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.PersistenceBrokerSQLExceptio n:
COM.ibm.db2.jdbc.DB2Exception: [IBM]
[CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.e xecuteQuery(Unknown
Source)
at
org.apache.ojb.broker.accesslayer.RsQueryObject.pe rformQuery(Unknown Source)

at org.apache.ojb.broker.accesslayer.RsIterator.<init >(Unknown
Source)
at
org.apache.ojb.broker.core.RsIteratorFactoryImpl.c reateRsIterator(Unknown
Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.g etRsIteratorFromQuery(Unkn
own Source)
at
org.apache.ojb.broker.core.PersistenceBrokerImpl.g etIteratorFromQuery(Unknow
n Source)
at
org.apache.ojb.broker.core.QueryReferenceBroker.ge tCollectionByQuery(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_S QLException(SQLExceptionGe
nerator.java:
250)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGe
nerator.java:
193)
at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_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.Seq uenceManagerNativeImpl" />

</jdbc-connection-descriptor>


Dirk


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org