THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Original name | Renamed |
|---|---|
db2jcc.jar | db2jcc-9.5.jar |
db2jcc_license_cu.jar | db2jcc_license_cu-9.5.jar |
db2jcc_license_cisuz.jar | db2jcc_license_cisuz-9.5.jar |
This means that for this particular case DB2 v9.5 was used.
...
com/ibm/db2/db2jcc_license_cisuz/9.5
and copy the db2jcc_license_cisuz-9.5.jar into that directory.com/ibm/db2/db2jcc_license_cu/9.5
and copy the db2jcc_license_cisuz-9.5.jar into that directory.
...
- Enter the system as the user and manager as the password and click Login.
- Click on Common Libs to access the Repository viewer Services->Repository portlet.
- Click on Browse and select the first file to install. In this case we will first install db2jcc-9.5.jar.
- 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 and db2jcc_license_cisuz-9.5.jar
With the drivers and license files installed, you can now create a new database connection pool.
...
In Step 1, enter the pool name DB2_ds and database type DB2(DataDirect) in the database pool wizard and then click Next. See illustration in the following figure.
In Step 2, leave fill in the JDBC Driver Class: field by default (with com.ibm.db2.jcc.DB2Driver). If you click the Driver JAR: pull-down menu you should now see the three com.ibm/db2... jars you copied in the repository. Since Geronimo v1.1 only allow you to select ONE jar file from this menu select the first jar on the list, . And then select Driver JAR as following com/ibm/db2/db2jcc/9.5/jar and com.ibm/db2/db2jcc_license_cu/9.5/jar which is the driver itself. You will add manually the license jars in the next steps from the list by pressing Ctrl on the keyboard.
Enter the remaining connection information as shown in the following figure. For this example the default db2admin user and password was used and a SAMPLE database was created via the DB2 Control Center.
...
| 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>rar</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_cisuz</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="Password">db2admin</config-property-setting>
<config-property-setting name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>
<config-property-setting name="UserName">db2admin</config-property-setting>
<config-property-setting name="ConnectionURL">jdbc:db2://localhost:50000/SAMPLE</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>
|
...
deploy --user system --password manager deploy <dep_plan_home>\db2-plan.xml ..\repository\org\tranql\tranql-connector-db2-xa\1.34\tranql-connector-db2-xa-1.34.rar
You will receive the following message:
No Format bgColor #000000 borderStyle solid
D:\geronimo-tomcat6-jee5-2.2\bin>deploy --user system --password manager deploy \tmp\db2-plan.xml ..\repository\org\tranql\tranql-connector-db2-xa\1.34\tranql-connector-db2-xa-1.34.rar
Using GERONIMO_BASE: D:\geronimo-tomcat6-jee5-2.2
Using GERONIMO_HOME: D:\geronimo-tomcat6-jee5-2.2
Using GERONIMO_TMPDIR: D:\geronimo-tomcat6-jee5-2.2\var\temp
Using JRE_HOME: C:\Java\jdk1.5.0_06\\jre
Deployed console.dbpool/DB2_ds/1.0/rar
...