Return-Path: 
 <user-return-12991-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 88698 invoked from network); 25 Mar 2009 07:49:06 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 25 Mar 2009 07:49:06 -0000
Received: (qmail 90229 invoked by uid 500); 25 Mar 2009 07:49:06 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 90210 invoked by uid 500); 25 Mar 2009 07:49:06 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 90202 invoked by uid 99); 25 Mar 2009 07:49:06 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Mar 2009 07:49:06 +0000
X-ASF-Spam-Status: No, hits=2.6 required=10.0
	tests=DNS_FROM_OPENWHOIS,SPF_HELO_PASS,SPF_PASS,WHOIS_MYPRIVREG
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Mar 2009 07:48:58 +0000
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1LmNqn-0007MS-Ej
	for user@geronimo.apache.org; Wed, 25 Mar 2009 00:48:37 -0700
Message-ID: <22696617.post@talk.nabble.com>
Date: Wed, 25 Mar 2009 00:48:37 -0700 (PDT)
From: Forrest_Xia <forrestxm@gmail.com>
To: user@geronimo.apache.org
Subject: One tip about using tranql to connect to Informix database
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: forrestxm@gmail.com
X-Virus-Checked: Checked by ClamAV on apache.org


A tip about IDS db connectivity, I am not sure if it is suitable for the
scope of this mailing list. 

However it's an output when I am using geronimo, so I arbitrarily post here,
hope it's not a big noise for this space and we can learn something form it
:)
 
As we know, there is a new tranql xa adapter for informix dynamic
server(IDS).

After some interesting test, find out that the new informix tranql xa
adapter only works with traditional informix jdbc driver, such as
"ifxjdbc.jar" and "ifxjdbcx.jar". It does not support Java Common
Client(JCC) driver to connect to IDS database.

For application running in Geronimo which wants to use JCC driver to connect
to IDS, there are two ways to do datasource setup:
1. If not using XA transaction, use tranql-connector-ra adapter to deploy
datasource
1.1 Install JCC driver into geronimo repository, download it from
http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21363866
1.2 Configure IDS instance to use "drsoctcp" protocol, restart it
1.3 Prepare a datasource deployment plan like this:
   <environment>
     ....
      <dependencies>
            <dependency>

                <groupId>com.ibm.db2</groupId>

                <artifactId>db2jcc</artifactId>

                <version>9.5</version>

                <type>jar</type>

            </dependency>

            <dependency>

                <groupId>com.ibm.db2</groupId>

                <artifactId>db2jcc_license_cu</artifactId>

                <version>9.5</version>

                <type>jar</type>

            </dependency>

            ....
         </dependencies>

    </environment>
    ...
    <ext-module>

        <connector>TradeDataSource</connector>

        <external-path
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">

            <dep:groupId>org.tranql</dep:groupId>

            <dep:artifactId>tranql-connector-ra</dep:artifactId>

            <dep:type>rar</dep:type>

        </external-path>

        <connector
xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">


            <resourceadapter>

                <outbound-resourceadapter>

                    <connection-definition>

                       
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>

                        <connectiondefinition-instance>

                            <name>jdbc/TradeDataSource</name>

                            <config-property-setting
name="UserName">informix</config-property-setting>
                            <config-property-setting
name="Password">passw0rd</config-property-setting>
                            <config-property-setting
name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>                            
                            <config-property-setting
name="ConnectionURL">jdbc:db2://idsserverhostnameorip:port/tradedb</config-property-setting>
                            <connectionmanager>
                                <local-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>

        </connector>

    </ext-module>
1.4 Deploy it with the application

2. if using XA transaction, use tranql-connector-db2-xa to deploy
datasource, the plan like this:
<ext-module>

        <connector>TradeDataSource</connector>

        <external-path
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">

            <dep:groupId>org.tranql</dep:groupId>

            <dep:artifactId>tranql-connector-db2-xa</dep:artifactId>

            <dep:type>rar</dep:type>

        </external-path>

        <connector
xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">


            <resourceadapter>

                <outbound-resourceadapter>

                    <connection-definition>

                       
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>

                        <connectiondefinition-instance>

                            <name>jdbc/TradeDataSource</name>

                            <config-property-setting
name="UserName">informix</config-property-setting>

                            <config-property-setting
name="Password">password</config-property-setting>

                            <config-property-setting
name="PortNumber">yourIDSinstancelistenport</config-property-setting>

                            <config-property-setting
name="ServerName">yourIDSinstanceserverhostnameorip</config-property-setting>

                            <config-property-setting
name="DatabaseName">tradedb</config-property-setting>

                            <config-property-setting
name="DriverType">4</config-property-setting>

                            <connectionmanager>

                                <xa-transaction>

                                    <transaction-caching/>

                                </xa-transaction>

                                <single-pool>

                                    <max-size>100</max-size>

                                    <min-size>0</min-size>

                                   
<blocking-timeout-milliseconds>5000</blocking-timeout-milliseconds>

                                   
<idle-timeout-minutes>30</idle-timeout-minutes>

                                    <match-one/>

                                </single-pool>

                            </connectionmanager>

                        </connectiondefinition-instance>
                        
                    </connection-definition>

                </outbound-resourceadapter>

            </resourceadapter>

        </connector>

    </ext-module>
-- 
View this message in context: http://www.nabble.com/One-tip-about-using-tranql-to-connect-to-Informix-database-tp22696617s134p22696617.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.