[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Reopened Priority: Major Assignee: Florent Guillaume Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 22/03/07 16:32 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Florent Guillaume Date: 22/03/07 16:32 Comment: Ok the unique constraint was forgotten in the conversion, could you confirm this is better now? Project: Nuxeo Enterprise Platform 5 Components: Core Affects Versions: 5.1 M1 Fix Versions: 5.1 M2 Description I modified data source nxuidsequencer-ds.xml in deployment dir. so that it connects to a MySQL DB but I get hibernate errors. Here is my ds file : nxuidsequencer jdbc:mysql://Microsrv99:3306/nxuidsequencer com.mysql.jdbc.Driver nxuidsequencer nxuidsequencer org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL here are the errors : 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Y
[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Resolved Priority: Major Resolution: Fixed Assignee: Dragos Mihalache Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 19/03/07 17:09 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Vincent Dutat Date: 19/03/07 17:09 Comment: I still got errors : 2007-03-19 17:05:56,981 DEBUG [org.hibernate.validator.ClassValidator] ResourceBundle ValidatorMessages not found in Validator classloader. Delegate to org.hibernate.validator.resources.DefaultValidatorMessages 2007-03-19 17:05:56,996 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-19 17:05:56,996 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-19 17:05:56,996 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (SEQ_ID integer not null auto_increment, key varchar(255), index integer not null, primary key (SEQ_ID), unique (key)) 2007-03-19 17:05:57,012 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table UID_SEQUENCE (SEQ_ID integer not null auto_increment, key varchar(255), index integer not null, primary key (SEQ_ID), unique (key)) 2007-03-19 17:05:57,012 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar(255), index integer not null, primary key (SEQ_ID), unique (key))' at line 1 2007-03-19 17:05:57,012 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] schema update complete 2007-03-19 17:05:57,012 DEBUG [org.hibernate.impl.SessionFactoryImpl] obtaining JTA TransactionManager
[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Resolved Priority: Major Resolution: Fixed Assignee: Dragos Mihalache Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 19/03/07 11:43 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Vincent Dutat Date: 19/03/07 11:43 Comment: PLS ignore my last comment, I have just seen you commited changes. Thanks. Project: Nuxeo Enterprise Platform 5 Components: Core Affects Versions: 5.1 M1 Fix Versions: 5.1 M2 Description I modified data source nxuidsequencer-ds.xml in deployment dir. so that it connects to a MySQL DB but I get hibernate errors. Here is my ds file : nxuidsequencer jdbc:mysql://Microsrv99:3306/nxuidsequencer com.mysql.jdbc.Driver nxuidsequencer nxuidsequencer org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL here are the errors : 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index
[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Resolved Priority: Major Resolution: Fixed Assignee: Dragos Mihalache Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 19/03/07 11:40 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Vincent Dutat Date: 19/03/07 11:40 Comment: Are the changes described in http://svn.nuxeo.org/trac/nuxeo/changeset/12189 enough ? Project: Nuxeo Enterprise Platform 5 Components: Core Affects Versions: 5.1 M1 Fix Versions: 5.1 M2 Description I modified data source nxuidsequencer-ds.xml in deployment dir. so that it connects to a MySQL DB but I get hibernate errors. Here is my ds file : nxuidsequencer jdbc:mysql://Microsrv99:3306/nxuidsequencer com.mysql.jdbc.Driver nxuidsequencer nxuidsequencer org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL here are the errors : 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(2
[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Open Priority: Major Assignee: Dragos Mihalache Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 19/03/07 11:07 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Vincent Dutat Date: 19/03/07 11:07 Comment: Here is an extract of a Florent's email at the time of the discussion : "... Regarding the UID_SEQUENCE and reserved words, we had a temporary patch but reverted it because changing these column names means an existing 5.0.0 installation would lose its counters. We have to design a migration tool for that. However if you want to test it you can see it at: http://svn.nuxeo.org/trac/nuxeo/changeset/12189 Dragos can maybe say more. ..." Project: Nuxeo Enterprise Platform 5 Components: Core Affects Versions: 5.1 M1 Fix Versions: 5.1 M2 Description I modified data source nxuidsequencer-ds.xml in deployment dir. so that it connects to a MySQL DB but I get hibernate errors. Here is my ds file : nxuidsequencer jdbc:mysql://Microsrv99:3306/nxuidsequencer com.mysql.jdbc.Driver nxuidsequencer nxuidsequencer org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL here are the errors : 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer
[JIRA] Commented: (NXP-773) nxuidsequencer database not possible with MySQL
Issue (View Online) Key: NXP-773 Issue Type: Bug Status: Open Priority: Major Assignee: Dragos Mihalache Reporter: Vincent Dutat Environment: Windows XP, JBoss 4.0.4GA Operations View all View comments View history nxuidsequencer database not possible with MySQL Updated: 19/03/07 10:59 Created: 13/03/07 16:28 The following comment has been added to this issue: [ Permlink ] Author: Dragos Mihalache Date: 19/03/07 10:59 Comment: I reverted because there was a discussion at that time over an upgrade procedure. I don't recall exactly the reason... Project: Nuxeo Enterprise Platform 5 Components: Core Affects Versions: 5.1 M1 Fix Versions: 5.1 M2 Description I modified data source nxuidsequencer-ds.xml in deployment dir. so that it connects to a MySQL DB but I get hibernate errors. Here is my ds file : nxuidsequencer jdbc:mysql://Microsrv99:3306/nxuidsequencer com.mysql.jdbc.Driver nxuidsequencer nxuidsequencer org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter mySQL here are the errors : 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.DatabaseMetadata] table not found: UID_SEQUENCE 2007-03-13 16:19:30,782 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table UID_SEQUENCE (ID integer not null auto_increment, key varchar(255), index integer not null, primary key (ID), unique (key)) 2007-03-13 16:19:30,782 ERROR [org.hibernate.tool.hbm2ddl.
