[jboss-jira] [JBoss JIRA] Resolved: (JBPORTAL-1502) MySQL Keyword in Create Statements

MySQL Keyword in Create Statements ---------------------------------- Key: JBPORTAL-1502 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1502 Project: JBoss Portal Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: 2.6 CR3 Environment: MySQL 5.0, JBoss AS 4.2.0, Java 1.5.0_11 Reporter: Reinhard Brandstaedter When deploying JBoss Portal HA in an existing JBoss 4.2.0 Cluster Configuration I get the following error during the creation of the Database: 2007-06-25 13:28:06,289 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table JBP_REG_PROP_DESC (PK bigint not null auto_increment, name varchar(255) not null, type varchar(255) not null, SCHEMA varchar(255), DESC_VALUE varchar(255), DESC_LOCALE varchar(255), DESC_RES varchar(255), HINT_VALUE varchar(255), HINT_LOCALE varchar(255), HINT_RES varchar(255), LABEL_VALUE varchar(255), LABEL_LOCALE varchar(255), LABEL_RES varchar(255), primary key (PK)) This SQL Statement uses a MySQL Keyword "SCHEMA" and thus fails. See: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html