JBPM Oracle Connectivity

[puneetjains]

mbean code="org.jboss.jdbc.HypersonicDatabase" name="jboss:service=JbpmDatabase">
attribute name="Port">1521
attribute name="Silent">true
attribute name="Database">jbpm
attribute name="Trace">false
attribute name="No_system_exit">true
/mbean>



in jbpm configuration if i am using Oracle Database then what should i write instead of "org.jboss.jdbc.HypersonicDatabase"

[pkliem]

Hi,

when you are using oracle with jbpm you don't need to setup the HypersonicDatabse as an mbean. You can delete the jbpm-db-service.xml from the deploy directory. All you have to change are the settings for hibernate (dialect++) and the Datasource to be used: this is the file jbpm-ds.xml. I'm using this:

<?xml version="1.0" encoding="UTF-8"?>

<!-- ======= -->
<!-- jBpm DS -->
<!-- ======= -->


<local-tx-datasource>
<jndi-name>JbpmDS</jndi-name> <!-- look it up with "java:/JbpmDs" -->

<!-- for clustered deployment, change 'localhost' in the following -->
<!-- line to the ip-address of the database node -->
<connection-url>jdbc:oracle:thin:@localhost:1521:db</connection-url>

<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>jbpm</user-name>
jbpm
<min-pool-size>1</min-pool-size>
<max-pool-size>2</max-pool-size>
<idle-timeout-minutes>0</idle-timeout-minutes>
<track-statements>true</track-statements>
<!-- jboss:service=JbpmDatabase
--> </local-tx-datasource>



You see the commented dependency to the service that has been defined in jbpm-db-service.xml.