Function sequence Error using DB2 UDB 7

["Dirk Manske (Service Respond)" <se...@nexgo.de>]

 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: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org