0 Replies Latest reply on Dec 9, 2007 3:37 PM by s f

    jboss 3.2.3 read-ahead, loadgroups and eager-load-group

    s f Newbie

      Hi all,

      I am trying to get read-ahead working for my installation. First with on-find and later with on-load. I have read and read the documentation on this, put the loadgroups-statements on different places in the jbosscmp-jdbc descriptor, but JBOSS keeps complaining about a NullPointerException in getLoadGroupMask.

      My questions:
      1. Does that mean that the eager-load-group basic is unknown?

      2. If so, where should the loadgroups-statement be put so that in can be read? Putting a <eager-load-group>basic</eager-load-group> between and gives the message that eager-load-group basic is unknown.

      3. Do you have any example complete jbosscmp-jdbc file which I could investigate?

      Any tip would be highly appreciated, part of the jbosscmp-jdbc is pasted below:

      I have tryed to paste part of the jbosscmp-jdbc.xml jar below. Unfortunately in the preview it seems to leave out some statements. Therefore I put comments in.

      ===============start===============================
      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE jbosscmp-jdbc PUBLIC "-/JBOSS//DTD JBOSSCMP-JDBC 3.2/EN" "file:/usr/jboss-3.2.3/docs/dtd/jbosscmp-jdbc_3_2.dtd">
      <jbosscmp-jdbc>
      <!-- in the defaults section the datasource and the datasource-mapping are defined, no read-ahead statements or loadgroups -->

      <!-- the enterprise definition starts. There is no information between the defaults-section and the enterprise start -->

      <enterprise-beans>

      <!-- the entity start here -->
      <ejb-name>BoekingejbStemTutorEJB</ejb-name>
      <table-name>stemtutor_table</table-name>
      <cmp-field>
      <field-name>relation_key</field-name>
      <column-name>relation_key</column-name>
      </cmp-field>
      ....
      <cmp-field>
      <field-name>update_userid</field-name>
      <column-name>update_userid</column-name>
      </cmp-field>

      <!-- after all cmp-fields a loadgroups definition -->


      <load-group-name>basic</load-group-name>
      <field-name>stemkey</field-name>
      <field-name>tutorkey</field-name>



      <!-- after the loadgroups definition the queries -->

      <query-method>
      <method-name>findByCouncilnr</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <declared-sql>
      organisationnr={0}
      tutorkey
      </declared-sql>


      <query-method>
      <method-name>findByStemKey</method-name>
      <method-params>
      <method-param>java.lang.String</method-param>
      <method-param>java.lang.String</method-param>
      </method-params>
      </query-method>
      <declared-sql>
      organisationnr={0} and stem={1}
      tutorkey
      </declared-sql>
      <read-ahead>
      on-find
      <page-size>150</page-size>
      <eager-load-group>basic</eager-load-group>
      </read-ahead>


      </enterprise-beans>
      </jbosscmp-jdbc>
      ====================end========================