|
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.
..."
|
|
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 :
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>nxuidsequencer</jndi-name>
<connection-url>jdbc:mysql://Microsrv99:3306/nxuidsequencer</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<user-name>nxuidsequencer</user-name>
<password>nxuidsequencer</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
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] 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 (ID), unique (key))' at line 1
2007-03-13 16:19:30,782 INFO [org.hibernate.tool.hbm2ddl.SchemaUpdate] schema update complete
2007-03-13 16:19:30,782 DEBUG [org.hibernate.impl.SessionFactoryImpl] obtaining JTA TransactionManager
2007-03-13 16:19:30,782 INFO [org.hibernate.util.NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
2007-03-13 16:19:30,782 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named HQL queries
2007-03-13 16:19:30,782 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
2007-03-13 16:19:30,782 DEBUG [org.jboss.ejb3.ServiceDelegateWrapper] Started persistence.units:ear=nuxeo.ear,jar=nxuidsequencer.jar,unitName=NXUIDSequencer
2007-03-13 16:19:30,782 DEBUG [org.jboss.system.ServiceController] Starting dependent components for: persistence.units:ear=nuxeo.ear,jar=nxuidsequencer.jar,unitName=NXUIDSequencer dependent components: []
2007-03-13 16:19:30,782 DEBUG [org.jboss.ejb3.EJBContainer] Initialising interceptors for UIDSequencerManagerBean...
|
|
|
|