Hi,
I don't understand, how to access to cmr field of 'SoFoo'?
Foo
|
SoFoo
16:50:47,890 ERROR [EntityContainer] Starting failed
org.jboss.deployment.DeploymentException:
Error compiling EJB-QL statement 'SELECT DISTINCT OBJECT(s) FROM SoFoo
s, IN(s.Foo) f WHERE f.Id=?1 AND s.Value=?2';
- nested throwable:
(org.jboss.ejb.plugins.cmp.ejbql.UnknownPathException:
Unknown terminal field: at line 1, column 50. Encountered: "Foo" after:
"s.")
Best regards, Laurent.
My ejb-jar.xml:
-----------------
<!-- SoFoo -->
<entity>
<ejb-name>SoFooEJB</ejb-name>
<local-home>com.example.SoFooLocalHome</local-home>
<local>com.example.SoFoo</local>
<ejb-class>com.example.SoFooBean</ejb-class>
<persistence-type>Container</persistence-type>
<prim-key-class>java.lang.Integer</prim-key-class>
<reentrant>False</reentrant>
<cmp-version>2.x</cmp-version>
<abstract-schema-name>Scenario</abstract-schema-name>
<cmp-field>
<field-name>Id</field-name>
</cmp-field>
<cmp-field>
<field-name>Value</field-name>
</cmp-field>
<cmp-field>
<field-name>Timestamp</field-name>
</cmp-field>
<primkey-field>Id</primkey-field>
<resource-ref>
<res-ref-name>jdbc/PostgresDS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
<query>
<query-method>
<method-name>findAll</method-name>
<method-params/>
</query-method>
<ejb-ql>
<![CDATA[SELECT OBJECT(s) FROM SoFoo AS s]]>
</ejb-ql>
</query>
<query>
<query-method>
<method-name>findByTmIdAndValeur</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<ejb-ql>
<![CDATA[SELECT DISTINCT OBJECT(s) FROM SoFoo s,
IN(s.Foo) f WHERE f.Id=?1 AND s.Value=?2]]>
</ejb-ql>
</query>
</entity>
-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
