<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Problem with insert sessioninfo
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/li_thirst">li thirst</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/809506#809506">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>TransactionManager transactionManager = new DroolsSpringTransactionManager(aptm);</p><p>Environment env = EnvironmentFactory.newEnvironment();</p><p>env.set(EnvironmentName.APP_SCOPED_ENTITY_MANAGER, em);</p><p>env.set(EnvironmentName.CMD_SCOPED_ENTITY_MANAGER, em);</p><p>env.set("IS_JTA_TRANSACTION", false);</p><p>env.set("IS_SHARED_ENTITY_MANAGER", true);</p><p>env.set(EnvironmentName.TRANSACTION_MANAGER, transactionManager);</p><p>PersistenceContextManager persistenceContextManager = new DroolsSpringJpaManager(env);</p><p>env.set(EnvironmentName.PERSISTENCE_CONTEXT_MANAGER, persistenceContextManager);</p><p>KnowledgeBase kbase = kbuilder.newKnowledgeBase();</p><p>StatefulKnowledgeSession ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null, env);</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Program execution to "StatefulKnowledgeSession ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase, null, env);", Program throw error:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>14:26:38,489 INFO  [stdout] (http-localhost-127.0.0.1-8080-1) Hibernate: insert into SessionInfo (lastModificationDate, rulesByteArray, startDate, OPTLOCK) values (?, ?, ?, ?)</p><p>14:26:38,500 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost-127.0.0.1-8080-1) SQL Error: 1364, SQLState: HY000</p><p>14:26:38,500 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost-127.0.0.1-8080-1) Field 'id' doesn't have a default value</p><p>14:26:38,502 ERROR [org.drools.persistence.SingleSessionCommandService] (http-localhost-127.0.0.1-8080-1) Could not commit session: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Field 'id' doesn't have a default value</p><p>          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1361) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1295) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:859) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27-ea]</p><p>          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27-ea]</p><p>          at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:240) [org.springframework.orm-3.1.1.RELEASE.jar:3.1.1.RELEASE]</p><p>          at $Proxy38.persist(Unknown Source)          at org.drools.persistence.jpa.JpaPersistenceContext.persist(JpaPersistenceContext.java:24) [drools-persistence-jpa-5.5.0.Final.jar:5.5.0.Final]</p><p>          at org.drools.persistence.SingleSessionCommandService.<init>(SingleSessionCommandService.java:153) [drools-persistence-jpa-5.5.0.Final.jar:5.5.0.Final]</p><p>          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) [rt.jar:1.6.0_27-ea]</p><p>          at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [rt.jar:1.6.0_27-ea]</p><p>          at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.buildCommandService(KnowledgeStoreServiceImpl.java:128) [drools-persistence-jpa-5.5.0.Final.jar:5.5.0.Final]</p><p>          at org.drools.persistence.jpa.KnowledgeStoreServiceImpl.newStatefulKnowledgeSession(KnowledgeStoreServiceImpl.java:66) [drools-persistence-jpa-5.5.0.Final.jar:5.5.0.Final]</p><p>          at org.drools.persistence.jpa.JPAKnowledgeService.newStatefulKnowledgeSession(JPAKnowledgeService.java:122) [knowledge-api-5.5.0.Final.jar:5.5.0.Final]</p><p>          at com.one.util.JbpmUtil.initializeSession(JbpmUtil.java:85) [classes:]</p><p>          at com.one.jbpm.JBPMEngine.createKsession(JBPMEngine.java:40) [classes:]</p><p>          at com.one.jbpm.JBPMEngine.createProcessInstance(JBPMEngine.java:46) [classes:]</p><p>          at com.one.action.LeaveAction.create(LeaveAction.java:39) [classes:]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27-ea]</p><p>          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27-ea]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:450) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:249) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:191) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:73) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:91) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:252) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:193) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) [xwork-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:546) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) [struts2-core-2.3.12.jar:2.3.12]</p><p>          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.1.1.Final.jar:7.1.1.Final]</p><p>          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]</p><p>          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]</p><p>          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]</p><p>          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_27-ea]</p><p>Caused by: org.hibernate.exception.GenericJDBCException: Field 'id' doesn't have a default value</p><p>          at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:52) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at $Proxy45.executeUpdate(Unknown Source)          at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:55) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2757) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3268) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:78) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:272) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:304) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:195) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:128) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:725) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:701) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:705) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:853) [hibernate-entitymanager-4.0.1.Final.jar:4.0.1.Final]</p><p>          ... 86 more</p><p>Caused by: java.sql.SQLException: Field 'id' doesn't have a default value</p><p>          at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359) [mysql-connector-java-5.1.22-bin.jar:]</p><p>          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [commons-dbcp-1.4.jar:1.4]</p><p>          at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) [commons-dbcp-1.4.jar:1.4]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_27-ea]</p><p>          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_27-ea]</p><p>          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_27-ea]</p><p>          at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) [hibernate-core-4.0.1.Final.jar:4.0.1.Final]</p><p>          ... 105 more</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Database have sessioninfo and SESSIONINFO_ID_SEQ tables.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>persistence.xml</p><p><?xml version="1.0" encoding="UTF-8"?></p><p><persistence version="2.0"</p><p><span>          xmlns="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" rel="nofollow" target="_blank">http://java.sun.com/xml/ns/persistence</a><span>" xmlns:xsi="</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>"</span></p><p><span>          xsi:schemaLocation="</span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence" rel="nofollow" target="_blank">http://java.sun.com/xml/ns/persistence</a><span> </span><a class="jive-link-external-small" href="http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd" rel="nofollow" target="_blank">http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd</a><span>"></span></p><p>          <persistence-unit name="sh" transaction-type="RESOURCE_LOCAL"></p><p>                    <provider>org.hibernate.ejb.HibernatePersistence</provider></p><p>                    <mapping-file>META-INF/JBPMorm.xml</mapping-file></p><p>                    <mapping-file>META-INF/Taskorm.xml</mapping-file></p><p>                    <mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file></p><p>                    <non-jta-data-source>java:jboss/datasources/YourDatasourceName</non-jta-data-source></p><p>                    <class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class></p><p>                    <class>org.drools.persistence.info.SessionInfo</class></p><p>                    <class>org.drools.persistence.info.WorkItemInfo</class></p><p>                    <class>org.jbpm.process.audit.ProcessInstanceLog</class></p><p>                    <class>org.jbpm.process.audit.NodeInstanceLog</class></p><p>                    <class>org.jbpm.process.audit.VariableInstanceLog</class></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>                    <class>org.jbpm.task.Attachment</class></p><p>                    <class>org.jbpm.task.Content</class></p><p>                    <class>org.jbpm.task.BooleanExpression</class></p><p>                    <class>org.jbpm.task.Comment</class></p><p>                    <class>org.jbpm.task.Deadline</class></p><p>                    <class>org.jbpm.task.Comment</class></p><p>                    <class>org.jbpm.task.Deadline</class></p><p>                    <class>org.jbpm.task.Delegation</class></p><p>                    <class>org.jbpm.task.Escalation</class></p><p>                    <class>org.jbpm.task.Group</class></p><p>                    <class>org.jbpm.task.I18NText</class></p><p>                    <class>org.jbpm.task.Notification</class></p><p>                    <class>org.jbpm.task.EmailNotification</class></p><p>                    <class>org.jbpm.task.EmailNotificationHeader</class></p><p>                    <class>org.jbpm.task.PeopleAssignments</class></p><p>                    <class>org.jbpm.task.Reassignment</class></p><p>                    <class>org.jbpm.task.Status</class></p><p>                    <class>org.jbpm.task.Task</class></p><p>                    <class>org.jbpm.task.TaskData</class></p><p>                    <class>org.jbpm.task.SubTasksStrategy</class></p><p>                    <class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class></p><p>                    <class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class></p><p>                    <class>org.jbpm.task.User</class></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>                    <class>com.one.model.LeaveInformation</class></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>                    <properties></p><p>                              <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" /></p><p>                              <property name="hibernate.connection.autocommit" value="true" /></p><p>                              <property name="hibernate.show_sql" value="true" /></p><p>                              <property name="hibernate.hbm2ddl.auto" value="update" /></p><p>                    </properties></p><p>          </persistence-unit></p><p></persistence></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>applicationContext.xml</p><p><span><beans xmlns="</span><a class="jive-link-external-small" href="http://www.springframework.org/schema/beans" rel="nofollow" target="_blank">http://www.springframework.org/schema/beans</a><span>"</span></p><p><span>          xmlns:xsi="</span><a class="jive-link-external-small" href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow" target="_blank">http://www.w3.org/2001/XMLSchema-instance</a><span>" xmlns:p="</span><a class="jive-link-external-small" href="http://www.springframework.org/schema/p" rel="nofollow" target="_blank">http://www.springframework.org/schema/p</a><span>"</span></p><p><span>          xmlns:aop="</span><a class="jive-link-external-small" href="http://www.springframework.org/schema/aop" rel="nofollow" target="_blank">http://www.springframework.org/schema/aop</a><span>" xmlns:tx="</span><a class="jive-link-external-small" href="http://www.springframework.org/schema/tx" rel="nofollow" target="_blank">http://www.springframework.org/schema/tx</a><span>"</span></p><p><span>          xsi:schemaLocation="</span><a class="jive-link-external-small" href="http://www.springframework.org/schema/beans" rel="nofollow" target="_blank">http://www.springframework.org/schema/beans</a><span> </span></p><p><span>          </span><a class="jive-link-external-small" href="http://www.springframework.org/schema/beans/spring-beans-3.0.xsd" rel="nofollow" target="_blank">http://www.springframework.org/schema/beans/spring-beans-3.0.xsd</a></p><p><span>                    </span><a class="jive-link-external-small" href="http://www.springframework.org/schema/aop" rel="nofollow" target="_blank">http://www.springframework.org/schema/aop</a><span> </span></p><p><span>                                                            </span><a class="jive-link-external-small" href="http://www.springframework.org/schema/aop/spring-aop-3.0.xsd" rel="nofollow" target="_blank">http://www.springframework.org/schema/aop/spring-aop-3.0.xsd</a><span> </span></p><p><span>                                                            </span><a class="jive-link-external-small" href="http://www.springframework.org/schema/tx" rel="nofollow" target="_blank">http://www.springframework.org/schema/tx</a></p><p><span>                                                            </span><a class="jive-link-external-small" href="http://www.springframework.org/schema/tx/spring-tx-3.0.xsd" rel="nofollow" target="_blank">http://www.springframework.org/schema/tx/spring-tx-3.0.xsd</a></p><p>                                                            "></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>          <bean</p><p>                    class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"></p><p>                    <property name="locations"></p><p>                              <list></p><p><!--                                         <value>classpath:conf/property/jdbc.properties</value> --></p><p>                              </list></p><p>                    </property></p><p>                    <property name="properties"></p><p>                              <value>custom.strategy.class=com.foo.DefaultStrategy</value></p><p>                    </property></p><p>          </bean></p><p>  </p><p>          <bean id="myEmf" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">  </p><p>        <property name="dataSource" ref="baseDataSource"/>  </p><p>        <property name="persistenceUnitName" value="sh" /></p><p>        <property name="persistenceXmlLocation" value="classpath:META-INF/persistence.xml" />  </p><p>    </bean>  </p><p>    <bean id="jbpmEM"</p><p>                    class="org.springframework.orm.jpa.support.SharedEntityManagerBean"></p><p>                    <property name="entityManagerFactory" ref="myEmf" /></p><p>          </bean></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <bean id="myTxManager" class="org.springframework.orm.jpa.JpaTransactionManager">  </p><p>        <property name="entityManagerFactory" ref="myEmf" />  </p><p>    </bean>  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <tx:advice id="txAdvice" transaction-manager="myTxManager">  </p><p>        <tx:attributes>  </p><p>            <tx:method name="*" propagation="REQUIRED" />  </p><p>        </tx:attributes>  </p><p>    </tx:advice>  </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    <aop:config>  </p><p>        <aop:pointcut expression="execution(* com.one.dao.*.*(..))" id="myTx1"/>  </p><p>        <aop:advisor advice-ref="txAdvice" pointcut-ref="myTx1"/>  </p><p>    </aop:config> </p><p>    </p><p>    <bean id="baseDataSource" class="org.apache.commons.dbcp.BasicDataSource"></p><p>                    <property name="driverClassName" value="com.mysql.jdbc.Driver" /></p><p>                    <property name="url" value="jdbc:mysql://localhost:3306/lian" /></p><p>                    <property name="username" value="root" /></p><p>                    <property name="password" value="" /></p><p>          </bean></p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/809506#809506">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>