2 Replies Latest reply on Nov 21, 2011 7:28 AM by mani v

    jms transacted with jboss-esb pipeline process

    mani v Newbie

      Hi,

       

      I am able to run jms_transacted example in jboss-esb server with hsqldb ( mbean : org.jboss.internal.soa.esb.dependencies.HypersonicDatabase)..

      But my question is what mbean interface i should use when i want to switch over to mysql database where i ll be using mysql datasource

       

      ----------------------

      <?xml version="1.0" encoding="UTF-8"?>
      <datasources>
         <local-tx-datasource>
            <jndi-name>JmsTransactedDB</jndi-name>
            <connection-url>jdbc:hsqldb:hsql://localhost:1706</connection-url>
            <driver-class>org.hsqldb.jdbcDriver</driver-class>
            <user-name>sa</user-name>
            <password></password>
            <min-pool-size>5</min-pool-size>
            <max-pool-size>20</max-pool-size>
            <idle-timeout-minutes>0</idle-timeout-minutes>
            <depends>jboss:service=JmsTransactedDB</depends>
            <prepared-statement-cache-size>32</prepared-statement-cache-size>
         </local-tx-datasource>

         <mbean code="org.jboss.internal.soa.esb.dependencies.HypersonicDatabase"
           name="jboss:service=JmsTransactedDB">
           <attribute name="Port">1706</attribute>
           <attribute name="BindAddress">localhost</attribute>
           <attribute name="Database">JmsTransactedDB</attribute>
           <attribute name="Silent">true</attribute>
           <attribute name="Trace">false</attribute>
           <attribute name="No_system_exit">true</attribute>
           <attribute name="DataDir">${jboss.server.data.dir}</attribute>
         </mbean>
      </datasources>

      -----------------------------------------------------------