Information for creating JDBC connections

Use default values when you create JDBC connections if specific values are not provided. For more information, see the application server documentation.

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

WebLogic

Use the following values if your application server is WebLogic:

SQLServer

  • Database Driver: Microsoft™ MS SQL Server Driver (Type 4) Versions: 2012, 2012 SP1 and SP3, 2014, 2014 SP1

  • Default port: 1433

  • Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver

  • Driver URL: jdbc:sqlserver://<your_db_host>[\\<named_instance>]:<your_db_port>;databaseName=<your_db_name>

  • Properties: Add user=<your_db_user_name>

Oracle

  • Driver: Other

  • Default port: 1521

  • Driver class: oracle.jdbc.OracleDriver

  • Driver URL: jdbc:oracle:thin:@<your_db_host>:<your_db_port>:<your_db_service_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>

DB2®

  • Driver: Other

  • Default port: 50000

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

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

  • Properties: Add user=<your_db_user_name>

WebSphere®

Use the following values if your application server is WebSphere:

SQLServer

  • Driver: N/A

  • Default port: 1433

  • Driver class: com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource

  • Driver URL: N/A

In the Database Type field, select User-defined.

After you create the JDBC Provider and data source, go to the Custom Properties for the data source, and add, modify properties as follows.

  • serverName=<your_SQL_server_name>
  • portNumber =<SQL_Server_Port_Number>
  • databaseName=<your_database_name>

Add the following custom property:

Name: webSphereDefaultIsolationLevel

Value: 1

Datatype: Integer

Oracle

  • Driver: Oracle JDBC Driver

  • Default port: 1521

  • Driver class: oracle.jdbc.OracleDriver

  • Driver URL: jdbc:oracle:thin:@<your_db_host>:<your_db_port>:<your_db_service_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.

DB2

  • Driver: JCC 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