[esb-issues] [JBoss JIRA] Created: (JBESB-2564) Change the default value of ExistsSql

Thu May 14 09:26:46 EDT 2009

Change the default value of ExistsSql
-------------------------------------

                 Key: JBESB-2564
                 URL: https://jira.jboss.org/jira/browse/JBESB-2564
             Project: JBoss ESB
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: Configuration
    Affects Versions: 4.4 CP2
            Reporter: Taro Yasuma
             Fix For: 4.4 CP3

Please change the default value of ExistsSql to gain performance to initialize DatabaseInitializer.
The current jbossesb.esb/jbossesb-service.xml is like:

<server>
  <mbean code="org.jboss.internal.soa.esb.dependencies.DatabaseInitializer"
      name="jboss.esb:service=MessageStoreDatabaseInitializer">
...
     <attribute name="ExistsSql">select * from message</attribute>
 ...
  </mbean>
</server>

But it should be "select count(*) from message".

Should also check for other occurrences.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira