[esb-issues] [JBoss JIRA] Created: (JBESB-1476) 'Column lenght too short' SQL errors when deploying management console with mysql on Linux

[Bernard Tison (JIRA)]

'Column lenght too short' SQL errors when deploying management console with mysql on Linux
------------------------------------------------------------------------------------------

                 Key: JBESB-1476
                 URL: http://jira.jboss.com/jira/browse/JBESB-1476
             Project: JBoss ESB
          Issue Type: Bug
      Security Level: Public (Everyone can see)
    Affects Versions: 4.2.1
         Environment: OS: Fedora 8
RDBMS: MySQL 5.0.45
            Reporter: Bernard Tison


in the create_database.sql script in /console/management-esb/src/main/resources/mysql the JMXDATA.textvalue column is defined as varchar(255). This length is too short for certain messages, leading to SQL errors when trying to persist those messages.

Setting the datatype of the JMXDATA.textvalue to text instead of varchar(255) seems top solve the problem.

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