3 Replies Latest reply on Feb 20, 2014 3:39 PM by kevengo

    Jbpm6 cr2 persistece with mysql error

    beowulf1985sr

      first of all, I'm not good at english.

      then is the problem:

      when I persistence with mysql, everything is ok. But the error happens on the point of startProcess, even I create ksession success with JBPMHelper.

      somebody know the reason?

      I guess it is a bug of jbpm6 cr2.

        • 1. Re: Jbpm6 cr2 persistece with mysql error
          salaboy21

          Can you share the stack trace of the error? if not it's almost impossible to guess that is going on there.

          • 2. Re: Jbpm6 cr2 persistece with mysql error
            beowulf1985sr

            my code:

                      JBPMHelper.setupDataSource();

                   KnowledgeBuilder kbuilder2 = KnowledgeBuilderFactory.newKnowledgeBuilder();

                   kbuilder2.add(ResourceFactory.newClassPathResource("Test.bpmn"),  ResourceType.BPMN2);

                   KnowledgeBase kbase2 = kbuilder2.newKnowledgeBase();

                   StatefulKnowledgeSession ksession2 = JBPMHelper.newStatefulKnowledgeSession(kbase2);

                   ProcessInstance processInstance2 = ksession2.startProcess("com.sample.bpmn");

            result:

            com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'connection, log_date, externalId, nodeId, nodeInstanceId, nodeName, nodeType, pr' at line 1

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_13]

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.6.0_13]

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.6.0_13]

              at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.6.0_13]

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[na:na]

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) [hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:852) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:826) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:830) [hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875) [hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.persist(JPAWorkingMemoryDbLogger.java:193) [jbpm-audit-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.beforeNodeTriggered(JPAWorkingMemoryDbLogger.java:92) [jbpm-audit-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.event.ProcessEventSupport.fireBeforeNodeTriggered(ProcessEventSupport.java:88) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:151) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:35) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:219) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:355) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:189) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:171) [jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1548) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:334) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:121) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:40) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.DefaultCommandService.execute(DefaultCommandService.java:36) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:395) [drools-persistence-jpa-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:229) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:220) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at Test.main(Test.java:27) [bin/:na]

            15:11:13.243 [main] WARN  o.h.e.jdbc.spi.SqlExceptionHelper - SQL Error: 1064, SQLState: 42000

            15:11:13.243 [main] ERROR o.h.e.jdbc.spi.SqlExceptionHelper - 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 'connection, log_date, externalId, nodeId, nodeInstanceId, nodeName, nodeType, pr' at line 1

            15:11:13.245 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Releasing JDBC connection

            15:11:13.245 [main] DEBUG b.t.r.jdbc.proxy.ConnectionJavaProxy - closing a ConnectionJavaProxy of a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 1 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.245 [main] DEBUG b.t.r.jdbc.JdbcPooledConnection - releasing to pool a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 1 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.245 [main] DEBUG b.t.r.c.TransactionContextHelper - delisting a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 from a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ACTIVE, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.245 [main] DEBUG b.t.r.c.TransactionContextHelper - resource is in enlisting global transaction context: a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.245 [main] DEBUG b.t.r.c.TransactionContextHelper - requeuing a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 from a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ACTIVE, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.246 [main] DEBUG b.t.r.c.TransactionContextHelper - resource is in enlisting global transaction context: a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG b.t.r.c.TransactionContextHelper - deferring release to pool of a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG b.t.r.c.TransactionContextHelper - a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 is not already registered for deferred release in a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ACTIVE, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.246 [main] DEBUG b.t.r.c.TransactionContextHelper - registering DeferredReleaseSynchronization for a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - notifying 2 stateChangeEventListener(s) about state changing from ACCESSIBLE to NOT_ACCESSIBLE in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG b.t.r.jdbc.JdbcPooledConnection - closing 0 dangling uncached statement(s)

            15:11:13.246 [main] DEBUG bitronix.tm.resource.common.XAPool - removed a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 from the accessible pool

            15:11:13.246 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - state changing from ACCESSIBLE to NOT_ACCESSIBLE in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - notifying 2 stateChangeEventListener(s) about state changed from ACCESSIBLE to NOT_ACCESSIBLE in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG bitronix.tm.resource.common.XAPool - added a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 to the inaccessible pool

            15:11:13.246 [main] DEBUG b.t.r.jdbc.JdbcPooledConnection - released to pool a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.246 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Released JDBC connection

            15:11:13.247 [main] DEBUG o.h.ejb.AbstractEntityManagerImpl - Mark transaction for rollback

            15:11:13.247 [main] DEBUG b.tm.BitronixTransactionManager - marking transaction as rollback only: a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ACTIVE, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.247 [main] DEBUG bitronix.tm.BitronixTransaction - changing transaction status to MARKED_ROLLBACK

            15:11:13.247 [main] DEBUG b.tm.journal.TransactionLogAppender - between 3599 and 359976, writing a Bitronix TransactionLogRecord with status=MARKED_ROLLBACK, recordLength=68, headerLength=28, time=1382080273247, sequenceNumber=52, crc32=1513563395, gtrid=3139322E3136382E312E31323800000141CA675AF20000000E, uniqueNames=jdbc/jbpm-ds

            15:11:13.247 [main] DEBUG bitronix.tm.BitronixTransaction - transaction status is changing from ACTIVE to MARKED_ROLLBACK - executing 0 listener(s)

            15:11:13.249 [main] WARN  o.d.p.SingleSessionCommandService - Could not commit session

            javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.persist(JPAWorkingMemoryDbLogger.java:193) ~[jbpm-audit-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.beforeNodeTriggered(JPAWorkingMemoryDbLogger.java:92) ~[jbpm-audit-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.event.ProcessEventSupport.fireBeforeNodeTriggered(ProcessEventSupport.java:88) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:151) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:35) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:219) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:355) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:189) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:171) ~[jbpm-flow-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1548) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:334) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:121) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:40) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.DefaultCommandService.execute(DefaultCommandService.java:36) ~[drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:395) ~[drools-persistence-jpa-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:229) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:220) [drools-core-6.0.0.CR2.jar:6.0.0.CR2]

              at Test.main(Test.java:27) [bin/:na]

            Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement

              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:852) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:826) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:830) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875) ~[hibernate-entitymanager-4.2.0.Final.jar:4.2.0.Final]

              ... 18 common frames omitted

            Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'connection, log_date, externalId, nodeId, nodeInstanceId, nodeName, nodeType, pr' at line 1

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_13]

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.6.0_13]

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:1.6.0_13]

              at java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:1.6.0_13]

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361) ~[mysql-connector-java-5.1.26-bin.jar:na]

              at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java) ~[na:na]

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) ~[hibernate-core-4.2.0.Final.jar:4.2.0.Final]

              ... 39 common frames omitted

            15:11:13.250 [main] DEBUG b.tm.BitronixTransactionManager - rolling back transaction a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=MARKED_ROLLBACK, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.250 [main] DEBUG bitronix.tm.timer.TaskScheduler - cancelling transaction timeout task on a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=MARKED_ROLLBACK, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.250 [main] DEBUG bitronix.tm.timer.TaskScheduler - removing task by a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=MARKED_ROLLBACK, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.250 [main] DEBUG bitronix.tm.timer.TaskScheduler - cancelled a TransactionTimeoutTask on a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=MARKED_ROLLBACK, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013) scheduled for Fri Oct 18 15:12:13 CST 2013, total task(s) still queued: 2

            15:11:13.250 [main] DEBUG bitronix.tm.BitronixTransaction - found unclosed resource to delist: an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state STARTED (started) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F]

            15:11:13.250 [main] DEBUG b.tm.internal.XAResourceManager - delisting resource an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state STARTED (started) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F]

            15:11:13.250 [main] DEBUG b.tm.internal.XAResourceHolderState - ending an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state STARTED (started) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F] with SUCCESS

            15:11:13.250 [main] DEBUG b.tm.resource.jdbc.lrc.LrcXAResource - OK to end, old state=STARTED, XID=a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F], flag=SUCCESS

            15:11:13.250 [main] DEBUG b.tm.internal.XAResourceHolderState - ended an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state ENDED (started) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F] with SUCCESS

            15:11:13.250 [main] DEBUG bitronix.tm.BitronixTransaction - rolling back, 1 enlisted resource(s)

            15:11:13.250 [main] DEBUG bitronix.tm.BitronixTransaction - changing transaction status to ROLLING_BACK

            15:11:13.251 [main] DEBUG b.tm.journal.TransactionLogAppender - between 3675 and 367576, writing a Bitronix TransactionLogRecord with status=ROLLING_BACK, recordLength=68, headerLength=28, time=1382080273250, sequenceNumber=53, crc32=1795981920, gtrid=3139322E3136382E312E31323800000141CA675AF20000000E, uniqueNames=jdbc/jbpm-ds

            15:11:13.251 [main] DEBUG bitronix.tm.BitronixTransaction - transaction status is changing from MARKED_ROLLBACK to ROLLING_BACK - executing 0 listener(s)

            15:11:13.251 [main] DEBUG b.tm.twopc.AbstractPhaseEngine - executing phase on 1 resource(s) enlisted in 1 position(s) in reverse position order

            15:11:13.251 [main] DEBUG b.tm.twopc.AbstractPhaseEngine - running 1 job(s) for position '2147483647'

            15:11:13.252 [main] DEBUG bitronix.tm.twopc.Rollbacker - trying to rollback resource an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state ENDED (ended) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F]

            15:11:13.252 [main] DEBUG b.tm.resource.jdbc.lrc.LrcXAResource - OK to rollback, old state=ENDED, XID=a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F]

            15:11:13.385 [main] DEBUG b.tm.resource.jdbc.lrc.LrcXAResource - enabling back autocommit mode on non-XA connection

            15:11:13.386 [main] DEBUG bitronix.tm.twopc.Rollbacker - rolled back resource an XAResourceHolderState with uniqueName=jdbc/jbpm-ds XAResource=a JDBC LrcXAResource in state NO_TX (ended) with XID a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F]

            15:11:13.387 [main] DEBUG b.tm.twopc.AbstractPhaseEngine - phase executed with 0 exception(s)

            15:11:13.387 [main] DEBUG b.tm.twopc.AbstractPhaseEngine - ran 1 job(s) for position '2147483647'

            15:11:13.387 [main] DEBUG bitronix.tm.twopc.Rollbacker - rollback executed on resources [jdbc/jbpm-ds]

            15:11:13.387 [main] DEBUG bitronix.tm.twopc.Rollbacker - rollback succeeded on resources [jdbc/jbpm-ds]

            15:11:13.387 [main] DEBUG bitronix.tm.BitronixTransaction - changing transaction status to ROLLEDBACK

            15:11:13.387 [main] DEBUG b.tm.journal.TransactionLogAppender - between 3751 and 375176, writing a Bitronix TransactionLogRecord with status=ROLLEDBACK, recordLength=68, headerLength=28, time=1382080273387, sequenceNumber=54, crc32=-2122027405, gtrid=3139322E3136382E312E31323800000141CA675AF20000000E, uniqueNames=jdbc/jbpm-ds

            15:11:13.387 [main] DEBUG bitronix.tm.BitronixTransaction - transaction status is changing from ROLLING_BACK to ROLLEDBACK - executing 0 listener(s)

            15:11:13.388 [main] DEBUG bitronix.tm.BitronixTransaction - successfully rolled back a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ROLLEDBACK, 1 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.388 [main] DEBUG b.tm.internal.XAResourceManager - clearing XAResourceHolder states on 1 resource(s)

            15:11:13.388 [main] DEBUG b.t.r.c.AbstractXAResourceHolder - removing XAResourceHolderState of xid a Bitronix XID [3139322E3136382E312E31323800000141CA675AF20000000E : 3139322E3136382E312E31323800000141CA675B1C0000000F] from a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.388 [main] DEBUG b.tm.internal.XAResourceManager - resource a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 cleaned up all transaction states for GTRID [3139322E3136382E312E31323800000141CA675AF20000000E]

            15:11:13.388 [main] DEBUG bitronix.tm.BitronixTransaction - after completion, 7 synchronization(s) to execute

            15:11:13.388 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization org.drools.persistence.jta.JtaTransactionSynchronizationAdapter@b6994f with status=ROLLEDBACK

            15:11:13.389 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization@e90906 with status=ROLLEDBACK

            15:11:13.389 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Aggressively releasing JDBC connection

            15:11:13.389 [main] DEBUG o.h.e.t.i.TransactionCoordinatorImpl - Skipping JTA sync registration due to auto join checking

            15:11:13.389 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization@14f79cb with status=ROLLEDBACK

            15:11:13.389 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Aggressively releasing JDBC connection

            15:11:13.389 [main] DEBUG o.h.e.t.i.TransactionCoordinatorImpl - Skipping JTA sync registration due to auto join checking

            15:11:13.389 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization@4be179 with status=ROLLEDBACK

            15:11:13.389 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Aggressively releasing JDBC connection

            15:11:13.390 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization org.hibernate.engine.transaction.synchronization.internal.RegisteredSynchronization@9fa12f with status=ROLLEDBACK

            15:11:13.390 [main] DEBUG o.h.e.j.i.LogicalConnectionImpl - Aggressively releasing JDBC connection

            15:11:13.390 [main] DEBUG o.h.e.t.i.TransactionCoordinatorImpl - Skipping JTA sync registration due to auto join checking

            15:11:13.390 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization a ClearContextSynchronization for a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ROLLEDBACK, 0 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013) with status=ROLLEDBACK

            15:11:13.390 [main] DEBUG b.tm.BitronixTransactionManager - clearing transaction from thread context: a ThreadContext (13598672) with transaction a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ROLLEDBACK, 0 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013), default timeout 60s

            15:11:13.390 [main] DEBUG b.tm.BitronixTransactionManager - removing transaction from in-flight transactions: a Bitronix Transaction with GTRID [3139322E3136382E312E31323800000141CA675AF20000000E], status=ROLLEDBACK, 0 resource(s) enlisted (started Fri Oct 18 15:11:13 CST 2013)

            15:11:13.390 [main] DEBUG bitronix.tm.BitronixTransaction - executing synchronization a DeferredReleaseSynchronization of a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 with status=ROLLEDBACK

            15:11:13.390 [main] DEBUG b.t.r.c.DeferredReleaseSynchronization - DeferredReleaseSynchronization requeuing a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.390 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - notifying 2 stateChangeEventListener(s) about state changing from NOT_ACCESSIBLE to IN_POOL in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.390 [main] DEBUG b.t.r.jdbc.JdbcPooledConnection - closing 0 dangling uncached statement(s)

            15:11:13.390 [main] DEBUG bitronix.tm.resource.common.XAPool - removed a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 from the inaccessible pool

            15:11:13.390 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - state changing from NOT_ACCESSIBLE to IN_POOL in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state NOT_ACCESSIBLE with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.390 [main] DEBUG b.t.r.c.AbstractXAStatefulHolder - notifying 2 stateChangeEventListener(s) about state changed from NOT_ACCESSIBLE to IN_POOL in a JdbcPooledConnection from datasource jdbc/jbpm-ds in state IN_POOL with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            15:11:13.391 [main] DEBUG bitronix.tm.resource.common.XAPool - added a JdbcPooledConnection from datasource jdbc/jbpm-ds in state IN_POOL with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535 to the available pool

            15:11:13.391 [main] DEBUG b.t.r.c.DeferredReleaseSynchronization - DeferredReleaseSynchronization requeued a JdbcPooledConnection from datasource jdbc/jbpm-ds in state IN_POOL with usage count 0 wrapping a JDBC LrcXAConnection on a JDBC LrcConnectionJavaProxy on com.mysql.jdbc.JDBC4Connection@10eb535

            Exception in thread "main" javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)

              at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)

              at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.persist(JPAWorkingMemoryDbLogger.java:193)

              at org.jbpm.process.audit.JPAWorkingMemoryDbLogger.beforeNodeTriggered(JPAWorkingMemoryDbLogger.java:92)

              at org.drools.core.event.ProcessEventSupport.fireBeforeNodeTriggered(ProcessEventSupport.java:88)

              at org.jbpm.workflow.instance.impl.NodeInstanceImpl.trigger(NodeInstanceImpl.java:151)

              at org.jbpm.ruleflow.instance.RuleFlowProcessInstance.internalStart(RuleFlowProcessInstance.java:35)

              at org.jbpm.process.instance.impl.ProcessInstanceImpl.start(ProcessInstanceImpl.java:219)

              at org.jbpm.workflow.instance.impl.WorkflowProcessInstanceImpl.start(WorkflowProcessInstanceImpl.java:355)

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcessInstance(ProcessRuntimeImpl.java:189)

              at org.jbpm.process.instance.ProcessRuntimeImpl.startProcess(ProcessRuntimeImpl.java:171)

              at org.drools.core.common.AbstractWorkingMemory.startProcess(AbstractWorkingMemory.java:1548)

              at org.drools.core.impl.StatefulKnowledgeSessionImpl.startProcess(StatefulKnowledgeSessionImpl.java:334)

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:121)

              at org.drools.core.command.runtime.process.StartProcessCommand.execute(StartProcessCommand.java:40)

              at org.drools.core.command.impl.DefaultCommandService.execute(DefaultCommandService.java:36)

              at org.drools.persistence.SingleSessionCommandService.execute(SingleSessionCommandService.java:395)

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:229)

              at org.drools.core.command.impl.CommandBasedStatefulKnowledgeSession.startProcess(CommandBasedStatefulKnowledgeSession.java:220)

              at Test.main(Test.java:27)

            Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement

              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)

              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)

              at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96)

              at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58)

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

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

              at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81)

              at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)

              at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203)

              at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183)

              at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167)

              at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321)

              at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286)

              at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192)

              at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125)

              at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78)

              at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)

              at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:852)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:826)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:830)

              at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875)

              ... 18 more

            Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'connection, log_date, externalId, nodeId, nodeInstanceId, nodeName, nodeType, pr' at line 1

              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

              at java.lang.reflect.Constructor.newInstance(Unknown Source)

              at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

              at com.mysql.jdbc.Util.getInstance(Util.java:386)

              at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190)

              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122)

              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)

              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)

              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2818)

              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2157)

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2460)

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2377)

              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2361)

              at bitronix.tm.resource.jdbc.proxy.PreparedStatementJavassistProxy.executeUpdate(PreparedStatementJavassistProxy.java)

              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133)

              ... 39 more

            • 3. Re: Jbpm6 cr2 persistece with mysql error
              kevengo

              ......

              check the manual that corresponds to your MySQL server version for the right syntax to use near 'connection, log_date, externalId, nodeId, nodeInstanceId, nodeName, nodeType, pr' at line 1

              .......

               

              because "connection" is a reserved keywords in mysql 5.0.  you should use the later version of mysql.