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.
*
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: 2008, 2008R2
*
Default port: 1433
*
Driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver
*
Driver URL: jdbc:sqlserver://<your_db_host>:<your_db_port>;databaseName=<your_db_name>
*
Properties: Add user=<your_db_user_name>
Oracle 11 and 11 g
*
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. 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>
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 11 and 11 g
*
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. IBM® EMM applications do not allow the use of Oracle's RAC (Real Application Cluster) format for JDBC connections.
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
Copyright IBM Corporation 2014. All Rights Reserved.