WebSphere 5 Data Sources Configuration

The following configuration works only with i-net SEROPTO or i-net ORANXO.

1. Start the “Administrative Console” of WebSphere 5 with the URL: "http://ServerName:9090/admin".
2. Open the node “Resources” and select “JDBC-Providers” in the tree on the left side.
3. Select “Server” and click “Apply” in the “Scope” section if “Server” is not selected already.
4. Click on the “New” button to create a new JDBC provider.
   
5. Select “User-defined JDBC Provider” in the choice “JDBC Providers” under “General Properties” and click “OK”.
   
6. Enter the display name for this JDBC driver (e.g. i-netOracleDriver) in the field “Name”.
7. Enter the path of the driver jar file (e.g. /opt/Seropto.jar or /opt/Oranxo.jar) in the field “Classpath”.
8. Enter the data source class name of this driver in the field “Implementation Classname”. You can use
   • com.inet.ora.PDataSource - for normal connections with local transactions
   • com.inet.ora.XDataSource - for distributed transactions (XA transactions). Distributed transactions are slower than local transactions, even if only one server is invoked.
     
9. Click on “OK” and the new JDBC provider (driver) has been created.
10. Now select your new JDBC driver and select the data source version in “Additional Properties” to create a data source.
    • “WebSphere 5 Data Source 4” - A WebSphere 4.x data source for EJB 1.x and servlets below 2.3
    • “WebSphere 5 Data Source 5” - A WebSphere 5 data source for EJB 2.0 and servlets 2.3 and above