I'm not sure why that would happen. This is strange, the dialects are getting mixed somewhere. Are you sure your components don't use a datasource name that's already used by workflow-jbpm? Or that there's a System property holding some dialect?
Julien, any idea?

Florent

On 10 Apr 2007, at 22:57, Vincent Dutat wrote:

Hi Florent,

when I run Nuxeo without any of my components, no problem (you could say "of course..." ;-) ). My components access a MySQL database. So, as soon as I deploy one of my components, I get exceptions when hibernate creates table(s) for workflow-jbpm. See logs below. Soryy for the late reply, the mailing list seems to be very slow today...

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection

2007-04-10 16:12:26,830 DEBUG [org.hibernate.SQL] insert into JBPM_PROCESSDEFINITION (NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_) values (?, ?, ?, ?)

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to close PreparedStatement (open PreparedStatements: 1, globally: 1)

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.ConnectionManager] aggressively releasing JDBC connection

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.ConnectionManager] releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)

2007-04-10 16:12:26,830 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection

2007-04-10 16:12:26,830 DEBUG [org.hibernate.SQL] select last_insert_id()

2007-04-10 16:12:26,830 DEBUG [org.hibernate.util.JDBCExceptionReporter] could not retrieve generated id after insert: [org.jbpm.graph.def.ProcessDefinition] [insert into JBPM_PROCESSDEFINITION (NAME_, VERSION_, ISTERMINATIONIMPLICIT_, STARTSTATE_) values (?, ?, ?, ?)]

java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [select last_insert_id()]

        at org.hsqldb.jdbc.Util.throwError(Unknown Source)

        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepare Statement(BaseWrapperManagedConnection.java:349)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareSt atement(BaseWrapperManagedConnection.java:344)

at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement (WrappedConnection.java:187)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement (AbstractBatcher.java:497)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:94)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:87)

at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert (AbstractSelectingDelegate.java:52)

at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2044)

at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2481)

at org.hibernate.action.EntityIdentityInsertAction.execute (EntityIdentityInsertAction.java:47)

        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)

at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplica te(AbstractSaveEventListener.java:290)

at org.hibernate.event.def.AbstractSaveEventListener.performSave (AbstractSaveEventListener.java:180)

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId( AbstractSaveEventListener.java:108)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGener atedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)

at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRe questedId(DefaultSaveEventListener.java:33)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTrans ient(DefaultSaveOrUpdateEventListener.java:175)

at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate (DefaultSaveEventListener.java:27)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdat e(DefaultSaveOrUpdateEventListener.java:70)

        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:537)

        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:525)

        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:521)

at org.jbpm.db.GraphSession.deployProcessDefinition (GraphSession.java:77)

        at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)

at org.nuxeo.ecm.platform.workflow.jbpm.JbpmWorkflowEngine.deployDefiniti on(JbpmWorkflowEngine.java:103)

at org.nuxeo.ecm.platform.workflow.service.WorkflowServiceImpl.deployDefi nition(WorkflowServiceImpl.java:200)

at org.nuxeo.ecm.platform.workflow.service.WorkflowServiceImpl.registerEx tension(WorkflowServiceImpl.java:133)

at org.nuxeo.runtime.model.impl.ComponentInstanceImpl.registerExtension (ComponentInstanceImpl.java:144)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl.registerExtension (ComponentManagerImpl.java:322)

at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.activate (RegistrationInfoImpl.java:257)

at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.resolve (RegistrationInfoImpl.java:303)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl._register (ComponentManagerImpl.java:168)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl.register (ComponentManagerImpl.java:134)

at org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy (DefaultRuntimeContext.java:88)

at org.nuxeo.runtime.osgi.OSGiRuntimeService.loadComponents (OSGiRuntimeService.java:105)

at org.nuxeo.runtime.osgi.OSGiRuntimeService.createContext (OSGiRuntimeService.java:66)

at org.nuxeo.runtime.osgi.OSGiComponentLoader.bundleChanged (OSGiComponentLoader.java:75)

        at org.nuxeo.osgi.OSGiAdapter.fireBundleEvent(OSGiAdapter.java:157)

        at org.nuxeo.osgi.AbstractBundle.setResolved(AbstractBundle.java:204)

        at org.nuxeo.osgi.BundleRegistry.doRegister(BundleRegistry.java:154)

        at org.nuxeo.osgi.BundleRegistry.register(BundleRegistry.java:111)

        at org.nuxeo.osgi.BundleRegistry.install(BundleRegistry.java:72)

        at org.nuxeo.osgi.OSGiAdapter.install(OSGiAdapter.java:104)

