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.
>
>