Page History

...

For additional information on the DB2 JDBC drivers and licenses visit the DB2 Information Center available at the following URL:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/t0010264.htm^{Image Removed}

Rename the files you just copied so Geronimo can recognize them.

...

Once the server is started open the Geronimo Administration Console by pointing a Web browser to the following URL:

http://localhost:8080/console^{Image Removed}

Enter system and manager as the username and password.

...

The deployment plan generated by the wizard is shown in the following example.

Code Block

	xml	xml
borderStyle	solid
title	Wizard generated deployment plan
	xml

<?xml version="1.0" encoding="UTF-8"?>
<connector 
	configId="user/database-pool-DB2_Test/1/car" 
	xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.0">
	<dep:dependency xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.0">
		<dep:uri>db2/db2jcc/8.1.8/jar</dep:uri>
	</dep:dependency>
	
	<resourceadapter>
		<outbound-resourceadapter>
		<connection-definition>
			<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
				<connectiondefinition-instance>
					<name>DB2_Test</name>
					<config-property-setting name="Password">db2admin</config-property-setting>
					<config-property-setting name="CommitBeforeAutocommit">false</config-property-setting>
					<config-property-setting name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>
					<config-property-setting name="ExceptionSorterClass">org.tranql.connector.AllExceptionsAreFatalSorter</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>
							<match-one/>
						</single-pool>
					</connectionmanager>
				</connectiondefinition-instance>
			</connection-definition>
		</outbound-resourceadapter>
	</resourceadapter>
</connector>

...

Edit the db2_plan.xml file you just created and add the dependencies for the license jar files as illustrated in the following example.

Code Block

	xml	xml
borderStyle	solid
title	Updated db2_plan.xml deployment plan
	xml

<?xml version="1.0" encoding="UTF-8"?>
<connector 
	configId="user/database-pool-DB2_Test/1/car" 
	xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.0">

<!-- #####        COMMENT OUT THIS SECTION      ##### -->
<!--										-->
<!--    <dep:dependency xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.0">	-->
<!--        <dep:uri>db2/db2jcc/8.1.8/jar</dep:uri>					-->
<!--    </dep:dependency>								-->



<!-- ##### ADD THE FOLLOWING THREE DEPENDENCIES ##### -->
		<dependency>
			<uri>db2/db2jcc/8.1.8/jar</uri>
		</dependency>

		<dependency>
			<uri>db2/db2jcc_license_cu/8.1.8/jar</uri>
		</dependency>

		<dependency>
			<uri>db2/db2jcc_license_cisuz/8.1.8/jar</uri>
		</dependency>


<!-- #####  THE REMAINING PART DOES NOT CHANGE  ##### -->
	
	<resourceadapter>
		<outbound-resourceadapter>
		<connection-definition>
			<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
				<connectiondefinition-instance>
					<name>DB2_Test</name>
					<config-property-setting name="Password">db2admin</config-property-setting>
					<config-property-setting name="CommitBeforeAutocommit">false</config-property-setting>
					<config-property-setting name="Driver">com.ibm.db2.jcc.DB2Driver</config-property-setting>
					<config-property-setting name="ExceptionSorterClass">org.tranql.connector.AllExceptionsAreFatalSorter</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>
							<match-one/>
						</single-pool>
					</connectionmanager>
				</connectiondefinition-instance>
			</connection-definition>
		</outbound-resourceadapter>
	</resourceadapter>
</connector>

...

Child pages

Versions Compared

Old Version 15

New Version 16

Key