geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: deployment for MySQL XA.
Date Mon, 19 Jan 2009 07:23:23 GMT
  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.
>
>


Mime
View raw message