Information for 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, change it to the correct value.
This information does not exactly 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
*
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>
*
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>
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 2012. All Rights Reserved.