Information for creating JDBC connections
When you create a JDBC connection, you can use this section to help you determine some of the values you must enter.
*
If you are not using the default port setting for your database, make sure you change it to the correct value.
This information does not reflect all of the information required by the web application servers. Where this section does not provide explicit instructions, you can accept the default values. Consult the application server documentation if you need more comprehensive help.
WebLogic
Use these 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 11g
*
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 using the format 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 these 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 and modify properties as follows.
*
serverName=<your_SQL_server_name>
*
portNumber =<SQL_Server_Port_Number>
*
databaseName=<your_database_name>
*
enable2Phase = false
Oracle 11 and 11g
*
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 using the format 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>
Copyright IBM Corporation 2013. All Rights Reserved.