geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Forrest Xia <forres...@gmail.com>
Subject Re: deployment for MySQL XA.
Date Mon, 19 Jan 2009 03:44:12 GMT
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