geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Cai <greensi...@gmail.com>
Subject Re: One tip about using tranql to connect to Informix database
Date Wed, 25 Mar 2009 08:41:24 GMT
Thanks for sharing Forrest! So theoritically Derby can also be connected
using the JCC driver, as it also supports the DRDA protocol that the JCC
driver implements.

-Jack

2009/3/25 Forrest_Xia <forrestxm@gmail.com>

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