unique constraint violation with jBPM 3.1.4 and Oracle

[dmoeller]

Hello,

I try to set up an Oracle database under a jBPM 3.1.4 running in an JBoss AS 4.0.4. When I add process instances I get an exception and the information an unique constraint ist violated. An look up in the user_constraints says that the violated constraints are the following primary keys:

CONSTRAINT_NAME CONSTRAINT_TYPE TABLE_NAME
SYS_C0063323 P JBPM_LOG
SYS_C0063342 P JBPM_PROCESSINSTANCE

I read about a similar problem in jBPM 3.2. Has anyone an idea how to solve this problem?

regards
Daniel

[kukeltje]

well, I'd first try to see what field violates the constraint. is P on a primary key or something? Then see what value is inserted and trace back to where that field is filled.

[dmoeller]

Hello Ronald,

yes P stands for primary key. The value for this key should be generated by the sequence. Is there a way to log, what parameters are bound in the sql-query?

regards
Daniel

[kukeltje]

yes, jbpm uses hibernate, so look there for the debug options