Re: Additional Parameters using TranQL Local Resource Adapter and MySQL

[Forrest Xia]

On Mon, May 31, 2010 at 7:13 PM, Johannes Weberhofer, Weberhofer GmbH <
off...@weberhofer.at> wrote:

> Dear David,
>
> sorry for the late reply; I have had a look at the snapshots - but how can
> I update Geronimo to use the new Drivers instead of the recent one?
>
Prepare the connector deployment plan, then use the snapshot RAR to deploy
it. For example, to deploy a postgre datasource:
1. download the snapshot from
http://snapshots.repository.codehaus.org/org/tranql/tranql-connector-postgresql-xa/1.3-SNAPSHOT/tranql-connector-postgresql-xa-1.3-20100428.005903-1.rar
2. install the postgre jdbc driver, the module ID is
postgresql/postgresql/8.3.603.jdbc4/jar, for example.
3. prepare a postgre datasource deployment plan like the attachment.
4. deploy the plan with the rar in admin console. Click "Deploy New"

mysql is similar.

Forrest

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";>
    <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";>
        <dep:moduleId>
            <dep:groupId>console.dbpool</dep:groupId>
            <dep:artifactId>postgrexads</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>car</dep:type>
        </dep:moduleId>
        <dep:dependencies>
            <dep:dependency>                
                <dep:groupId>postgresql</dep:groupId>
                <dep:artifactId>postgresql</dep:artifactId>
                <dep:version>8.3.603.jdbc4</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>postgrexads</name>
                    <config-property-setting name="PrepareThreshold"/>
                    <config-property-setting name="DatabaseName">tradedb</config-property-setting>
	                <config-property-setting name="UserName">trade</config-property-setting>
        	        <config-property-setting name="Password">trade</config-property-setting>
        	        <config-property-setting name="ServerName">localhost</config-property-setting>
			        <config-property-setting name="PortNumber">5432</config-property-setting>
                    <config-property-setting name="ssl">true</config-property-setting>
			        <config-property-setting name="sslfactory">org.postgresql.ssl.NonValidatingFactory</config-property-setting>                    
                    <connectionmanager>
                        <xa-transaction>
                                    <transaction-caching/>
                                </xa-transaction>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
</connector>