We are using jBPM 3.2 and right now, we would like to purge some old/completed process instances from the database. I find that there is a deleteProcessInstance API. Is there a SQL or PL/SQL procedure available anywhere? So that we can run that from the db directly and might be faster since we don't have to go thro' Hibernate.
No, but you can set the org.hibernate.SQL log category to DEBUG, record the produced SQL statements and roll your own procedure. jBPM does not ship with any data manipulation scripts.