how to persist data in oracle

[Kiran]

Hi,

   I want to persist the form data into oracle 11g XE database by using Jboss 7.2.0 server.

As part of this, i have updated the standalone.xml config file under Jboss server, PFA for the same.

Is there any way to persist the data directly into DB by serviceTask or do I need to use any spring/servlet application to save the data into database?

Thanks,

Kiran

[Sebastian Menski]

Hi Kiran,

have you seen our JavaEE gettings started guide [1]. There we use JPA to persist data in a service task [2].

Cheers,

Sebastian

[1] http://docs.camunda.org/7.2/guides/getting-started-guides/java-ee/

[2] http://docs.camunda.org/7.2/guides/getting-started-guides/java-ee/#tutorial-add-persist-service-task

[Kiran]

Thanks Sebastian, I will go through it.

Below link to configure oracle db in Jboss AS 7

http://blog.foos-bar.com/2011/08/jboss-as-7-and-oracle-datasource.html

Run the oracle scripts, which are under //JbossServer/sql/create/ in your local oracle by creating the user camunda/camudna

Find the attached standalone.xml file with oracle datasource.