JDBCDemo Applet

This applet demonstrates basic JDBC functionality.

Utilization Steps

1. Start the OpenLink Request Broker
   
2. Start up your Web Browser
   
3. Enter one of the following URLs into your browser depending on the location of your OpenLink Request Broker or HTTP-based OpenLink ODBC Administrator Note: Port "8000" presumes that you took the defaults when installing the UDA components.
   
   • Local To you:
     
     

     
     http://localhost:8000/
     

     
     
   • Remote Server:
     
     

     
     http://<hostname or IP address of remote server>:8000/
     

     
     
4. Drill down to Sample Applications -> JDBC Applet Demos --
   
   
   
   
   
   
5. Click on Applet demonstration with OpenLink Software JDBC Driver.
   
6. Use the Applet's File -> Set Connection URL menu item set a JDBC URL.
   
   • If uncertain follows the instructions laid out in the section covering OpenLink JDBC URL formats which shows you how to construct Type 1, 2, and 3 URL formats for our JDBC Drivers. This applet will run with third-party JDBC Drivers, but you will need to obtain URL construction information from the relevant driver vendor.
     
   • The line below depicts the URL construction dialog presented:
     
     

     
     jdbc:openlink://localhost/DSN=WebJDBCDemo
     

     
     
7. Enter a valid SQL statement for the back end database that you are connecting to via JDBC and then click on the "Query" button --
   
   
   
   
   
   
8. Basic JDBC 1.1 functionality provides Forward-Only (as opposed to Bi-Directional) record Scrolling; this is why the basic JDBC applet only has a "Next" button. When you click on the "Next" button you are moved to the next record in your JDBC resultset. Unfortunately, you have to hit the "Query" button again and re-start Forward-Only navigation through the result set if you need to see any records previous to your current position. The examples that follow show how newer release of JDBC (version 2.0 and later) address the Bi-Directional Scrolling Limitation demonstrated by this Applet.