[esb-issues] [JBoss JIRA] Updated: (JBESB-2564) Change the default value of ExistsSql
[
https://jira.jboss.org/jira/browse/JBESB-2564?page=com.atlassian.jira.plu...
]
Kevin Conner updated JBESB-2564:
--------------------------------
Fix Version/s: 4.6
(was: 4.4 CP3)
Affects Version/s: 4.5
(was: 4.4 CP2)
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.5
Reporter: Taro Yasuma
Fix For: 4.6
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