Hi!! I've configured jBPM to work wih MySQL. Now, I have a problem. When I want save the instance of a process it's thrown a exception that indicates that a table doesn't exist. But ... it isn't true! The table exist!! I think that maybe the hibernate.cfg file is wrong and I have to change something in it.
Do anyone know the solution at this problem? Thanks | 00:07:35,265 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002 | 00:07:35,265 [main] ERROR JDBCExceptionReporter : Table not found in statement [insert into JBPM_TOKEN (ID_, VERSION_, NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, ISSUSPENDED_, LOCK_, NODE_, PROCESSINSTANCE_, PARENT_, SUBPROCESSINSTANCE_) values (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] | 00:07:35,265 [main] DEBUG JbpmContext : closing jbpmContext [EMAIL PROTECTED] | 00:07:35,265 [main] DEBUG Services : closing service 'persistence': [EMAIL PROTECTED] | 00:07:35,265 [main] DEBUG DbPersistenceService : committing hibernate transaction [EMAIL PROTECTED] | 00:07:35,281 [main] WARN JDBCExceptionReporter : SQL Error: -22, SQLState: S0002 | 00:07:35,281 [main] ERROR JDBCExceptionReporter : Table not found in statement [insert into JBPM_MODULEINSTANCE (ID_, VERSION_, PROCESSINSTANCE_, CLASS_) values (null, ?, ?, 'C')] | 00:07:35,281 [main] ERROR DbPersistenceService : hibernate commit failed | org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.context.exe.ContextInstance] | 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:40) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) | at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) | at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) | at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) | at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) | at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) | at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) | at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) | at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218) | at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169) | at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296) | at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169) | at org.hibernate.engine.Cascade.cascade(Cascade.java:130) | at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131) | at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122) | at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65) | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) | at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) | at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) | at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:256) | at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:214) | at org.jbpm.svc.Services.close(Services.java:225) | at org.jbpm.JbpmContext.close(JbpmContext.java:139) | at com.Ejemplo1.Test2.testEjemplo1Process(Test2.java:50) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | at java.lang.reflect.Method.invoke(Unknown Source) | at junit.framework.TestCase.runTest(TestCase.java:154) | at junit.framework.TestCase.runBare(TestCase.java:127) | at junit.framework.TestResult$1.protect(TestResult.java:106) | at junit.framework.TestResult.runProtected(TestResult.java:124) | at junit.framework.TestResult.run(TestResult.java:109) | at junit.framework.TestCase.run(TestCase.java:118) | at junit.framework.TestSuite.runTest(TestSuite.java:208) | at junit.framework.TestSuite.run(TestSuite.java:203) | at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) | at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) | Caused by: java.sql.SQLException: Table not found in statement [insert into JBPM_MODULEINSTANCE (ID_, VERSION_, PROCESSINSTANCE_, CLASS_) values (null, ?, ?, 'C')] | 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.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) | at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94) | at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:30) | ... 52 more | 00:07:35,281 [main] DEBUG DbPersistenceService : rolling back hibernate transaction | 00:07:35,281 [main] DEBUG DbPersistenceService : closing hibernate session | 00:07:35,281 [main] ERROR Services : problem closing service 'persistence' | org.jbpm.persistence.JbpmPersistenceException: hibernate commit failed | at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:219) | at org.jbpm.svc.Services.close(Services.java:225) | at org.jbpm.JbpmContext.close(JbpmContext.java:139) | at com.Ejemplo1.Test2.testEjemplo1Process(Test2.java:50) | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) | at java.lang.reflect.Method.invoke(Unknown Source) | at junit.framework.TestCase.runTest(TestCase.java:154) | at junit.framework.TestCase.runBare(TestCase.java:127) | at junit.framework.TestResult$1.protect(TestResult.java:106) | at junit.framework.TestResult.runProtected(TestResult.java:124) | at junit.framework.TestResult.run(TestResult.java:109) | at junit.framework.TestCase.run(TestCase.java:118) | at junit.framework.TestSuite.runTest(TestSuite.java:208) | at junit.framework.TestSuite.run(TestSuite.java:203) | at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130) | at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386) | at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196) | Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [org.jbpm.context.exe.ContextInstance] | 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:40) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158) | at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638) | at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48) | at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248) | at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298) | at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181) | at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:94) | at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) | at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(SessionImpl.java:507) | at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:499) | at org.hibernate.engine.CascadingAction$1.cascade(CascadingAction.java:218) | at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:268) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:216) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169) | at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:296) | at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:242) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:219) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:169) | at org.hibernate.engine.Cascade.cascade(Cascade.java:130) | at org.hibernate.event.def.AbstractFlushingEventListener.cascadeOnFlush(AbstractFlushingEventListener.java:131) | at org.hibernate.event.def.AbstractFlushingEventListener.prepareEntityFlushes(AbstractFlushingEventListener.java:122) | at org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:65) | at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26) | at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) | at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) | at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) | at org.jbpm.persistence.db.DbPersistenceService.commit(DbPersistenceService.java:256) | at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:214) | ... 21 more | Caused by: java.sql.SQLException: Table not found in statement [insert into JBPM_MODULEINSTANCE (ID_, VERSION_, PROCESSINSTANCE_, CLASS_) values (null, ?, ?, 'C')] | 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.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505) | at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94) | at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:30) | ... 52 more | 00:07:35,296 [main] DEBUG Services : closing service 'tx': [EMAIL PROTECTED] | View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4111407#4111407 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4111407 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
