----
.[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.st atus,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,passw ord,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.ja va:99)
at org.apache.ojb.broker.accesslayer.JdbcAccess.executeQuery(JdbcAccess.jav a:257)
at org.apache.ojb.broker.accesslayer.RsIterator.<init>(RsIterator.java:247)
at org.apache.ojb.broker.singlevm.RsIteratorFactoryImpl.createRsIterator(Rs IteratorFactoryImpl.java:95)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getRsIteratorFromQu ery(PersistenceBrokerImpl.java:2087)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getIteratorFromQuer y(PersistenceBrokerImpl.java:1488)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1149)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1304)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(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(Persist enceBrokerImpl.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(P ersistenceBrokerImpl.java:935)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences( PersistenceBrokerImpl.java:916)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:419)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1175)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1304)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(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(Persist enceBrokerImpl.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(P ersistenceBrokerImpl.java:935)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.retrieveReferences( PersistenceBrokerImpl.java:916)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIt erator.java:419)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1175)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1304)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(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(RsIt erator.java:420)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:204)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1175)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1304)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1330)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getCollectionByQuer y(PersistenceBrokerImpl.java:1317)
at org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.getObjectByQuery(Pe rsistenceBrokerImpl.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)
On Thursday, October 24, 2002, at 01:45 PM, Jakob Braeuchi wrote:
hi scott,
imo the problem is in the cast to QueryByCriteria witch failes for a
QueryByMtoNCriteria:
private ClassDescriptor getItemClassDescriptor(ObjectReferenceDescriptor
ord, String attr)
{
Class itemClass;
// BRJ look for hint
itemClass = ((QueryByCriteria) getQuery()).getClassForPath(attr);
if (itemClass == null)
{
itemClass = ord.getItemClass();
}
return
ord.getClassDescriptor().getRepository().getDescriptorFor(itemClass);
}
there have been major refactorings in this area, i think you should try a
newer version.
btw in the current version (cvs) i check the class before casting...
hth
jakob
----- Original Message -----
From: "Scott W. Hill" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 10:28 PM
Subject: Re: Problem with M:N association
/**
* This Class allows to build an abstract SQL statement, which is then
materialized by
* concrete Platform implementation.
*
* @author <a href="mailto:on@;ibis.odessa.ua">Oleg Nitz</a>
* @version $Id: SqlStatement.java,v 1.8 2002/08/19 20:08:06 brj Exp $
*/
public abstract class SqlStatement implements JoinSyntaxTypes
On Thursday, October 24, 2002, at 01:12 PM, Jakob Braeuchi wrote:
--Scotthi scott, can you please post the header of SqlStatement.java the i can check the version./** * Model a Statement based on Query * * @author <a href="mailto:jbraeuchi@;hotmail.com">Jakob Braeuchi</a> * @version $Id: SqlQueryStatement.java,v 1.10 2002/10/08 14:04:01 brj Exp $ */ jakob ----- Original Message ----- From: "Scott W. Hill" <[EMAIL PROTECTED]> To: "OJB Users List" <[EMAIL PROTECTED]> Sent: Thursday, October 24, 2002 10:00 PM Subject: Re: Problem with M:N associationNo. I've been trying to keep stable for now, given that my code is changing rapidly at this point. I'd upgrade if we thought that this was a fixed bug, though. On Thursday, October 24, 2002, at 12:59 PM, Jakob Braeuchi wrote:hi scott, from the stacktrace i see you're using an older version of ojb. have you tried the current one ? jakob--Scott -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>-- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
--
To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
--Scott -- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
