1 Reply Latest reply on Jul 2, 2002 6:17 PM by Dain Sundstrom

    EJB-QL and JBosscmp-jdbc.xml

    Darryl Thompson Newbie

      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.

        • 1. Re: EJB-QL and JBosscmp-jdbc.xml
          Dain Sundstrom Master

          > 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.