[jboss-user] [JBoss jBPM] - Re: SuperState DB tests - the fix throws Exception when one
I applied the above fix but then undeploying a process definion throws Excpetions.
The test case broken is:
public void testUndeploy() {
| ProcessDefinition procDef = new ProcessDefinition("testUndeploy");
| State s = new State("testnode");
| procDef.addNode(s);
| jbpmContext.deployProcessDefinition(procDef);
| newTransaction();
| ProcessDefinition pd =
jbpmContext.getGraphSession().findLatestProcessDefinition("testUndeploy");
| jbpmContext.getGraphSession().deleteProcessDefinition(pd);
| newTransaction();
| }
|
The hibernate query that creates the problem is:
Hibernate:
| update
| JBPM_NODE
| set
| PROCESSDEFINITION_=null,
| NODECOLLECTIONINDEX_=null
| where
| PROCESSDEFINITION_=?
| and (
| nodes0_.SUPERSTATE_ is null
| )
|
Finally the exception thrown is:
12:55:04,534 [main] WARN JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
| 12:55:04,534 [main] ERROR JDBCExceptionReporter - ORA-00904:
"NODES0_"."SUPERSTATE_": invalid identifier
|
| 12:55:04,534 [main] WARN JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
| 12:55:04,550 [main] ERROR JDBCExceptionReporter - ORA-00904:
"NODES0_"."SUPERSTATE_": invalid identifier
|
| 12:55:04,550 [main] ERROR AbstractFlushingEventListener - Could not synchronize
database state with session
| org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update
| at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
| at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
| at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
| at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
| at
org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:218)
| at
org.hibernate.persister.collection.AbstractCollectionPersister.remove(AbstractCollectionPersister.java:1030)
| at
org.hibernate.action.CollectionRemoveAction.execute(CollectionRemoveAction.java:28)
| at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:232)
| at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
| at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
| at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
| at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
| at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
| at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
| at org.jbpm.persistence.db.DbPersistenceService.close(DbPersistenceService.java:162)
| at org.jbpm.svc.Services.close(Services.java:211)
| at org.jbpm.JbpmContext.close(JbpmContext.java:139)
| ....
| Caused by: java.sql.BatchUpdateException: ORA-00904:
"NODES0_"."SUPERSTATE_": invalid identifier
|
| at
oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
| at
oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:8739)
| at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
| at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)
| at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:242)
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3993807#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...