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

'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) Components: Management Affects Versions: 4.2.1 Environment: OS: Fedora 8 RDBMS: MySQL 5.0.45 Reporter: Bernard Tison Assigned To: Tom Cunningham Fix For: 4.2.1 CP1 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.