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