Using MS SQL Server 7.0 or 2000 as WebSphere 4.0 Repository through the WebSphere Branded DataDirect Connect JDBC (Type 4) Driver
 Technote (FAQ)
 
Problem
This technote explains the parameters to specify in the admin.config file when using WebSphere® branded DataDirect (formerly Merant) Connect JDBC™ driver with SQLServer 7.0 or 2000.
 
Solution

The assumption is that you already created the database to use as a WebSphere repository and a login within SQL Server.

In the admin.config file, set the highlighted parameters as follows:

# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource
com.ibm.ejs.sm.adminServer.dbserverName=<hostname>
com.ibm.ejs.sm.adminServer.dbportNumber=<portnr>
com.ibm.ejs.sm.adminServer.dbdatabaseName=<dbname>
com.ibm.ejs.sm.adminServer.dbuser=<userid>
com.ibm.ejs.sm.adminServer.dbpassword=<password>
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
com.ibm.ejs.sm.adminServer.dbselectMethod=cursor
.....

where:
<hostname> is the hostname or IP address of the server where SQL Server is installed
<portnr> is the default TCP/IP port that the server should listen on when accepting connections from TCP/IP Sockets clients. The default is 1433.
<dbname> - SQL Server database where the WAS repository will be created
<userid> - SQL Server's userid that is the owner of WAS repository
<password> - Password for the above <userid>

For example:

# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=com.ibm.websphere.jdbcx.sqlserver.SQLServerDataSource
com.ibm.ejs.sm.adminServer.dbserverName=earth
com.ibm.ejs.sm.adminServer.dbportNumber=1433
com.ibm.ejs.sm.adminServer.dbdatabaseName=was
com.ibm.ejs.sm.adminServer.dbuser=ejsadmin
com.ibm.ejs.sm.adminServer.dbpassword=ejsadmin
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
com.ibm.ejs.sm.adminServer.dbselectMethod=cursor
 
 
 


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.7
Software edition:
Reference #: 1055142
IBM Group: Software Group
Modified date: Nov 30, 2004