2 Replies Latest reply on Nov 14, 2006 5:09 PM by xinxin

    Error Messages when using command create.db

    xinxin Newbie

      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}
      
      


        • 1. Re: Error Messages when using command create.db
          Ronald van Kuijk Master

          Caused by: java.sql.SQLException: The driver does not support t
          | his function.

          • 2. Re: Error Messages when using command create.db
            xinxin Newbie

            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