3 Replies Latest reply on Aug 24, 2006 6:20 PM by Ronald van Kuijk

    Oracle Problem with Problem Deployment

    Anandha Newbie

      I am reposting my problem with jBPM since I could not resolve it.

      I have created a process in Eclipse IDE through GPD. I have already created my tables in ORACLE in my own user schema(so I have complete access rights for all the DB objects in my schema)

      Now I started the jBPM -JBOss server. It started up well against ORalce-ds.xml. Means, all the DB objects I have created are perfect.

      Now I am trying to deploy my process and I am getting the following Exception. A help from jBPM developers could be very helpful. I am almost stuck here for my second day.


      Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [org.jbpm.graph.def.ProcessDefinition]
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1985)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2404)
      at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:37)
      at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
      at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:269)
      at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:167)
      at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:101)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186
      )
      at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
      at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
      at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
      at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:524)
      at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
      at org.hibernate.impl.SessionImpl.save(SessionImpl.java:510)
      at org.jbpm.db.GraphSession.saveProcessDefinition(GraphSession.java:31)
      ... 38 more
      Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("JBPM_PROCESSDEFINITION"."ID_")

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
      at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:227)
      at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:1975)


      To My knowledge it seems it is not able to create the primary keys through Native generator class. Where I need to go and debug this to rectify.

      N.B. It is working fine with hsql db.

      Please help.

      Anandh