BTM and MySQL

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

BTM and MySQL

Mondain
Has anyone here had luck with MySQL and BTM? I'm using BTM 1.3, ConnectorJ 5.1.6, and Spring 2.5.5 and I cant seem to get a valid connection to my local db. My data source is setup like so:

    <bean id="dataSource" class="bitronix.tm.resource.jdbc.PoolingDataSource" init-method="init" destroy-method="close">
        <property name="className" value="com.mysql.jdbc.jdbc2.optional.MysqlXADataSource"/>
        <property name="uniqueName" value="jdbc/ds" />
        <property name="minPoolSize" value="2" />
        <property name="maxPoolSize" value="32" />
        <property name="acquisitionInterval" value="1" />
        <property name="acquisitionTimeout" value="15" />
        <property name="maxIdleTime" value="15" />
        <property name="useTmJoin" value="true" />
        <property name="deferConnectionRelease" value="true" />
        <property name="automaticEnlistingEnabled" value="true"/>
        <property name="allowLocalTransactions" value="true"/>
        <property name="testQuery" value="SELECT current_timestamp" />
        <property name="driverProperties">
            <props>
                <prop key="user">MyUser</prop>
                <prop key="password">password</prop>
                <prop key="databaseName">MyDB</prop>
                <prop key="serverName">127.0.0.1</prop>
                <prop key="portNumber">3306</prop>
                <prop key="url">jdbc:mysql://127.0.0.1/MyDB?autoReconnect=true</prop>
            </props>
        </property>
    </bean>   


This particular data source bean has used succesfully with MSSQL and JTDS datasources. I have also tried using com.mysql.jdbc.jdbc2.optional.MysqlXaConnectionPoolDataSource instead of the DS shown, but it failed also.

Thanks,
Paul


--
http://gregoire.org/
http://osflash.org/red5