jBPM BPEL how to undeploy

[fwshk]

Hi all,

I would like to know how to undeploy a process from jBPM BPEL ? (Q1)

Besides, which database is preferred for jBPM BPEL persistent ? (Q2)
In the previous version (alpha3), I found Oracle is the best.
However, Oracle is not preferred in my situration.

In addition, where should I got documentation of jBPM BPEL ? (Q3)
I only found a few document in the "doc" folder of jBPM BPEL

Any replys are welcome and thank you very much.
Roy

[aguizar]

To undeploy the published services, delete the enterprise app archive from the deploy directory of your JBoss configuration.
To remove the process from the database, call
org.jbpm.db.GraphSession.deleteProcessDefinition()
There is no preference at all. The stability and performance of a specific database depends on the JDBC driver and the Hibernate dialect. If you have a concrete issue that prevents you from using jBPM BPEL with a specific database, let us know.
Personally, I use MySQL when I want to test against a production database. It has a small footprint, comes with decent tools and fails with meaningful messages, if it fails at all. I know PostgreSQL is good, too.
In a previous life, I was fond of SQL Server when targeting Windows platforms. SQL Server 2000 JDBC drivers have a number of issues. Conversely, SQL Server 2005 drivers are much better; they even have Hibernate certification.
I guess Oracle is good, considering how expensive it is, but I can't say much about it.
I'm afraid that's all we got right now. Please tell us if you feel some area really needs deeper coverage.

[bensonfungjava]

Hi Alex,

Could you give me more information how to remove the process from the database, org.jbpm.db.GraphSession.deleteProcessDefinition()?


Thanks
Benson