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

[ https://jira.jboss.org/jira/browse/JBESB-2563?page=com.atlassian.jira.plu... ] Kevin Conner updated JBESB-2563: -------------------------------- Fix Version/s: 4.4 CP3 (was: 4.4 FP1) Affects Version/s: 4.4 CP2 (was: 4.4) Description: 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. was: 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". Assignee: (was: Daniel Bevenius) -- 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