Error Messages when using command create.db
xinxin Nov 14, 2006 11:00 AMHi all,
I downloaded jBPM3.1.2, and I tried to created tables onto DB2/400. I configured the create.db.hibernate.properties, build.deploy.xml files, and hibernate.cfg.xml. But after running "ant create.db -buildfile build.deploy.xml" command, I was able to successfully create jBPM tables onto my database, failed to inserting data into tables. I tried a lot of time, it still gives me the error messages, I don't know why, and I wander if anyone knows the reason.
Thanks
create.db.hibernate.properties
# these properties are used by the build script to create # a hypersonic database in the build/db directory that contains # the jbpm tables and a process deployed in there hibernate.dialect=org.hibernate.dialect.DB2400Dialect hibernate.connection.driver_class=com.ibm.as400.access.AS400JDBCDriver hibernate.connection.url=jdbc:as400://server/jbpm hibernate.connection.username=sa hibernate.connection.password=sa hibernate.show_sql=true hibernate.query.substitutions=true 1, false 0
build.deploy.xml
<target name="create.db" depends="declare.jbpm.tasks, db.clean, db.start" description="creates a db2 database with the jbpm tables and loads the processes in there"> <jbpmschema actions="create" cfg="${basedir}/src/config.files/hibernate.cfg.xml" properties="${basedir}/src/resources/db2/create.db.hibernate.properties"/> <loadidentities file="${basedir}/src/resources/db2/identity.db.xml" cfg="${basedir}/src/config.files/hibernate.cfg.xml" properties="${basedir}/src/resources/db2/create.db.hibernate.properties"/> <ant antfile="build.xml" target="build.processes" inheritall="false" /> <deployprocess cfg="${basedir}/src/config.files/hibernate.cfg.xml" properties="${basedir}/src/resources/db2/create.db.hibernate.properties"> <fileset dir="build" includes="*.process" /> </deployprocess> <antcall target="db.stop" /> </target>
hibernate.cfg.xml
<!-- jdbc connection properties --> <property name="hibernate.dialect">org.hibernate.dialect.DB2400Dialect</property> <property name="hibernate.connection.driver_class">com.ibm.as400.access.AS400JDBCDriver</property> <property name="hibernate.connection.url">jdbc:as400://server/jbpm</property> <property name="hibernate.connection.username">sa</property> <property name="hibernate.connection.password">sa</property>
Error Messages
[loadidentities] loading identities from C:\jbpm-3.1.2/src/resources/db2/identit y.db.xml ... [loadidentities] Hibernate: insert into JBPM_ID_USER (NAME_, EMAIL_, PASSWORD_, CLASS_, ID_) values (?, ?, ?, 'U', default) [loadidentities] Hibernate: insert into JBPM_ID_GROUP (NAME_, TYPE_, PARENT_, CL ASS_, ID_) values (?, ?, ?, 'G', default) [loadidentities] org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session [loadidentities] at org.jbpm.persistence.db.DbPersistenceService.close(Db PersistenceService.java:188) [loadidentities] at org.jbpm.svc.Services.close(Services.java:211) [loadidentities] at org.jbpm.JbpmContext.close(JbpmContext.java:139) [loadidentities] at org.jbpm.identity.ant.LoadIdentitiesTask.execute(Load IdentitiesTask.java:67) [loadidentities] at org.apache.tools.ant.UnknownElement.execute(UnknownEl ement.java:275) [loadidentities] at org.apache.tools.ant.Task.perform(Task.java:364) [loadidentities] at org.apache.tools.ant.Target.execute(Target.java:341) [loadidentities] at org.apache.tools.ant.Target.performTasks(Target.java: 369) [loadidentities] at org.apache.tools.ant.Project.executeSortedTargets(Pro ject.java:1216) [loadidentities] at org.apache.tools.ant.Project.executeTarget(Project.ja va:1185) [loadidentities] at org.apache.tools.ant.helper.DefaultExecutor.executeTa rgets(DefaultExecutor.java:40) [loadidentities] at org.apache.tools.ant.Project.executeTargets(Project.j ava:1068) [loadidentities] at org.apache.tools.ant.Main.runBuild(Main.java:668) [loadidentities] at org.apache.tools.ant.Main.startAnt(Main.java:187) [loadidentities] at org.apache.tools.ant.launch.Launcher.run(Launcher.jav a:246) [loadidentities] at org.apache.tools.ant.launch.Launcher.main(Launcher.ja va:67) [loadidentities] Caused by: org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.identity.Group] [loadidentities] at org.hibernate.exception.SQLStateConverter.handledNonS pecificException(SQLStateConverter.java:91) [loadidentities] at org.hibernate.exception.SQLStateConverter.convert(SQL StateConverter.java:79) [loadidentities] at org.hibernate.exception.JDBCExceptionHelper.convert(J DBCExceptionHelper.java:43) [loadidentities] at org.hibernate.persister.entity.AbstractEntityPersiste r.insert(AbstractEntityPersister.java:1986) [loadidentities] at org.hibernate.persister.entity.AbstractEntityPersiste r.insert(AbstractEntityPersister.java:2405) [loadidentities] at org.hibernate.action.EntityIdentityInsertAction.execu te(EntityIdentityInsertAction.java:37) [loadidentities] at org.hibernate.engine.ActionQueue.execute(ActionQueue. java:243) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.per formSaveOrReplicate(AbstractSaveEventListener.java:269) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.per formSave(AbstractSaveEventListener.java:167) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.sav eWithGeneratedId(AbstractSaveEventListener.java:101) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) [loadidentities] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(Sessi onImpl.java:520) [loadidentities] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionIm pl.java:513) [loadidentities] at org.hibernate.engine.CascadingAction$1.cascade(Cascad ingAction.java:134) [loadidentities] at org.hibernate.engine.Cascade.cascadeToOne(Cascade.jav a:213) [loadidentities] at org.hibernate.engine.Cascade.cascadeAssociation(Casca de.java:157) [loadidentities] at org.hibernate.engine.Cascade.cascadeProperty(Cascade. java:108) [loadidentities] at org.hibernate.engine.Cascade.cascade(Cascade.java:248 ) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.cas cadeBeforeSave(AbstractSaveEventListener.java:385) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.per formSaveOrReplicate(AbstractSaveEventListener.java:242) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.per formSave(AbstractSaveEventListener.java:167) [loadidentities] at org.hibernate.event.def.AbstractSaveEventListener.sav eWithGeneratedId(AbstractSaveEventListener.java:101) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.performSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:98) [loadidentities] at org.hibernate.event.def.DefaultSaveOrUpdateEventListe ner.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70) [loadidentities] at org.hibernate.impl.SessionImpl.fireSaveOrUpdate(Sessi onImpl.java:520) [loadidentities] at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionIm pl.java:513) [loadidentities] at org.hibernate.engine.CascadingAction$1.cascade(Cascad ingAction.java:134) [loadidentities] at org.hibernate.engine.Cascade.cascadeToOne(Cascade.jav a:213) [loadidentities] at org.hibernate.engine.Cascade.cascadeAssociation(Casca de.java:157) [loadidentities] at org.hibernate.engine.Cascade.cascadeProperty(Cascade. java:108) [loadidentities] at org.hibernate.engine.Cascade.cascadeCollectionElement s(Cascade.java:290) [loadidentities] at org.hibernate.engine.Cascade.cascadeCollection(Cascad e.java:185) [loadidentities] at org.hibernate.engine.Cascade.cascadeAssociation(Casca de.java:160) [loadidentities] at org.hibernate.engine.Cascade.cascadeProperty(Cascade. java:108) [loadidentities] at org.hibernate.engine.Cascade.cascade(Cascade.java:248 ) [loadidentities] at org.hibernate.event.def.AbstractFlushingEventListener .cascadeOnFlush(AbstractFlushingEventListener.java:130) [loadidentities] at org.hibernate.event.def.AbstractFlushingEventListener .prepareEntityFlushes(AbstractFlushingEventListener.java:121) [loadidentities] at org.hibernate.event.def.AbstractFlushingEventListener .flushEverythingToExecutions(AbstractFlushingEventListener.java:65) [loadidentities] at org.hibernate.event.def.DefaultFlushEventListener.onF lush(DefaultFlushEventListener.java:26) [loadidentities] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java :980) [loadidentities] at org.hibernate.impl.SessionImpl.managedFlush(SessionIm pl.java:353) [loadidentities] at org.hibernate.transaction.JDBCTransaction.commit(JDBC Transaction.java:106) [loadidentities] at org.jbpm.persistence.db.DbPersistenceService.close(Db PersistenceService.java:177) [loadidentities] ... 15 more [loadidentities] Caused by: java.sql.SQLException: The driver does not support t his function. [loadidentities] at com.ibm.as400.access.JDError.throwSQLException(JDErro r.java:382) [loadidentities] at com.ibm.as400.access.AS400JDBCConnection.prepareState ment(AS400JDBCConnection.java:1876) [loadidentities] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod) [loadidentities] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMet hodAccessorImpl.java:39) [loadidentities] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Deleg atingMethodAccessorImpl.java:25) [loadidentities] at java.lang.reflect.Method.invoke(Method.java:585) [loadidentities] at org.hibernate.util.GetGeneratedKeysHelper.prepareStat ement(GetGeneratedKeysHelper.java:45) [loadidentities] at org.hibernate.jdbc.AbstractBatcher.getPreparedStateme nt(AbstractBatcher.java:435) [loadidentities] at org.hibernate.jdbc.AbstractBatcher.prepareStatement(A bstractBatcher.java:93) [loadidentities] at org.hibernate.persister.entity.AbstractEntityPersiste r.insert(AbstractEntityPersister.java:1948) [loadidentities] ... 59 more BUILD FAILED C:\jbpm-3.1.2\build.deploy.xml:51: org.jbpm.JbpmException: problem closing servi ces {persistence=org.jbpm.persistence.JbpmPersistenceException: couldn't commit hibernate session}