Hi, the code is like this:
| JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext();
| ProcessInstance instance =
jbpmContext.newProcessInstance("DefinitionName");
| jbpmContext.close();
|
When it inserts the first ProcessInstance (first in the table, id = 1) it runs
fine.
When I tried to insert a second ProcessInstance it fails:
| Hibernate:
| insert
| into
| JBPM_PROCESSINSTANCE
| (VERSION_, KEY_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_,
ROOTTOKEN_, SUPERPROCESSTOKEN_)
| values
| (?, ?, ?, ?, ?, ?, ?, ?) select
| scope_identity()
| 14:56:33,140 [main] WARN JDBCExceptionReporter : SQL Error: 2627,
SQLState: 23000
| 14:56:33,140 [main] ERROR JDBCExceptionReporter : [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]Violation of UNIQUE KEY constraint
'UQ__JBPM_PROCESSINST__731B1205'. Cannot insert duplicate key in object
'JBPM_PROCESSINSTANCE'.
| 14:56:33,140 [main] WARN JDBCExceptionReporter : SQL Error: 3621,
SQLState: HY000
| 14:56:33,140 [main] ERROR JDBCExceptionReporter : [Microsoft][SQLServer
2000 Driver for JDBC][SQLServer]The statement has been terminated.
| Exception in thread "main" org.jbpm.persistence.JbpmPersistenceException:
couldn't assign id to [EMAIL PROTECTED]
|
Violation of unique key constrain? In JBPM_PROCESSINSTANCE table the id has
identity "yes" (autonumeric), in the hibernate entity configuration file for
ProcessInstance the id is "native", even in the executed sql there's no ID for
insert. So, what's happening? It should insert a row with id=2 but it says that
the id is duplicated.
Thanks!
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4032884#4032884
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4032884
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
