I'm now, based on recommendations from the list, running the current (as of yesterday)
version of OJB from CVS. I'm getting an error that I can't seem to get past. Is this
an OJB bug? It seems as thought the generated SQL is just plain incorrect, trying to
join on the roles table more than once. Any ideas/workarounds appreciated.
--Scott
----
.[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Already created
persistence broker instances: 0
settign eager: false
[org.apache.ojb.broker.util.sequence.SequenceManagerFactory] INFO: Use sequence
manager class: class org.apache.ojb.broker.util.sequence.SequenceManagerHiLoImpl
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class
com.stmpjmpr.system.User where org.apache.ojb.broker.query.Criteria@42658b
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
A0.sysadmin,A0.url,A0.activity_visible,A0.id,A0.birthdate,A0.image,A0.status,A0.theme,A0.first_name,A0.last_login,A0.update_required,A0.email,A0.date_created,A0.login,A0.email_visible,A0.password,A0.last_name
FROM users A0 WHERE (A0.login = ? ) AND A0.password = ?
[org.apache.ojb.broker.accesslayer.AbstractPoolableConnectionFactory] INFO: # Create
connection pool for JdbcDescriptorKey -1167486426 #
settign eager: false
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class
com.stmpjmpr.system.Role where org.apache.ojb.broker.query.Criteria@6022e2
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
A0.view,A0.user_id,A0.name,A0.post,A0.edit,A0.group_id,A0.delete FROM roles A0 WHERE
A0.user_id = ?
[org.apache.ojb.broker.ta.PersistenceBrokerFactoryDefaultImpl] INFO: Already created
persistence broker instances: 1
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
name,description,id FROM groups WHERE id = ?
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class
com.stmpjmpr.system.Role where org.apache.ojb.broker.query.Criteria@55d782
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
A0.view,A0.user_id,A0.name,A0.post,A0.edit,A0.group_id,A0.delete FROM roles A0 WHERE
A0.group_id = ?
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
sysadmin,url,activity_visible,id,birthdate,image,status,theme,first_name,last_login,update_required,email,date_created,login,email_visible,password,last_name
FROM users WHERE id = ?
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from class
com.stmpjmpr.system.Role where org.apache.ojb.broker.query.Criteria@37d95f
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
A0.view,A0.user_id,A0.name,A0.post,A0.edit,A0.group_id,A0.delete FROM roles A0 WHERE
A0.user_id = ?
[org.apache.ojb.broker.accesslayer.JdbcAccess] DEBUG: executeQuery : Query from roles
where org.apache.ojb.broker.query.Criteria@521cd5
[org.apache.ojb.broker.accesslayer.sql.SqlGeneratorDefaultImpl] DEBUG: SQL: SELECT
A0.name,A0.description,A0.id FROM groups A0,roles INNER JOIN roles A1,roles ON
A0.id=A1.group_id WHERE (roles.user_id = ? ) AND roles.group_id = A0.id
[org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException during the
execution of the query (for a com.stmpjmpr.system.Group): ERROR: parser: parse error
at or near ","
ERROR: parser: parse error at or near ","
java.sql.SQLException: ERROR: parser: parse error at or near ","
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
at
org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.java:257)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:247)
at
org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(RsIteratorFactoryImpl.java:95)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQuery(PersistenceBrokerImpl.java:2087)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuery(PersistenceBrokerImpl.java:1488)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1149)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1304)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1330)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollection(PersistenceBrokerImpl.java:979)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollections(PersistenceBrokerImpl.java:1025)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:1404)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:1517)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(PersistenceBrokerImpl.java:1127)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReference(PersistenceBrokerImpl.java:935)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceBrokerImpl.java:916)
at
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:419)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1175)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1304)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1330)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollection(PersistenceBrokerImpl.java:979)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollections(PersistenceBrokerImpl.java:1025)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getDBObject(PersistenceBrokerImpl.java:1404)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByIdentity(PersistenceBrokerImpl.java:1517)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getReferencedObject(PersistenceBrokerImpl.java:1127)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReference(PersistenceBrokerImpl.java:935)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences(PersistenceBrokerImpl.java:916)
at
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:419)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1175)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1304)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1330)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollection(PersistenceBrokerImpl.java:979)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveCollections(PersistenceBrokerImpl.java:1025)
at
org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:420)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1175)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1304)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1330)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:1317)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(PersistenceBrokerImpl.java:1552)
at com.stmpjmpr.service.WebServiceImpl.authenticate(WebServiceImpl.java:87)
at com.stmpjmpr.service.WebServiceTest.testRoles(WebServiceTest.java:147)
at java.lang.reflect.Method.invoke(Native Method)
at junit.framework.TestCase.runTest(TestCase.java:166)
at junit.framework.TestCase.runBare(TestCase.java:140)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:131)
at junit.framework.TestSuite.runTest(TestSuite.java:173)
at junit.framework.TestSuite.run(TestSuite.java:168)
at junit.textui.TestRunner.doRun(TestRunner.java:74)
at junit.textui.TestRunner.start(TestRunner.java:234)
at junit.textui.TestRunner.main(TestRunner.java:112)
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
