Problems creating jbossportal database content.
svaret Jan 23, 2006 8:26 AMHi there,
I use jboss-portal-2.0-jboss-4.0.2 and MySQL 4.0.22 that I understand that version of jboss portal was tested with. When I try to create content in the jbossportal database I get an error. The stack-trace includes the create table statements that I copied and tested directly in MySQL and it works!
Anyone with an idea what could be the problem?
Best regards Lasse
Stacktrace
14:06:53,447 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
14:06:53,447 INFO [Configuration] processing extends queue
14:06:53,447 INFO [Configuration] processing collection mappings
14:06:53,447 INFO [Configuration] processing association property references
14:06:53,447 INFO [Configuration] processing foreign key constraints
14:06:53,447 INFO [Configuration] processing extends queue
14:06:53,447 INFO [Configuration] processing collection mappings
14:06:53,447 INFO [Configuration] processing association property references
14:06:53,447 INFO [Configuration] processing foreign key constraints
14:06:53,457 INFO [SchemaExport] Running hbm2ddl schema export
14:06:53,457 INFO [SchemaExport] exporting generated schema to database
14:06:53,457 INFO [NamingHelper] JNDI InitialContext properties:{}
14:06:53,457 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
14:06:53,457 INFO [SchemaExport] schema export complete
14:07:11,483 INFO [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect
14:07:11,483 INFO [Configuration] processing extends queue
14:07:11,483 INFO [Configuration] processing collection mappings
14:07:11,483 INFO [Configuration] processing association property references
14:07:11,483 INFO [Configuration] processing foreign key constraints
14:07:11,493 INFO [Configuration] processing extends queue
14:07:11,493 INFO [Configuration] processing collection mappings
14:07:11,493 INFO [Configuration] processing association property references
14:07:11,493 INFO [Configuration] processing foreign key constraints
14:07:11,493 INFO [SchemaExport] Running hbm2ddl schema export
14:07:11,493 INFO [SchemaExport] exporting generated schema to database
14:07:11,493 INFO [NamingHelper] JNDI InitialContext properties:{}
14:07:11,493 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
14:07:11,503 ERROR [SchemaExport] Unsuccessful: create table jbp_roles (jbp_rid integer not null auto_incremen
t, jbp_name varchar(255) unique, jbp_displayname varchar(255) unique, primary key (jbp_rid))
14:07:11,503 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_roles (jbp_r
id integer not null auto_increment]
14:07:11,503 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref (jbp_id integer not null auto_incre
ment, jbp_name varchar(255) not null, jbp_type integer, jbp_set_id integer, primary key (jbp_id))
14:07:11,503 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref (j
bp_id integer not null auto_increment]
14:07:11,513 ERROR [SchemaExport] Unsuccessful: create table jbp_user_pref_set (jbp_id integer not null auto_i
ncrement, jbp_parent_id integer, name varchar(255) not null, primary key (jbp_id))
14:07:11,513 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_user_pref_se
t (jbp_id integer not null auto_increment]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: create table jbp_users (jbp_uid integer not null auto_incremen
t, jbp_root_pref_set_id integer, jbp_uname varchar(255) unique, jbp_givenname varchar(255), jbp_familyname var
char(255), jbp_password varchar(255), jbp_realemail varchar(255), jbp_fakeemail varchar(255), jbp_regdate date
time, jbp_viewrealemail bit, jbp_enabled bit, primary key (jbp_uid))
14:07:11,523 ERROR [SchemaExport] Unexpected token: AUTO_INCREMENT in statement [create table jbp_users (jbp_u
id integer not null auto_increment]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738A7430374 (
jbp_rid), add constraint FKF4101738A7430374 foreign key (jbp_rid) references jbp_roles (jbp_rid)
14:07:11,523 ERROR [SchemaExport] Wrong data type: FKF4101738A7430374 in statement [alter table jbp_role_membe
rship add index FKF4101738A7430374]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_role_membership add index FKF4101738E70E4BD7 (
jbp_uid), add constraint FKF4101738E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
14:07:11,523 ERROR [SchemaExport] Wrong data type: FKF4101738E70E4BD7 in statement [alter table jbp_role_membe
rship add index FKF4101738E70E4BD7]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref add index FK93CC44D0AF499A90 (jbp_se
t_id), add constraint FK93CC44D0AF499A90 foreign key (jbp_set_id) references jbp_user_pref_set (jbp_id)
14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USER_PREF in statement [alter table jbp_user_pref]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_prop_value add index FKC4963064D50D5
281 (jbp_prop_id), add constraint FKC4963064D50D5281 foreign key (jbp_prop_id) references jbp_user_pref (jbp_i
d)
14:07:11,523 ERROR [SchemaExport] Wrong data type: FKC4963064D50D5281 in statement [alter table jbp_user_pref_
prop_value add index FKC4963064D50D5281]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_pref_set add index FK97AA4873E3AFC41A (jb
p_parent_id), add constraint FK97AA4873E3AFC41A foreign key (jbp_parent_id) references jbp_user_pref_set (jbp_
id)
14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USER_PREF_SET in statement [alter table jbp_user_pref_s
et]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_user_prop add index FK93CC4610E70E4BD7 (jbp_ui
d), add constraint FK93CC4610E70E4BD7 foreign key (jbp_uid) references jbp_users (jbp_uid)
14:07:11,523 ERROR [SchemaExport] Wrong data type: FK93CC4610E70E4BD7 in statement [alter table jbp_user_prop
add index FK93CC4610E70E4BD7]
14:07:11,523 ERROR [SchemaExport] Unsuccessful: alter table jbp_users add index FKF6060141FD4AFF8F (jbp_root_p
ref_set_id), add constraint FKF6060141FD4AFF8F foreign key (jbp_root_pref_set_id) references jbp_user_pref_set
(jbp_id)
14:07:11,523 ERROR [SchemaExport] Table not found: JBP_USERS in statement [alter table jbp_users]
14:07:11,523 INFO [SchemaExport] schema export complete