Oracle Tablespace Configuration

 

Create the SAMPLE Tablespace

Create the Sample DataSource Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Create the Oracle JDBC Driver, if it does not already exist:
  3. Expand Resources and click JDBC Drivers.
  4. Click New.
  5. From the drop-down menu, click Oracle JDBC Driver.
  6. Click Next.
  7. Use the following values in the Properties window. You can leave the remaining values blank:

    Server Class Path: Oracle JDBC driver class location. (See details below)
    Name: OracleJdbcDriver
    Description: Oracle JDBC Driver
    Implementation Class: oracle.jdbc.pool.OracleConnectionPoolDataSource

    Follow these instructions when specifying the location of the JAR file containing the Oracle JDBC driver classes for your platform:
  8. Click OK.
  9. Save your configuration
  10. Create the Sample DataSource Object:

Remove the Samples IDB DataSource Object

  1. Point your browser to the WebSphere Application Server Administrative Console:
    http://localhost:9090/admin.
  2. Expand Resources > JDBC Drivers > idbJdbcDriver and click Data Sources
  3. Check the box next to Samples IDB DataSource and click Delete.
  4. Save your configuration.
  5. Shut down and restart the WebSphere Application Server.

Run the Sample Tablespace

Run the servlet to create and configure the tables in the SAMPLE tablespace.