jms transacted with jboss-esb pipeline process

[maniv]

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>

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

[maniv]

Hi,

It looks like there are no other way to make jmstransacteddb without either using hypersonic nor h2 database. And i am not able to find similar mbean like hypersonicedatabase name as "org.jboss.internal.soa.esb.dependencies.HypersonicDatabase" to mysql database.

If there are anyother way exist please let me know as soon as possible.

[maniv]

while changing to other database no need to mention mbean similar to "org.jboss.internal.soa.esb.dependencies.HypersonicDatabase" . and instead use jms-provider or jms-jca-provider in jboss-esb file saying transacted="true".