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

Mon Jun 25 09:00:16 EDT 2007

     [ http://jira.jboss.com/jira/browse/JBPORTAL-1502?page=all ]

Reinhard Brandstaedter updated JBPORTAL-1502:
---------------------------------------------

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

  was:
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.

> 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

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