This is a demonstration of an applet using OpenLink's JDBC Driver with the OpenLink Scrollable Cursor Extension to the JDBC specification.
When the Web browser has finished loading the Java applet, a window containing the JDBC applet will appear:
When it is running, click on the "Query" button to execute a SQL query against the default connection URL. If successful, you should see the first row of the resultset filling the applet window:
Click on the "Next" button to retrieve the next row, "Prior" to go back a row, "First" to move directly to the first row, and "Last" to move to the last row.
Clicking "Delete" will attempt to delete the row from the database. Clicking on "Refresh" will now retrieve the latest values from the database to refresh the row. However this may or may not be successful dependent on the restrictions place on the resultset by the underlying database.
"Lock" and "Unlock" will attempt to perform those operations on the current row, which again may or may not be successful, dependent on the restrictions of the underlying database.
"Add" will attempt to add the contents of the current row as a new row to the relevant tables forming the resultset. "Update" will attempt to update the modified contents of current row to the database. Again, the success of these two operations depends on the restrictions placed on the underlying database.
"Get Bookmark" will attempt to retrieve a bookmark for the current row position, which "Set Bookmark" will attempt to return to.
To move to a particular position in the resultset, enter that position into the edit box next to the "Goto" button and click the "Goto" button.
To pick the connection URL, select "File|Pick Connection URL.." from the menu. A dialog box will appear, enabling you to pick the Server Type, and set initial values for Database, Username and Password. These values all overwrite the current connection URL:
To change the connection URL, select "File|Set Connection URL.." from the menu. A dialog box will appear, enabling you to edit the connection URL:
Please note that due to the applet security restrictions, it is only possible to connect to the same server IP as the Web server.
The Java source for this applet