[esb-issues] [JBoss JIRA] Updated: (JBESB-1475) 'Table not found' errors when using management console with MySQL on Linux

[Bernard Tison (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBESB-1475?page=all ]

Bernard Tison updated JBESB-1475:
---------------------------------

    Attachment: OperationsHelper.java

> 'Table not found' errors when using management console with MySQL on Linux
> --------------------------------------------------------------------------
>
>                 Key: JBESB-1475
>                 URL: http://jira.jboss.com/jira/browse/JBESB-1475
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Management
>    Affects Versions: 4.2.1
>         Environment: OS: Fedora 8
> RDBMS: MySQL v5.0.45
>            Reporter: Bernard Tison
>         Attachments: OperationsHelper.java, StatisticsHelper.java
>
>
> When deploying the management console (management.esb) on the ESB, using MySQl as RDBMS (OS = Linux), 'Table not found' errors appear.
> Reason: the org.jboss.soa.esb.monitoring.server.StaticsHelper and org.jboss.soa.esb.monitoring.server.OperationsHelper classes use native SQL queries, in which the table names are referred in proper case. The Hibernate mapping files use upper case for the table names. Mysql on Linux is case sensitive.
> Attached are versions of the two classes where the table names in the native SQL queries use upper case. 

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira