[esb-issues] [JBoss JIRA] Closed: (JBESB-2564) Change the default value of ExistsSql
[
https://jira.jboss.org/jira/browse/JBESB-2564?page=com.atlassian.jira.plu...
]
Kevin Conner closed JBESB-2564.
-------------------------------
Resolution: Done
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
Assignee: Kevin Conner
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