Did you try these?  Driver based connectors don't support xa.  Also your ms sql sample doesn't include any transaction element at all.

thanks
david jencks

On Jan 18, 2009, at 7:44 PM, Forrest Xia wrote:

MySQL sample:
<resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>jdbc/SampleDatasource</name>
                    <config-property-setting name="UserName">root</config-property-setting>
                    <config-property-setting name="Password"/>
                    <config-property-setting name="Driver">com.mysql.jdbc.Driver</config-property-setting>
                    <config-property-setting name="ConnectionURL">jdbc:mysql://localhost:3306/sampledb</config-property-setting>
                    <config-property-setting name="CommitBeforeAutocommit">true</config-property-setting>
                    <connectionmanager>
                        <xa-transaction>
                            <transaction-caching/>
                        </xa-transaction>
                        <single-pool>
                            <max-size>5</max-size>
                            <min-size>0</min-size>
                            <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <idle-timeout-minutes>15</idle-timeout-minutes>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>

MS SQL sample:
<resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>jdbc/SampleDatasource</name>
                    <config-property-setting name="UserName">username</config-property-setting>
                    <config-property-setting name="Password">password</config-property-setting>
                    <config-property-setting name="Driver">com.microsoft.sqlserver.jdbc.SQLServerDriver</config-property-setting>
                    <config-property-setting name="ConnectionURL">jdbc:sqlserver://servername:1433;DataBaseName=sampledb</config-property-setting>
                    <connectionmanager>
                        <single-pool>
                            <max-size>5</max-size>
                            <min-size>0</min-size>
                            <blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>
                            <idle-timeout-minutes>15</idle-timeout-minutes>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>

Good luck!

Forrest

On Mon, Jan 19, 2009 at 10:47 AM, bongosdude <bongosdude@gmail.com> wrote:

Can someone show me how to create deployment plan for MySQL XA datasource?
How is about MS SQL (local transaction)

Thanks
-B

-----
B Amigo:super:
--
View this message in context: http://www.nabble.com/deployment-for-MySQL-XA.-tp21536125s134p21536125.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.