Versions Compared

Old Version 8

changes.mady.by.user Unknown User (hcunico@gmail.com)

Saved on

compared with

New Version 9

changes.mady.by.user Unknown User (hcunico@gmail.com)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Enter the remanining connection information as shown in the following figure. For this example the default db2admin user and password was used . Also and a SAMPLE database was created via the DB2 Control Center.

Click Next.

Leave the options on Step 3 by default, you should see the message Driver Status: Loaded Successfully.

...

Code Block
xml
xml
borderStylesolid
titleUpdated db2_plan.xml deployment plan
<?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>

...