I am trying to update a User table using ODMG and Persistence Broker API. I
am getting this Error . I am sending the trace too. Querying the table just
works fine.
[org.apache.ojb.broker.accesslayer.AbstractPoolableConnectionFactory] INFO:
# Create connection pool for JdbcDescriptorKey 669007219 #
[org.apache.ojb.broker.accesslayer.AbstractConnectionFactory] INFO: #
Already created connections: 1 returning : S103273D
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Already
created persistence broker instances: 1
[org.apache.ojb.broker.accesslayer.StatementsForClassImpl] ERROR: [SQL0104]
Token . was not valid. Valid tokens: < > = <> <= !< !> != >= �< �> �= IN IS
NOT LIKE BETWEEN.
java.sql.SQLException: [SQL0104] Token . was not valid. Valid tokens: < > =
<> <= !< !> != >= �< �> �= IN IS NOT LIKE BETWEEN.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:351)
at
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.jav
a:903)
at
com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStat
ement.java:186)
at
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnectio
n.java:1166)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getSelectByPKStmt(U
nknown Source)
at
org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Unk
nown Source)
at
org.apache.ojb.odmg.ObjectEnvelope.setInitialModificationState(Unknown
Source)
at org.apache.ojb.odmg.ObjectEnvelope.<init>(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.register(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source)
at test.odmg.TestOdmg.addUser(TestOdmg.java:114)
at test.odmg.TestOdmg.main(TestOdmg.java:91)
[org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR:
PersistenceBrokerException during the execution of materializeObject: null
null
org.apache.ojb.broker.PersistenceBrokerSQLException
at
org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKStatement(Un
known Source)
at
org.apache.ojb.broker.accesslayer.JdbcAccess.materializeObject(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(Unknown
Source)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(Unk
nown Source)
at
org.apache.ojb.odmg.ObjectEnvelope.setInitialModificationState(Unknown
Source)
at org.apache.ojb.odmg.ObjectEnvelope.<init>(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.register(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source)
at test.odmg.TestOdmg.addUser(TestOdmg.java:114)
at test.odmg.TestOdmg.main(TestOdmg.java:91)
[org.apache.ojb.odmg.TransactionImpl] ERROR: Locking obj
com.bw.pointinterface.authentication.User@778ef1 with lock mode 4 failed
null
org.odmg.ODMGRuntimeException
at
org.apache.ojb.odmg.ObjectEnvelope.setInitialModificationState(Unknown
Source)
at org.apache.ojb.odmg.ObjectEnvelope.<init>(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.register(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source)
at test.odmg.TestOdmg.addUser(TestOdmg.java:114)
at test.odmg.TestOdmg.main(TestOdmg.java:91)
org.odmg.ODMGRuntimeException
at
org.apache.ojb.odmg.ObjectEnvelope.setInitialModificationState(Unknown
Source)
at org.apache.ojb.odmg.ObjectEnvelope.<init>(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.register(Unknown Source)
at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source)
at test.odmg.TestOdmg.addUser(TestOdmg.java:114)
at test.odmg.TestOdmg.main(TestOdmg.java:91)
null
org.odmg.LockNotGrantedException
at org.apache.ojb.odmg.TransactionImpl.lock(Unknown Source)
at test.odmg.TestOdmg.addUser(TestOdmg.java:114)
at test.odmg.TestOdmg.main(TestOdmg.java:91)
Exception in thread "main"
Ujwal Oswal
Programmer/ Analyst
BristolWest Insurance
Cleveland
OH.
