[jboss-jira] [JBoss JIRA] Closed: (JBAS-4257) Jboss fails to start with MySQL due to case sensitive issue

Jboss fails to start with MySQL due to case sensitive issue ----------------------------------------------------------- Key: JBAS-4257 URL: http://jira.jboss.com/jira/browse/JBAS-4257 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: Scheduling/Timers Affects Versions: JBossAS-4.0.5.GA Environment: Difference between Windows and Unix based. Reporter: Benoit Xhenseval Assigned To: Dimitris Andreadis Fix For: JBossAS-4.2.0.GA, JBossAS-5.0.0.Beta3, JBossAS-4.0.5.SP1 Hi, Here is a case whereby the HARDCODED table name in org.jboss.ejb.txttimer GeneralPurposeDatabasePersistencePlugin is causing a problem. Facts: --------- 1) MySQL is case SENSITIVE for database and table names under any OS, except Windows! 2) Since MySQL 4.0, all tables are created in lowercase regardless of the script 3) GeneralPurposeDatabasePersistencePlugin hardcodes the table TIMERS to be upper case. Environment: -------------------- 1) Development happens under windows, hence all tables are in lower case 'timers' 2) Deployment will be on UNIX 3) the deployment database is created from a MySQL BACKUP of a development/test environment which is under Windows. 4) For extra security, Jboss will run with a datasource that CANNOT create a table Issue: --------- * the backup will contain only lowercase tables * JBoss will try to see if table TIMERS exists but because of the case, will not find it * JBoss then tries to create it, but will not be able to do so! Resolution: ---------------- * In order to be truly portable, all scripts should use lower case for tables/databases. * Ideally externalise the creation but otherwise, just use "timers" in lowercase * Similar issue exist in the jms jboss-service.xml with JMS_MESSAGES etc. I would suggest changing the scripts to be in lower case. Thanks