[jboss-jira] [JBoss JIRA] Updated: (JBESB-386) On Linux running jUDDI-registry/sql/mysql/create_database.sql creates the tables in UPPER-CASE

[Mark Little (JIRA)]

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

Mark Little updated JBESB-386:
------------------------------

    Assignee: Kurt Stam  (was: Mark Little)

> On Linux running jUDDI-registry/sql/mysql/create_database.sql creates the tables in UPPER-CASE
> ----------------------------------------------------------------------------------------------
>
>                 Key: JBESB-386
>                 URL: http://jira.jboss.com/jira/browse/JBESB-386
>             Project: JBoss ESB
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Registry and Repository
>            Reporter: jarkko Lietolahti
>         Assigned To: Kurt Stam
>
> On Linux running jUDDI-registry/sql/mysql/create_database.sql creates the tables in UPPER-CASE, however the default juddi-ds.xml says:
>  <check-valid-connection-sql>select count(*) from publisher</check-valid-connection-sql>
> which doesn't work on Linux/Unix OSes.
> To fix either create tables in lower case or case the check sql to use upper-case table name.
>  <check-valid-connection-sql>select count(*) from PUBLISHER</check-valid-connection-sql>

-- 
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