Accessing ODBC data sources from WebLogic

The Easysoft JDBC-ODBC Bridge allows WebLogic applications to access any ODBC data source as if it were a JDBC data source. The Bridge provides Unicode support and is fully compatible with WebLogic connection pooling.

These instructions assume that you have installed the server component of the Easysoft JDBC-ODBC Bridge and completed the Getting Started guide: successfully accessing an ODBC data source that you can now reference in your WebLogic configuration.

To configure the WebLogic examplesServer server to work with the Easysoft JDBC-ODBC Bridge:

  1. Add EJOB.jar (specifying the full path name) to the CLASSPATH environment variable in the WebLogic server startup script: 
    startExamplesServer.sh

    located in:

    bea/weblogic700/samples/server/config/examples

    within your WebLogic installation directory.

  2. Restart the server by running the file you've just updated: 
    ./startExamplesServer.sh
  3. Run the WebLogic Administration Console from a browser: 
    http://server:7001/console

    Substitute server with the name of the WebLogic machine.

    Note that 7001 is the default WebLogic port number. The port may be different, depending on the options you chose during installation.

  4. Enter your WebLogic password, if required, and choose Sign In to display the WebLogic Administration Console menu page.
  5. Having logged on, choose Connection Pools in the JDBC section within Services Configurations.
  6. Choose Configure a new JDBC Connection Pool... to create a Connection Pool entry for the Easysoft JDBC-ODBC Bridge, setting URL to a valid Easysoft JDBC-ODBC Bridge URL, such as jdbc:easysoft://myserver/mydsn, and Driver Classname to easysoft.sql.jobDriver: General configuration settings for a new JDBC Connection Pool entry in the WebLogic Server Console.
  7. Choose Create and then Apply to add your new Connection Pool entry.

    You now need to attach a target database server to your Connection Pool:

  8. Choose the Target tab.
  9. Highlight the server you want from the Available list, choose the right arrow button to add it to the Chosen list, and then choose Apply:

    Target database server in the Chosen list.

    You now need to create a JDBC Data Source:

  10. Choose Data Sources on the table of contents.
  11. Choose Configure a new JDBC Data Source... to create a Data Source entry for the Easysoft JDBC-ODBC Bridge. Set Name to a data source name of your choice, JNDI Name to a JNDI name of your choice, and Pool Name to your Connection Pool name (for this tutorial the name is JOB_test): Example settings for a new JDBC Data Source in the WebLogic Server Console. The Name box value is JOB_datasource_test, the JNDI Name is JNDIpath_test, the Pool Name is JOB_test.
  12. Choose Create and then Apply to add your new Data Source entry.

    You now need to attach a target database server to your Data Source.

  13. Choose the Target tab, highlight the Server you require from the Available list, choose the right arrow button to add it to the Chosen list, and then choose Apply.

The configuration is now complete.