Table of Contents
- B.1. Overview
- B.2. Oracle Thin (Type4) Configuration Example
- B.3. Oracle OCI (Type2) Configuration Example
- B.4. DB2 Configuration Example
- B.5. Sybase Configuration Example
- B.6. MSSQL Configuration Example
- B.7. Informix Configuration Example
- B.8. Tibero Configuration Example
- B.9. MySQL 5.x Configuration Example
This appendix provides examples of configuring data sources of major database vendors.
Configurations of the following JDBC data sources are shown in the examples of this appendix.
-
Oracle Thin
-
Oracle OCI
-
DB2 Type4 (JCC)
-
DB2 Type2 (JCC)
-
Sybase jConnect 5.x, 6.x
-
MSSQL 2005 Type4
-
Informix Type4
-
Tibero Type4
-
MySQL 5.x Type4
This appendix can be used to configure data sources in WebAdmin. Refer to "6.4. Data Source Configuration" for information about how to configure a data source in WebAdmin.
The following screenshots show how to configure an Oracle Thin connection pool data source in WebAdmin.
The following screenshots show how to configure an Oracle Thin XA data source in WebAdmin.
This section describes how to configure java.util.Properties with Oracle ASO.
Using the <property> element, set <type> to java.util.Properties and <value> as follows:
[property name 1]=[value 1], [property name 2]=[value 2]
[Example B.1] <<domain.xml>>
<domain>
. . .
<resources>
<data-source>
<database>
<data-source-id>oracle_CPDS1</data-source-id>
<export-name>oracle_CPDS1</export-name>
<data-source-class-name>
oracle.jdbc.pool.OracleConnectionPoolDataSource
</data-source-class-name>
<data-source-type>
ConnectionPoolDataSource
</data-source-type>
<vendor>oracle</vendor>
<server-name>192.168.1.2</server-name>
<port-number>1521</port-number>
<database-name>ora9</database-name>
<user>scott</user>
<password>tiger</password>
<property>
<name>driverType</name>
<type>java.lang.String</type>
<value>thin</value>
</property>
<property>
<name>ConnectionProperties</name>
<type>java.util.Properties</type>
<value>
oracle.net.encryption_client=xxxx,
oracle.net.encryption_types_client=(3DES168,3DES112),
oracle.net.crypto_checksum_client=xxxx,
oracle.net.crypto_checksum_types_client=(MD5)
</value>
</property>
<connection-pool>
. . .
</connection-pool>
</database>
. . .
</data-source>
. . .
</resources>
</domain>
To use the Oracle OCI driver, configure the driver's native library path by using the '-Djava.library.path' option when starting JEUS.
The following screenshots show how to configure a DB2 Type4 connection pool data source in WebAdmin.
The following screenshots show how to configure a DB2 Type4 XA data source.
To use a DB2 Type 2 driver, configure the native library path of the DB2 client in the system library path, or use the '-Djava.library.path' option when starting JEUS after installing the DB2 client and configuring the DB Alias. The following example shows that the database name is the DB Alias, and the server address and port number of DB2 are not needed.
The following screenshots show how to configure a Sybase jConnect 5.x connection pool data source in WebAdmin.
The following screenshots show how to configure an MSSQL 2005 connection pool in WebAdmin.
Note
ODBC must be configured before configuring JDBC.
The following screenshots show how to configure a MySQL Connector/J connection pool data source in WebAdmin.
