10 Replies Latest reply on Oct 27, 2003 11:41 AM by Marius Kotsbak

    Can't get "no-select-before-insert" to work

    Nigel Birch Newbie

      Hi,

      I'm trying to eliminate the "SELECT COUNT(*) FROM XX WHERE PrimaryKey=YY" that JBoss uses to test for an already existing bean in the table. So I'm enabling the "no-select-before-insert" command in standardjbosscmp-jdbc.xml in the defaults section at the top of the file, as follows:

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


      My deploy/sqlexception-service.xml file contains the default content:

      <?xml version="1.0" encoding="UTF-8"?>






      When I run jboss the server.log shows the following:

      16:46:07,291 INFO [MainDeployer] Starting deployment of package: file:/opt/fpdirector-3.2.1/jboss/server/fpdirector/deploy/sqlexception-service.xml
      16:46:07,326 INFO [MainDeployer] Deployed package: file:/opt/fpdirector-3.2.1/jboss/server/fpdirector/deploy/sqlexception-service.xml

      It doesn't say "Creating or Starting" so did it really start the SQLExceptionProcessor MBean??

      Has anyone managed to get no-select-before-insert to work??

      Thanks
      NBirch