How do I check the SQL being generated. I trying to check on OJB site how
to do that.
Here's my code where I am trying to enter a new User in the User table. I
was able to query the table absolutely fine.
User newUser = new User();
System.out.println("Please Enter User Id");
String in = readLineWithMessage("User Id:");
newUser.setUserId(new Integer(in));
in = readLineWithMessage("Enter Name:");
newUser.setUserName(in);
in = readLineWithMessage("Enter password:");
newUser.setPassword(in);
Transaction tx = null;
tx = odmg.newTransaction();
tx.begin();
tx.lock(newUser, tx.WRITE);
tx.commit();
Ujwal
-----Original Message-----
From: Matthew Baird [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 11:47 AM
To: OJB Users List
Subject: RE: Error while using ODMG and Persistence Broker
send the SQL that is being generated, as well as the OQL or PB Query API
code that you are executing and we'll be able to help.
m
-----Original Message-----
From: Ujwal Oswal [mailto:[EMAIL PROTECTED]]
Sent: Wed 9/11/2002 7:38 AM
To: 'OJB Users List'
Cc:
Subject: Error while using ODMG and Persistence Broker
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.
