geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Forrest_Xia <forres...@gmail.com>
Subject One tip about using tranql to connect to Informix database
Date Wed, 25 Mar 2009 07:48:37 GMT

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.


Mime
View raw message