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 <[email protected]> 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.
>
>
