• Topic
  • Discussion
  • UdaWikiWeb.RowSetDemoApplet(Last) -- Owiki? , 2016-08-19 15:00:53 Edit owiki 2016-08-19 15:00:53

    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: :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


    Referenced by...