Featured Post

The great debacle of healthcare.gov

This is the first time in history when the president of the United States of America, or probably for any head of state around the world,...

Friday, February 29, 2008

WebSphere Application Server

Websphere Application Server 5.1: Test Environment Setup

1. In Configure tab
  • Enable administration console
2. In Environment tab
  • Open Java VM Settings section add any system properties you want in your application like logger class or environment information (dev, sys or prod etc.)
3. In Variables tab
  • Open Node Settings
    • set the ORACLE_JDBC_DRIVER_PATH to jdbc driver jar location
4. In Security tab
  • Open JAAS Authentication
    • Add an alias: user-auth;
      • Username : <db-user>
      • Password : <password>
5. In DataSource tab
  • Open Server Settings section
    • In JDBC Provider List set
      • Oracle JDBC provider: Oracle Thin Driver;
      • Implementation Class: OracleConnecctionPoolDataSource
  • Define DataSource after choosing the just created Provider
    • Class path = {ORACLE_JDBC_DRIVER_PATH}/<jdbc-driver>.jar
    • Data source
      • 1st Screen
        • Oracle Thin Driver
      • 2nd Screen
        • Name: jdbc/MyDataSource
        • JNDI Name: jdbc/MyDataSource
        • Component Managed Auth Alias: user-auth
        • Container managed auth alias: user-auth
      • 3rd Screen
        • Port number: <oracle-port> note: default port is 1521
        • URL:jdbc:oracle:thin:@<db-host-name>:<port>:<schema-name>
6. Completed

Useful commands:

Check out the version of installed WAS in Solaris:

$[WAS Installed location]/bin/versionInfo.sh

No comments: