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 may 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's MS SQL Server Driver (Type 4) Versions: 2005
*
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 Other.
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.