at org.nuxeo.runtime.jboss.osgi.JBossOSGiAdapter.installBundle (JBossOSGiAdapter.java:82)

at org.nuxeo.runtime.jboss.osgi.JBossOSGiAdapter.handleNotification2 (JBossOSGiAdapter.java:179)

at org.jboss.system.ListenerServiceMBeanSupport.handleNotification (ListenerServiceMBeanSupport.java:403)

        at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.notification.NotificationListenerProxy.invoke (NotificationListenerProxy.java:153)

        at $Proxy64.handleNotification(Unknown Source)

at org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotificati on(JBossNotificationBroadcasterSupport.java:127)

at org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification (JBossNotificationBroadcasterSupport.java:110)

at org.jboss.deployment.SubDeployerSupport.emitNotification (SubDeployerSupport.java:340)

at org.jboss.deployment.SubDeployerSupport.start (SubDeployerSupport.java:308)

        at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:460)

        at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

at org.jboss.mx.interceptor.DynamicInterceptor.invoke (DynamicInterceptor.java:97)

at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext (InterceptorServiceMBeanSupport.java:238)

at org.jboss.ws.server.WebServiceDeployer.start (WebServiceDeployer.java:117)

at org.jboss.deployment.SubDeployerInterceptorSupport $XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)

at org.jboss.deployment.SubDeployerInterceptor.invoke (SubDeployerInterceptor.java:95)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy41.start(Unknown Source)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy15.deploy(Unknown Source)

at org.nuxeo.runtime.jboss.deployment.NuxeoDeployer.start (NuxeoDeployer.java:209)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)

        at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy6.deploy(Unknown Source)

at org.jboss.deployment.scanner.URLDeploymentScanner.deploy (URLDeploymentScanner.java:421)

at org.jboss.deployment.scanner.URLDeploymentScanner.scan (URLDeploymentScanner.java:634)

at org.jboss.deployment.scanner.AbstractDeploymentScanner $ScannerThread.doScan(AbstractDeploymentScanner.java:263)

at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService (AbstractDeploymentScanner.java:336)

at org.jboss.system.ServiceMBeanSupport.jbossInternalStart (ServiceMBeanSupport.java:289)

at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle (ServiceMBeanSupport.java:245)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

at org.jboss.system.ServiceController$ServiceProxy.invoke (ServiceController.java:978)

        at $Proxy0.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java: 417)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy4.start(Unknown Source)

        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy5.deploy(Unknown Source)

        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)

        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)

        at org.jboss.Main.boot(Main.java:200)

        at org.jboss.Main$1.run(Main.java:464)

        at java.lang.Thread.run(Thread.java:595)

2007-04-10 16:12:26,830 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: -11, SQLState: 37000

2007-04-10 16:12:26,830 ERROR [org.hibernate.util.JDBCExceptionReporter] Unexpected token: LAST_INSERT_ID in statement [select last_insert_id()]

2007-04-10 16:12:26,830 ERROR [org.nuxeo.runtime.model.ComponentManager] Failed to create the component service:org.nuxeo.ecm.platform.workflow.DefaultWorkflowDefinitionContr ibutions

org.hibernate.exception.SQLGrammarException: could not retrieve generated id after insert: [org.jbpm.graph.def.ProcessDefinition]

at org.hibernate.exception.SQLStateConverter.convert (SQLStateConverter.java:67)

at org.hibernate.exception.JDBCExceptionHelper.convert (JDBCExceptionHelper.java:43)

at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert (AbstractSelectingDelegate.java:69)

at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2044)

at org.hibernate.persister.entity.AbstractEntityPersister.insert (AbstractEntityPersister.java:2481)

at org.hibernate.action.EntityIdentityInsertAction.execute (EntityIdentityInsertAction.java:47)

        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)

at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplica te(AbstractSaveEventListener.java:290)

at org.hibernate.event.def.AbstractSaveEventListener.performSave (AbstractSaveEventListener.java:180)

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId( AbstractSaveEventListener.java:108)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGener atedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)

at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRe questedId(DefaultSaveEventListener.java:33)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTrans ient(DefaultSaveOrUpdateEventListener.java:175)

