I am trying to undeploy processdefinition from oracle database by using jbpm api. but it is throughing error. these are follows
code: JbpmConfiguration jbpmConfiguration = JbpmConfiguration.getInstance(); | JbpmContext jbpmContext = jbpmConfiguration.createJbpmContext(); | try { | ProcessDefinition processDefinition = jbpmContext.getGraphSession().findLatestProcessDefinition(processDefn.getName()); | jbpmContext.getGraphSession().deleteProcessDefinition(processDefinition); | }finally { | jbpmContext.close(); | } | error: 12:48:23,799 WARN [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000 | 12:48:23,799 ERROR [JDBCExceptionReporter] ORA-00904: "TEMPLATESE0_"."ID_": inva | lid identifier | | 12:48:23,831 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could n | ot initialize a collection: [org.jbpm.taskmgmt.def.Task.templateSet#1662789] | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j | ava:65) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp | er.java:43) | at org.hibernate.loader.Loader.loadCollection(Loader.java:1926) | at org.hibernate.loader.collection.CollectionLoader.initialize(Collectio | nLoader.java:71) | at org.hibernate.persister.collection.AbstractCollectionPersister.initia | lize(AbstractCollectionPersister.java:520) | at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onIn | itializeCollection(DefaultInitializeCollectionEventListener.java:60) | at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java: | 1627) | at org.hibernate.collection.AbstractPersistentCollection.initialize(Abst | ractPersistentCollection.java:344) | at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPe | rsistentCollection.java:86) | at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:13 | 8) | at org.hibernate.type.CollectionType.getElementsIterator(CollectionType. | java:196) | at org.hibernate.type.CollectionType.getElementsIterator(CollectionType. | java:188) | at org.hibernate.engine.CascadingAction.getAllElementsIterator(Cascading | Action.java:266) | at org.hibernate.engine.CascadingAction.access$100(CascadingAction.java: | 21) | at org.hibernate.engine.CascadingAction$2.getCascadableChildrenIterator( | CascadingAction.java:52) | at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:2 | 88) | at org.hibernate.engine.Cascade.cascadeCollection(Cascade.java:185) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:160) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108) | at org.hibernate.engine.Cascade.cascade(Cascade.java:248) | at org.hibernate.engine.Cascade.cascade(Cascade.java:223) | at org.hibernate.event.def.DefaultDeleteEventListener.cascadeBeforeDelet | e(DefaultDeleteEventListener.java:220) | at org.hibernate.event.def.DefaultDeleteEventListener.deleteEntity(Defau | ltDeleteEventListener.java:169) | at org.hibernate.event.def.DefaultDeleteEventListener.onDelete(DefaultDe | leteEventListener.java:110) | at org.hibernate.impl.SessionImpl.fireDelete(SessionImpl.java:764) | at org.hibernate.impl.SessionImpl.delete(SessionImpl.java:757) | at org.hibernate.engine.CascadingAction$2.cascade(CascadingAction.java:4 | 7) | at org.hibernate.engine.Cascade.cascadeToOne(Cascade.java:213) | at org.hibernate.engine.Cascade.cascadeAssociation(Cascade.java:157) | at org.hibernate.engine.Cascade.cascadeProperty(Cascade.java:108) | at org.hibernate.engine.Cascade.cascadeCollectionElements(Cascade.java:2 | 90) i have checked so many messages about this topic e.g. http://www.jboss.com/index.html?module=bb&op=viewtopic&t=78471 http://www.jboss.com/index.html?module=bb&op=viewtopic&t=82667 i have tried to delete processinstance before processdefinition code: jbpmContext.getGraphSession().deleteProcessInstance(pi); but still i am not able to undeploy if someone who has encountered this problem can u plz help me out regarding this. thanks in advance View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4023481#4023481 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4023481 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user