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 <forres...@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. > >