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 Broker2. Start up your Web Browser3. 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: UNKNOWN tag: http://www.w3.org/1999/xhtml:hostname: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 dialog5. 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 Construction7. 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 Querying8. 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