jboss 3.2.3 read-ahead, loadgroups and eager-load-group
sponiza Dec 9, 2007 3:37 PMHi 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========================