Error Messages when using command create.db
Hi 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}
