SELECT
USERPASSWORD,USERID,USERNAME FROM USER WHERE (USER.USERID = ? )
the . in USER.USERID seems to be the culprit.
Can you execute this against your db2 database outside of OJB?
I'm not a db2 guy, so I don't know how DB2 expects the SQL to look.
-----Original Message-----
From: Ujwal Oswal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 9:45 AM
To: 'OJB Users List'
Subject: RE: Error while using ODMG and Persistence Broker
Here's the SQL I am getting.
[BOOT] INFO: OJB.properties: file:/C:/eclipse/workspace/OJB/OJB.properties
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Already
created persistence broker instances: 0
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use
sequence manager class: class
org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
Please Enter User Id
User Id: 9999
Enter Name: ojbuser
Enter password: ojbuser
[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.SqlGenerator] DEBUG: SQL: SELECT
USERPASSWORD,USERID,USERNAME FROM USER WHERE (USER.USERID = ? )
[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
com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnectio
n.java:1118)
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@ab323 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
-----Original Message-----
From: James Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 11, 2002 12:22 PM
To: OJB Users List
Subject: RE: Error while using ODMG and Persistence Broker
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]>
