I do it like this... OJB.properties -------------- ... ... # Loger for SqlGenerator, useful for debugging generation of SQLorg.apache.ojb.broker.accesslayer.SqlGenerator.LogLevel=DEBUG ... ^^^^^ ...
James Mitchell Software Engineer\Struts Evangelist Struts-Atlanta, the "Open Minded Developer Network" http://www.open-tools.org/struts-atlanta > -----Original Message----- > From: Ujwal Oswal [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 12:12 PM > To: 'OJB Users List' > Subject: RE: Error while using ODMG and Persistence Broker > > > 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.AbstractPoolableConnectionFacto > ry] 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(AS400JDBCSta > tement.jav > a:903) > at > com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPr > eparedStat > ement.java:186) > at > com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDB > CConnectio > n.java:1166) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.prepareSt > atement(Un > known Source) > at > org.apache.ojb.broker.accesslayer.StatementsForClassImpl.getSelect > ByPKStmt(U > nknown Source) > at > org.apache.ojb.broker.accesslayer.StatementManager.getSelectByPKSt > atement(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.getObjectById > entity(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.getSelectByPKSt > atement(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.getObjectById > entity(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. > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
