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

[Kevin Conner (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBESB-2564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12472790#action_12472790 ] 

Kevin Conner commented on JBESB-2564:
-------------------------------------

Updated in revision 27014.

> 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