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