[jboss-user] [JBoss jBPM] - Oracle Problem with Problem Deployment

[Anandnatraj]

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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967291#3967291

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3967291