Bookshelf Home | Contents | Index | Search | PDF

Siebel Interactive Selling Transact Server Interface Reference > Additional Tasks >

Set Up JDBC and Data Source for WebSphere

---

Follow these steps to set up the JDBC driver and data source for WebSphere.

To set up the JDBC driver and data source for WebSphere

Start WebSphere WAS AdminServer.
Install JDBC Driver.
From the View menu, select Type.
In the left-side view panel, right-click JDBC Driver and select Create.
Select Driver and enter a driver name.

This can be any name. Remember this driver name for the data source (for example, DB2JDBCDriver).

Select com.ibm.db2.jdbc.app.DB2Driver if you use DB2. Select oracle.jdbc.driver.OracleDriver for Oracle database.
Select jdbc:db2 for URL Prefix for DB2. Modify hostname from URL prefix to Oracle server hostname from Oracle database.
Select False for JTA Enabled.
Install the Data Source.
In the left-side view panel, right-click DataSource and select Create.
Enter a DataSource Name. (For example: Sample is already installed with DB2.)
Enter the JDBC driver name in the Database Name field.
From the View menu, select Topology.
In the left-side view panel, right-click DB2JDBCDriver and select Install.
Select the machine on which the user wants to install the JDBC driver.
Click Browse, select <SQLLIB root>/java/db2java.zip file for db2 or select classes12.zip from <oracle folder>/jdbc/lib for Oracle database, and click Open.
Click Install.

The JDBC driver will be installed.

For more information on WAS, visit the following URL:
http://www-4.ibm.com/software/webservers/appserv/doc/v35/ae/infocenter/index.html

Bookshelf Home | Contents | Index | Search | PDF