Information for creating JDBC connections in WebSphere

In this release, WebSphere is the only supported application server.

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

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>