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

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