users@glassfish.java.net

Re: New problems with EJB-QL when migrating from weblogic to glassfish

From: <glassfish_at_javadesktop.org>
Date: Fri, 25 Jul 2008 09:08:42 PDT

JMarine,

I'm getting the following error when I call the ejb-ql finder method. The query is

SELECT OBJECT(cr) FROM CategoryRoot cr, Catalog ca WHERE cr NOT MEMBER OF ca.categoryRoots AND ca.catalogId = ?1

[#|2008-07-25T10:31:19.366-0500|INFO|sun-appserver9.1|javax.enterprise.system.stream.out|_ThreadID=16;_ThreadName=httpSSLWorkerThread-7001-0;|10:31:19,366 awardslinqAdmin.AlAdminExceptionHandler - Exception thrown from bean; nested exception is: com.sun.jdo.api.persistence.support.JDOFatalInternalException: JDO76101: The field catalogId is not associated with any table.
javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean; nested exception is: com.sun.jdo.api.persistence.support.JDOFatalInternalException: JDO76101: The field catalogId is not associated with any table.
com.sun.jdo.api.persistence.support.JDOFatalInternalException: JDO76101: The field catalogId is not associated with any table.
        at com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.Statement.generateColumnText(Statement.java:416)
        at com.sun.jdo.spi.persistence.support.sqlstore.sql.generator.Statement.processConstraintField(Statement.java:380)

I've checked the sun-cmp-mappings.xml for the EJB Catalog and the column catalogId is bound to a table.

Thanks
Suneel
[Message sent by forum member 'suneelgv' (suneelgv)]

http://forums.java.net/jive/thread.jspa?messageID=289394