...
These files are available in the <sqllib_home>\java
directory. For additional information about the DB2 JDBC drivers and licenses, visit the DB2 Information Center available at the following URL:
To use these files in Geronimo, rename (copy and rename) the files according to the following table. In this case, you will not use db2jcc_license_cisuz.jar because it is for Z/OS and iSeries.
...
To use the administration console, Apache Geronimo must be running. Access the Geronimo Administration Console by pointing your browser to the following URL:
- Enter system as the user name and manager as the password and click Login.
- Click Services->Repository portlet.
- Click Browse and select the first file to install. In this case, you can install db2jcc-9.5.jar first.
- A set of values will be proposed by default, set the Group: to com.ibm.db2, leave the rest by default and click Install.
- Repeat the previous two steps for db2jcc_license_cisuz-9.5.jar.
...
As an alternative to the wizard, you can create a deployment plan manually and deploy it by using the command line based deployer tool. To use this option, create a db2-plan.xml file and copy the content of the following example to the file.
Code Block | ||||||||
---|---|---|---|---|---|---|---|---|
| ||||||||
<?xml version="1.0" encoding="UTF-8"?> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2"> <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2"> <dep:moduleId> <dep:groupId>console.dbpool</dep:groupId> <dep:artifactId>DB2_ds</dep:artifactId> <dep:version>1.0</dep:version> <dep:type>car</dep:type> </dep:moduleId> <dep:dependencies> <dep:dependency> <dep:groupId>com.ibm.db2</dep:groupId> <dep:artifactId>db2jcc</dep:artifactId> <dep:version>9.5</dep:version> <dep:type>jar</dep:type> </dep:dependency> <dep:dependency> <dep:groupId>com.ibm.db2</dep:groupId> <dep:artifactId>db2jcc_license_cu</dep:artifactId> <dep:version>9.5</dep:version> <dep:type>jar</dep:type> </dep:dependency> </dep:dependencies> </dep:environment> <resourceadapter> <outbound-resourceadapter> <connection-definition> <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface> <connectiondefinition-instance> <name>DB2_ds</name> <config-property-setting name="TraceFile"/> <config-property-setting name="UserName">db2admin</config-property-setting> <config-property-setting name="DatabaseName">sample</config-property-setting> <config-property-setting name="Password">db2admin</config-property-setting> <config-property-setting name="ServerName">localhost</config-property-setting> <connectionmanager> <local-transaction/> <single-pool> <max-size>10</max-size> <min-size>0</min-size> <match-one/> </single-pool> </connectionmanager> </connectiondefinition-instance> </connection-definition> </outbound-resourceadapter> </resourceadapter> </connector> |
...