[jboss-user] [JBoss jBPM] - Re: Error Messages when using command create.db
wackruochen
do-not-reply at jboss.com
Tue Nov 14 17:09:17 EST 2006
I added this to my hibernate.cfg.xml file and
create.db.hibernate.properties file
| <property name="hibernate.jdbc.use_get_generated_keys">false</property>
|
| and
|
| hibernate.jdbc.use_get_generated_keys = false
|
but the error messages still there, but looks different.
I noticed the inserting command, the last column of the values is "default", it seems not right to me, it should be an integer number, right?
| [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] ****e is org.hibernate.exception.GenericJDBCException: could not insert: [org.jbpm.identity.Group]
| [loadidentities] org.jbpm.persistence.JbpmPersistenceException: couldn't commit
| hibernate session
| [loadidentities] at org.jbpm.persistence.db.DbPersistenceService.close(Db
| PersistenceService.java:189)
| [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: [SQL7008] JBPM_00008 in jbpm not valid for operation.
| [loadidentities] at com.ibm.as400.access.JDError.throwSQLException(JDErro
| r.java:650)
| [loadidentities] at com.ibm.as400.access.JDError.throwSQLException(JDErro
| r.java:621)
| [loadidentities] at com.ibm.as400.access.AS400JDBCStatement.commonExecute
| (AS400JDBCStatement.java:884)
| [loadidentities] at com.ibm.as400.access.AS400JDBCPreparedStatement.execu
| teUpdate(AS400JDBCPreparedStatement.java:1144)
| [loadidentities] at org.hibernate.persister.entity.AbstractEntityPersiste
| r.insert(AbstractEntityPersister.java:1976)
| [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}
|
thanks
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3985952#3985952
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3985952
More information about the jboss-user
mailing list