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#3993807

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3993807
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to