[jboss-user] [JBoss jBPM] - Re: SuperState DB tests - the fix throws Exception when one

gmournos do-not-reply at jboss.com
Thu Dec 14 07:00:45 EST 2006


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



More information about the jboss-user mailing list