Information for creating JDBC connections in WebSphere
In this release, WebSphere is the only supported application server.
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
Oracle 11 is 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. HCL® Marketing Software applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.
- Properties: Add user=your_db_user_name
Oracle 12c
Oracle 12c is supported for system tables as well as profile tables
-
Default port: 1521
-
Driver class:
ojdbc7.jar
-
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. HCL Marketing Software applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.
- Properties: Add user=your_db_user_name>