How to Use Oracle as WebSphere Repository in WebSphere 4.0 Using Oracle Thin JDBC Driver?
 Technote (FAQ)
 
Problem
Fields in admin.config for Oracle JDBC
 
Solution
The following parameters are required to change when using Oracle as WebSphere repository:

I. Edit the admin.config with the following changes:

1. Add the Oracle JDBC Thin Driver jar file "classes12.zip" to the AdminServer's classpath

2. Enter the values for the parameters in the section "# Repository database settings"

# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=
com.ibm.ejs.sm.adminServer.dbserverName=
com.ibm.ejs.sm.adminServer.dbportNumber=
com.ibm.ejs.sm.adminServer.dbdatabaseName=
com.ibm.ejs.sm.adminServer.dbuser=
com.ibm.ejs.sm.adminServer.dbpassword=
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true

For example:

com.ibm.ejs.sm.adminserver.classpath=C:\download\Oracle\thin\classes12.zip;
/C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
...
...
...
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=
oracle.jdbc.pool.OracleConnectionPoolDataSource
com.ibm.ejs.sm.adminServer.dbserverName=HORIZON
com.ibm.ejs.sm.adminServer.dbportNumber=1521
com.ibm.ejs.sm.adminServer.dbdatabaseName=ORCL
com.ibm.ejs.sm.adminServer.dbuser=ejsadmin
com.ibm.ejs.sm.adminServer.dbpassword=ejsadmin
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
# URL is only valid for Oracle
com.ibm.ejs.sm.adminServer.dbURL=jdbc:oracle:thin:@HORIZON:1521:ORCL


Notes:

- HORIZON is the hostname of the Oracle Database Server (IP address can be specified
instead of hostname)
- 1521 is the Oracle Listener port number (default is 1521)
- ORCL is the ORACLE_SID
- ejadmin is the Oracle userid (can be other name).
This userid must be created by Oracle DBA prior to starting WebSphere

II. Edit the setupCmdLine.bat

Add the Oracle JDBC Thin Driver jar file "classes12.zip" to the line
"SET DBDRIVER_JARS".

For example:

SET DBDRIVER_JARS=C:\download\Oracle\thin\classes12.zip
 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Administrative Console (all non-scripting)
Operating system(s): HP-UX
Software version: 4.0.1
Software edition:
Reference #: 1048308
IBM Group: Software Group
Modified date: Nov 20, 2003