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.
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