Appendix B. JDBC Data Source Configuration Examples

Table of Contents

B.1. Overview
B.2. Oracle Thin (Type4) Configuration Example
B.2.1. Oracle Thin Connection Pool Data Source
B.2.2. Oracle Thin XA Data Source
B.3. Oracle OCI (Type2) Configuration Example
B.3.1. Oracle OCI Connection Pool Data Source
B.4. DB2 Configuration Example
B.4.1. DB2 Type4(JCC) Connection Pool Data Source
B.4.2. DB2 Type4(JCC) XA Data Source
B.4.3. DB2 Type2(JCC) XA Data Source
B.5. Sybase Configuration Example
B.5.1. Sybase jConnect 5.x Connection Pool Data Source
B.5.2. Sybase jConnect 6.x XA Data Source
B.6. MSSQL Configuration Example
B.6.1. MSSQL 2005 Connection Pool Data Source
B.7. Informix Configuration Example
B.7.1. Informix Connection Pool Data Source
B.8. Tibero Configuration Example
B.8.1. Tibero Connection Pool Data Source
B.9. MySQL 5.x Configuration Example
B.9.1. MySQL Connector/J Connection Pool Data Source

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.