Re: deployment for MySQL XA.

[David Jencks]

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