at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate (DefaultSaveEventListener.java:27)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdat e(DefaultSaveOrUpdateEventListener.java:70)

        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:537)

        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:525)

        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:521)

at org.jbpm.db.GraphSession.deployProcessDefinition (GraphSession.java:77)

        at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)

at org.nuxeo.ecm.platform.workflow.jbpm.JbpmWorkflowEngine.deployDefiniti on(JbpmWorkflowEngine.java:103)

at org.nuxeo.ecm.platform.workflow.service.WorkflowServiceImpl.deployDefi nition(WorkflowServiceImpl.java:200)

at org.nuxeo.ecm.platform.workflow.service.WorkflowServiceImpl.registerEx tension(WorkflowServiceImpl.java:133)

at org.nuxeo.runtime.model.impl.ComponentInstanceImpl.registerExtension (ComponentInstanceImpl.java:144)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl.registerExtension (ComponentManagerImpl.java:322)

at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.activate (RegistrationInfoImpl.java:257)

at org.nuxeo.runtime.model.impl.RegistrationInfoImpl.resolve (RegistrationInfoImpl.java:303)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl._register (ComponentManagerImpl.java:168)

at org.nuxeo.runtime.model.impl.ComponentManagerImpl.register (ComponentManagerImpl.java:134)

at org.nuxeo.runtime.model.impl.DefaultRuntimeContext.deploy (DefaultRuntimeContext.java:88)

at org.nuxeo.runtime.osgi.OSGiRuntimeService.loadComponents (OSGiRuntimeService.java:105)

at org.nuxeo.runtime.osgi.OSGiRuntimeService.createContext (OSGiRuntimeService.java:66)

at org.nuxeo.runtime.osgi.OSGiComponentLoader.bundleChanged (OSGiComponentLoader.java:75)

        at org.nuxeo.osgi.OSGiAdapter.fireBundleEvent(OSGiAdapter.java:157)

        at org.nuxeo.osgi.AbstractBundle.setResolved(AbstractBundle.java:204)

        at org.nuxeo.osgi.BundleRegistry.doRegister(BundleRegistry.java:154)

        at org.nuxeo.osgi.BundleRegistry.register(BundleRegistry.java:111)

        at org.nuxeo.osgi.BundleRegistry.install(BundleRegistry.java:72)

        at org.nuxeo.osgi.OSGiAdapter.install(OSGiAdapter.java:104)

at org.nuxeo.runtime.jboss.osgi.JBossOSGiAdapter.installBundle (JBossOSGiAdapter.java:82)

at org.nuxeo.runtime.jboss.osgi.JBossOSGiAdapter.handleNotification2 (JBossOSGiAdapter.java:179)

at org.jboss.system.ListenerServiceMBeanSupport.handleNotification (ListenerServiceMBeanSupport.java:403)

        at sun.reflect.GeneratedMethodAccessor23.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.notification.NotificationListenerProxy.invoke (NotificationListenerProxy.java:153)

        at $Proxy64.handleNotification(Unknown Source)

at org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotificati on(JBossNotificationBroadcasterSupport.java:127)

at org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification (JBossNotificationBroadcasterSupport.java:110)

at org.jboss.deployment.SubDeployerSupport.emitNotification (SubDeployerSupport.java:340)

at org.jboss.deployment.SubDeployerSupport.start (SubDeployerSupport.java:308)

        at org.jboss.ejb3.EJB3Deployer.start(EJB3Deployer.java:460)

        at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

at org.jboss.mx.interceptor.DynamicInterceptor.invoke (DynamicInterceptor.java:97)

at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext (InterceptorServiceMBeanSupport.java:238)

at org.jboss.ws.server.WebServiceDeployer.start (WebServiceDeployer.java:117)

at org.jboss.deployment.SubDeployerInterceptorSupport $XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)

at org.jboss.deployment.SubDeployerInterceptor.invoke (SubDeployerInterceptor.java:95)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy41.start(Unknown Source)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy15.deploy(Unknown Source)

at org.nuxeo.runtime.jboss.deployment.NuxeoDeployer.start (NuxeoDeployer.java:209)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)

        at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy6.deploy(Unknown Source)

at org.jboss.deployment.scanner.URLDeploymentScanner.deploy (URLDeploymentScanner.java:421)

at org.jboss.deployment.scanner.URLDeploymentScanner.scan (URLDeploymentScanner.java:634)

