[esb-issues] [JBoss JIRA] Closed: (JBESB-2563) Change the default value of ExistsSql
[
https://jira.jboss.org/jira/browse/JBESB-2563?page=com.atlassian.jira.plu...
]
Kevin Conner closed JBESB-2563.
-------------------------------
Resolution: Done
jUDDI, jBPM and jbossesb updated in revision 26574.
Change the default value of ExistsSql
-------------------------------------
Key: JBESB-2563
URL: https://jira.jboss.org/jira/browse/JBESB-2563
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