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.
