Using BEA WebLogic with the Easysoft JDBC-ODBC Bridge to Access ODBC Data Sources

The Easysoft JDBC-ODBC Bridge allows WebLogic applications to access any ODBC data source as if it were a JDBC data source. The solution 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 which 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 installation directory.

  2. Restart the server by running the file you have just updated:
    ./startExamplesServer.sh
    
  3. Run the WebLogic Administration Console from a browser, using a statement of the form:
    http://server:7001/console
    

    You will need to substitute server with the name of the machine on which you have installed WebLogic.

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

  4. Enter your WebLogic password, if required, and click Sign In to display the WebLogic Administration Console menu page.
  5. Having logged on, click Connection Pools in the JDBC section within Services Configurations.
  6. Click 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://demo.easysoft.com/demo, and Driver Classname to easysoft.sql.jobDriver:

    General configuration settings for a new JDBC Connection Pool entry in the WebLogic Server Console.

  7. Click 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. Click on the Target tab.
  9. Highlight the Server you require from the Available list, click the right arrow button to add it to the Chosen list and then click Apply:

    Target database server in the Chosen list.

    You now need to create a JDBC Data Source:

  10. Click Data Sources on the table of contents.
  11. Click Configure a new JDBC Data Source... to create a Data Source entry for the Easysoft JDBC-ODBC Bridge, setting Name to a data source name of your choice, JNDI Name to a JNDI name of your choice and Pool Name to the name you gave to your created Connection Pool (in this case 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. Click 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. Click on the Target tab, highlight the Server you require from the Available list, click the right arrow button to add it to the Chosen list and then click Apply (this is exactly the same procedure as in steps 8 and 9 above).

The configuration is now complete.

Article Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)