JBOSS CMP No Select Before Insert

[sachinvidwans]

Hello,

I am using jboss3.2.3 on Linux.

There was a previous post about the "no-select-before-insert" entity command in this forum. This to avoid the select count(*) queries before inserts.

From what I understood setting this requires the following.
In the standardjbosscmp-jdbx.xml file

Under defaults set
<entity-command name="no-select-before-insert"/>

and

under entity-commands

<!-- variation on default that skips select before insert -->
<entity-command name="no-select-before-insert"
class="org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand">
<attributename="SQLExceptionProcessor">jboss.jdbc:service=SQLException
Processor
</entity-command>

Note: In the real XML file there is a space between "attribute" and "name"

After this setting I still see the the select count(*) queries in the server.log file. Am I missing something ?

Thanks for your help.

[aloubyansky]

Changing the entity-command in defaults of standardjbosscmp-jdbc.xml is enough. I just tried it.

[stephanenicoll]

Can this be done on an entity per entity basis?

Regards,

Stephane

[aloubyansky]

Sure

<!ELEMENT entity (ejb-name, (datasource, datasource-mapping)?, create-table?,
 remove-table?, post-table-create?, read-only?, read-time-out?,
 row-locking?, pk-constraint?, read-ahead?, list-cache-max?, fetch-size?,
 table-name?, cmp-field*, load-groups?, eager-load-group?,
 lazy-load-groups?, query*, unknown-pk?, entity-command?,
 optimistic-locking?, audit?)>

[doshiaj]

how can we avoid these select before insert in jboss 2.4?