[jboss-user] [jBPM] - JBPM 5.1 Final Release with jboss-5.1.0.GA - Human Task Service - DB

[priyakpandey]

priyakpandey [http://community.jboss.org/people/priyakpandey] created the discussion

"JBPM 5.1 Final Release with jboss-5.1.0.GA - Human Task Service - DB"

To view the discussion, visit: http://community.jboss.org/message/613821#613821

--------------------------------------------------------------
Hi,
I followed following steps then my human task could not start. It throws following exception
1. ant install.demo installed the jbpm in H2 DB.
     1.1 i started the server and did basic testing through jbpm-console/ I created an instance of Evaluation process and task got create correctly
2. I changed the DB to oracle from H2. The option i used is hibernate.hbm2ddl.auto as 'create' in hibernate.cfg.xml.
     2.1 did the tsting as in 1.1. Things works
      2.2 stopped the servers using ant stop.demo and started again so that test data is erased and i have clean environment/
3. Now since my production environment cannot have this settings, i changed  hibernate.hbm2ddl.auto as 'none' in hibernate.cfg.xml.
     3.1 my human task does not start. it gives following error.
Can someone suggest why this would happen and how to fix this

tart.human.task:
    [java] SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
    [java] SLF4J: Defaulting to no-operation (NOP) logger implementation
    [java] SLF4J: See  http://www.slf4j.org/codes.html#StaticLoggerBinder http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
    [java] Exception in thread "main" javax.persistence.RollbackException: Error while commiting th
 transaction
    [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:71)
    [java]     at org.jbpm.task.service.TaskServiceSession.doOperationInTransaction(TaskServiceSess
on.java:820)
    [java]     at org.jbpm.task.service.TaskServiceSession.persistInTransaction(TaskServiceSession.
ava:786)
    [java]     at org.jbpm.task.service.TaskServiceSession.addUser(TaskServiceSession.java:69)
    [java]     at org.jbpm.DemoTaskService.main(Unknown Source)
    [java] Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC
atch update
    [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
    [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
    [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:266)
    [java]     at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)
    [java]     at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractF
ushingEventListener.java:321)
    [java]     at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListen
r.java:50)
    [java]     at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)
    [java]     at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)
    [java]     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)
    [java]     at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
    [java]     ... 4 more
    [java] Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (DRMS_PROCESS.SYS
C0037834) violated
    [java]
    [java]     at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:343


    [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.j
va:10768)
    [java]     at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
    [java]     at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
    [java]     ... 12 more
    [java] Java Result: 1
--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/613821#613821]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110706/71bc2c68/attachment.html