EJB-QL and JBosscmp-jdbc.xml

[eusdart]

Hello,
When creating CMR and EJB-QL for ejb 2.0 entity beans do I need to include the query tags in JBosscmp-jdbc.xml or will JBoss 3.0.0 use the query tags that are defined in the ejb-jar.xml file? I have attached a sample of one such ejb query from the ejb-jar.xml file:


<query-method>
<method-name>ejbSelectChannelPrograms</method-name>
<method-params>
<method-param>java.lang.Integer</method-param>
</method-params>
</query-method>
<result-type-mapping>Local</result-type-mapping>
<ejb-ql>SELECT Object(p) From ProgramTable AS p Where Channel.chanid = key AND p.chanid = key</ejb-ql>


I use a JBoss 3.x plug-in for JBuilder 6/7 which generates the standard JBosscmp-jdbx.xml and Jboss.xml files, but it does not generate anything special in the jboss xml files for query and cmr tags and I am unsure whether special tags are required for CMR and EJB-QL in either of the 2 jboss xml file.

Thanks for any help clarifying the JBoss requirements.

[dsundstrom]

> When creating CMR and EJB-QL for ejb 2.0 entity beans
> do I need to include the query tags in
> JBosscmp-jdbc.xml or will JBoss 3.0.0 use the query
> tags that are defined in the ejb-jar.xml file?

No you do not have to include them in the jbosscmp-jdbc.xml file. Jboss will use the query specified in the ejb-jar.xml file.

> I use a JBoss 3.x plug-in for JBuilder 6/7 which
> generates the standard JBosscmp-jdbx.xml and
> Jboss.xml files, but it does not generate anything
> special in the jboss xml files for query and cmr tags
> and I am unsure whether special tags are required for
> CMR and EJB-QL in either of the 2 jboss xml file.

I do not know anything about the JBuilder plugin.