Information for creating JDBC connections in WebSphere

In this release, WebSphere is the only supported application server, and DB2 is the only supported database for all data sources except profile tables. For profile tables, Oracle is also supported.

Note: If you are not using the default port setting for your database, make sure that you enter the correct value.

For more information, see the application server documentation.

DB2®

  • Driver: DB2 Universal JDBC Driver Provider

  • Default port: 50000

  • Driver class: com.ibm.db2.jcc.DB2Driver

  • Driver URL: jdbc:db2://your_db_host:your_db_port/your_db_name

Add the following custom property:

Name: webSphereDefaultIsolationLevel

Value: 2

Datatype: Integer

Oracle 11 and 11 g

Oracle 11 and 11 g are supported only for profile tables.

  • Driver: Other

  • Default port: 1521

  • Driver class: oracle.jdbc.OracleDriver

  • Driver URL: jdbc:oracle:thin:@your_db_host:your_db_port:your_db_name>

    Enter the driver URL by using the format that is shown. IBM® EMM applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.

  • Properties: Add user=your_db_user_name