10 a.m.
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}
|
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3985822#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...