===RowSetDemo===

This applet demonstrates JDBC functionality via an Applet. It also demonstrates the additional Resultset navigation functionality provided by OpenLink's Scrollable Resultset & RowSet Extensions for JDBC on a RowSet by RowSet Basis.

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:

      Local To you:

      http://localhost:8000

      Remote Server:

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

      Note:

      Port "8000" presumes that you provide this value when prompted during your OpenLink Sever components installation.
   
4. Follow the Admin Assistant's Menu tree to the location of the "Sample Applications->JDBC Applet Demos" menu item. The graphic below depicts this process.
    
  Figure: 8.5.5.1. Connection dialog Connection dialog
   
5. Click on the hyperlink that reads "Applet demonstration with OpenLink Software JDBC Scrollable Cursor RowSet Extensions"
   
6. Use the Applet's File->Set Connection URL menu item set a URL pointing to an ODBC or UDBC DSN. 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 your OpenLink Drivers for JDBC. This applet will run with non OpenLink Drivers for JDBC but you will need to obtain URL construction information from the relevant driver vendor.

      The screen shot below depicts the URL construction dialog presented:
      Figure: 8.5.5.1. URL Construction URL Construction
   
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. The screen shot below depicts this process:
      Figure: 8.5.5.1. Querying Querying
   
8. JDBC 1.1 functionality provides Forward-Only as opposed to Bi-Directional Resultset Scrolling, JDBC 2.0 provides Scrollable Result sets but does not provide Bookmarking or Attached RowSets (transient RowSets located in the same process space as the ResultSet). OpenLink's Scrollable Resultset Extensions for JDBC address these issues irrespective of JDBC version. As a result this applet has an additional set of Resultset Navigation buttons when compared to the basic JDBC 2.0 Applet in the prior section, the buttons are: "First","Next", "Prior","Last", "Lock", "Unlock", "Add", "Update", "Get Bookmark", "Set Bookmark", "and Go To" .  The existence of transient RowSets due to Bi-directional Scrollable Result sets (or Cursors) in JDBC 2.0 is more than likely presumed to exist by end-users and developers alike, it is important that you take note of this before embarking upon JDBC 2.0 application development or product selection. Each of the buttons in the Applet demo is explained below so as to assist in the understanding of these matters:
      Table: 8.5.5.1. Scroll Demo Keys Explained Button 	Explanation
      First 	takes you to first RowSet in the Resultset
      Next 	takes you to the next RowSet in the Resultset from your current position
      Prior 	takes you to the previous RowSet in the Resultset from your current position
      Last 	takes you to the last RowSet in the Resultset
      Lock 	locks the current RowSet
      Unlock 	unlocks the current RowSet
      Add 	add a new record to database
      Update 	change current record with the current RowSet of
      Delete 	remove current record from within the current RowSet from the database
      Get Bookmark 	mark current RowSet within Resultset for future revisit
      Set Bookmark 	revisit previous marked RowSet position in current ResultSet
      Go To 	go directly to a specific record number within the current ResultSet
      Refresh 	Reopen current resultset