WebSphere Configuration Oracle Data source

1, open the console, select the resource-jdbc provider on the left-new, select a driver in the Drop-down list, I want to configure the Oracle connection pool, so select Oracle JDBC DRIVER, and then fill in the name and Classpath in the scene that appears.

2, click Data Source-new, fill in the name and Jndi name. Identified, saved.

3, click the newly created data source, select the J2C Authentication data entry below, the alias is random, the user ID and password are the username and password of the database to be connected respectively.

4, and then select the newly created data source, component managed authentication alias, container-managed authentication alias, respectively, select the J2C data entry

5, and then customizing the properties for the data source, click Custom Attribute-url, urljdbc:oracle:thin:@i server address with JDBC Value: 1521:dbname

6, test the data source connection, OK.

One thing to note is that the classpath that you fill out in the first step must be real, otherwise you can't connect to the database. The default is ${oracle_jdbc_driver_path}/ojdbc14.jar, which can be modified in the environment-manage WebSphere variables.

The above configuration was implemented on was 5.1, and 6.0 should be similar to this one. The configuration method for SQL Server 2000 is similar to this one.