WebSphere Installation Guide

From jVantage

Jump to: navigation, search

Since many WebSphere installations also use DB2, this section first provides a few instructions on setting up a DB2 database. If you are not using DB2, please skip ahead to the WebSphere section below.


Contents

Create an Empty DB2 Database

Create an empty DB2 database for your jVantage installation.

Setup the DB2 Data Source

DB2 Universal JDBC Driver Provider

This section describes how to define a JDBC resource to connect to a DB2 data source from WebSphere using a non-XA DB2 Universal JDBC Driver-compliant Provider. Note that this is only one of many possible configurations. This information is applicable to WebSphere versions 5 and 6.

  • JDBC General Properties
    • Database type: DB2
    • Provider type: DB2 Universal JDBC Driver Provider
    • Implementation type: Connection Pool Data Source
  • Classpath
    • ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar (example, where DB2UNIVERSAL_JDBC_DRIVER_PATH=C:/Progra~1/IBM/SQLLIB/java)
    • ${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar (example, where UNIVERSAL_JDBC_DRIVER_PATH=${WAS_INSTALL_ROOT}/universalDriver/lib)
    • ${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
  • Native Library Path
    • ${DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH} (example, where DB2UNIVERSAL_JDBC_DRIVER_NATIVEPATH=E:/Progra~1/IBM/SQLLIB/lib)
  • Implementation Class Name
    • com.ibm.db2.jcc.DB2ConnectionPoolDataSource

Data Source

  • Name: jVantageDS
  • JNDI Name: jdbc/jVantageDS

The remaining data source information is specific to how and where your DB2 database is defined.

Install the jVantage EAR

Install the jVantage EAR file using the WebSphere console. You may accept the defaults on each screen, except for the Generate Default Bindings option. It should be checked.

Invoke the Setup Tool

The Setup tool can be invoked using the URL:

http://WebSphereHostName:<port>/jvantage/jvantage-setup

If your WebSphere server has been configured to listen on port 80, the URL can be expressed as

http://WebSphereHostName/jvantage/jvantage-setup

As shipped, WebSphere is configured to use port 9080 – if you have not changed this configuration, the URL will be:

http://WebSphereHostName:9080/jvantage/jvantage-setup

Follow the instructions on the screen to complete the installation.

Personal tools