Hi,
I'm trying to create an EOQualifer to filter and array where I have only the
EOs that have a toMany relationship not empty. I tried many things, including a
thread "qualifier to check for empty toMany" of May 11, 2011 without success.
My code was
ERXQ.isNotNull(Transaction.COMPONENT_TRANSACTIONS_KEY +
"." + Transaction.PK_KEY)
I then tried what I thought was the most promising ERXQ.hasAtLeast
ERXQ.hasAtLeast(Transaction.COMPONENT_TRANSACTIONS_KEY,
null, 1)
componentTransactions being my modelled toMany relationship. The doc says that
the array can be null.
but I get the following exception at run-time which surprised me a bit. I run
latest Wonder (integration) and PostgreSQL as my database. Inspecting the code
seems to poin to having a badly defined joins which brings me in my ignorance
zone about inner/outer/upper/sideway joins....
Pointers to a tutorial on those would be appreciated.
Even a solution based upon straight SQL would make me happy 8-).
Application: Alexandria
Error: java.lang.RuntimeException: not implemented!!
Reason: not implemented!!
Stack trace:
File Line# Method Package
ERXToManyQualifier.java 234 sqlStringForSQLExpression
er.extensions.eof.qualifiers
EOQualifierSQLGeneration.java 165 _sqlStringForSQLExpression
com.webobjects.eoaccess
EOSQLExpression.java 1528 sqlStringForArrayOfQualifiers
com.webobjects.eoaccess
EOSQLExpression.java 1560 sqlStringForConjoinedQualifiers
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 541 sqlStringForSQLExpression
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 165 _sqlStringForSQLExpression
com.webobjects.eoaccess
EOSQLExpression.java 1528 sqlStringForArrayOfQualifiers
com.webobjects.eoaccess
EOSQLExpression.java 1574 sqlStringForDisjoinedQualifiers
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 578 sqlStringForSQLExpression
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 165 _sqlStringForSQLExpression
com.webobjects.eoaccess
EOSQLExpression.java 1528 sqlStringForArrayOfQualifiers
com.webobjects.eoaccess
EOSQLExpression.java 1560 sqlStringForConjoinedQualifiers
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 541 sqlStringForSQLExpression
com.webobjects.eoaccess
EOQualifierSQLGeneration.java 165 _sqlStringForSQLExpression
com.webobjects.eoaccess
EOSQLExpression.java 997 prepareSelectExpressionWithAttributes
com.webobjects.eoaccess
JDBCExpression.java 146 prepareSelectExpressionWithAttributes
com.webobjects.jdbcadaptor
PostgresqlExpression.java 770 prepareSelectExpressionWithAttributes
com.webobjects.jdbcadaptor
EOSQLExpressionFactory.java 225 selectStatementForAttributes
com.webobjects.eoaccess
JDBCChannel.java 213 selectAttributes
com.webobjects.jdbcadaptor
EODatabaseChannel.java 897 _selectWithFetchSpecificationEditingContext
com.webobjects.eoaccess
EODatabaseChannel.java 234 selectObjectsWithFetchSpecification
com.webobjects.eoaccess
EODatabaseContext.java 3055 _objectsWithFetchSpecificationEditingContext
com.webobjects.eoaccess
EODatabaseContext.java 3195 objectsWithFetchSpecification
com.webobjects.eoaccess
EOObjectStoreCoordinator.java 488 objectsWithFetchSpecification
com.webobjects.eocontrol
EOEditingContext.java 4069 objectsWithFetchSpecification
com.webobjects.eocontrol
ERXEC.java 1308 objectsWithFetchSpecification er.extensions.eof
EOEditingContext.java 4444 objectsWithFetchSpecification
com.webobjects.eocontrol
_Transaction.java 604 fetchTransactions com.obzerv.eo
Transaction.java 112 wipTransactions com.obzerv.eo
PeriodFinancialReportTask.java 91 call com.obzerv.task
PeriodFinancialReportTask.java 1 call com.obzerv.task
FutureTask.java 303 innerRun java.util.concurrent
FutureTask.java 138 run java.util.concurrent
ThreadPoolExecutor.java 895 runTask java.util.concurrent
ThreadPoolExecutor.java 918 run java.util.concurrent
Thread.java 680 run java.lang
NA : Non applicable, JIT activated
Louis Demers eng.
www.obzerv.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
