1 Reply Latest reply on Jan 11, 2005 4:22 AM by Peter Kliem

    JBPM Oracle Connectivity

    Puneet Jain Newbie


      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"

        • 1. Re: JBPM Oracle Connectivity
          Peter Kliem Newbie

          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.