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

Mon Jun 25 08:44:16 EDT 2007

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.

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