In fact I tried to remove it by using SQL commands but it doesnt work so my question again is....
How do I removed a process once it has been deployed?
Trying to remove things straight from the DB can be hairy, as there are a lot of interconnected tables.
It's there in the API, look at GraphSession and it's method .deleteProcessDefinition
You get the graphSession from jbpmContext.getGraphSession()
Ao are you saying I need to actually write the code to call the .deleteProcessDefinition method and other associated beans?
Is it not readily available in the jmx-console or anywhere else?
Uh??, yes you will need to write code, how else would you use a library/engine?
There is no other JMX functionality for jBPM, and that startDatabaseManager() is a Hypersonic JMX call (I think), not a jBPM call.