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:
Remote Server:
http:
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: 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: 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:
Figure: 8.5.5.1.
URL Construction URL Construction
Figure: 8.5.5.1.
Querying Querying
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...