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