at org.jboss.deployment.scanner.AbstractDeploymentScanner $ScannerThread.doScan(AbstractDeploymentScanner.java:263)

at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService (AbstractDeploymentScanner.java:336)

at org.jboss.system.ServiceMBeanSupport.jbossInternalStart (ServiceMBeanSupport.java:289)

at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle (ServiceMBeanSupport.java:245)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

at org.jboss.system.ServiceController$ServiceProxy.invoke (ServiceController.java:978)

        at $Proxy0.start(Unknown Source)

at org.jboss.system.ServiceController.start(ServiceController.java: 417)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy4.start(Unknown Source)

        at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)

        at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1007)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:808)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)

        at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:755)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:25)

        at java.lang.reflect.Method.invoke(Method.java:585)

at org.jboss.mx.interceptor.ReflectedDispatcher.invoke (ReflectedDispatcher.java:155)

        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)

at org.jboss.mx.interceptor.AbstractInterceptor.invoke (AbstractInterceptor.java:133)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke (ModelMBeanOperationInterceptor.java:142)

        at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)

at org.jboss.mx.server.AbstractMBeanInvoker.invoke (AbstractMBeanInvoker.java:264)

at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java: 659)

        at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)

        at $Proxy5.deploy(Unknown Source)

        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)

        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)

        at org.jboss.Main.boot(Main.java:200)

        at org.jboss.Main$1.run(Main.java:464)

        at java.lang.Thread.run(Thread.java:595)

Caused by: java.sql.SQLException: Unexpected token: LAST_INSERT_ID in statement [select last_insert_id()]

        at org.hsqldb.jdbc.Util.throwError(Unknown Source)

        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.doPrepare Statement(BaseWrapperManagedConnection.java:349)

at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareSt atement(BaseWrapperManagedConnection.java:344)

at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement (WrappedConnection.java:187)

at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement (AbstractBatcher.java:497)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:94)

at org.hibernate.jdbc.AbstractBatcher.prepareStatement (AbstractBatcher.java:87)

at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert (AbstractSelectingDelegate.java:52)

        ... 152 more

2007-04-10 16:12:26,830 DEBUG [org.nuxeo.runtime.model.ComponentManager] Dispatching event: COMPONENT_REGISTERED: service:org.nuxeo.ecm.platform.workflow.DefaultWorkflowRulesContributi ons

2007-04-10 16:12:26,830 INFO [org.nuxeo.runtime.model.ComponentManager] Registering component: service:org.nuxeo.ecm.platform.workflow.DefaultWorkflowRulesContributi ons

2007-04-10 16:12:26,830 DEBUG [org.nuxeo.runtime.model.ComponentManager] Dispatching event: COMPONENT_RESOLVED: service:org.nuxeo.ecm.platform.workflow.DefaultWorkflowRulesContributi ons

2007-04-10 16:12:26,845 DEBUG [org.nuxeo.runtime.model.ComponentManager] Dispatching event: ACTIVATING_COMPONENT: service:org.nuxeo.ecm.platform.workflow.DefaultWorkflowRulesContributi ons


Florent Guillaume wrote:
"Unexpected token: AUTO_INCREMENT" or "Wrong data type: BLOB " means that the parser is not MySQL's, which means that somewhere you're still using hsqldb instead of mysql, probably, which doesn't know about auto_increment or blob.
Florent
On 10 Apr 2007, at 11:20, Vincent Dutat wrote:
Hi,

2007-04-10 11:11:05,799 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar (255), FILEDEFINITION_ bigint, primary key (ID_))

2007-04-10 11:11:05,799 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment, NAME_ varchar(255), FILEDEFINITION_ bigint, primary key (ID_))

2007-04-10 11:11:05,799 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unexpected token: AUTO_INCREMENT in statement [create table JBPM_BYTEARRAY (ID_ bigint not null auto_increment]

2007-04-10 11:11:05,799 DEBUG [org.hibernate.tool.hbm2ddl.SchemaUpdate] create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))

2007-04-10 11:11:05,799 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Unsuccessful: create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob, INDEX_ integer not null, primary key (PROCESSFILE_, INDEX_))

2007-04-10 11:11:05,799 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] Wrong data type: BLOB in statement [create table JBPM_BYTEBLOCK (PROCESSFILE_ bigint not null, BYTES_ blob]

--Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87

_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm


--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com   http://www.nuxeo.org   +33 1 40 33 79 87



_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

Reply via email to