JDBCTransaction Sample Applet


This sample shows how to use a JDBCTransaction object and a Query object.

Here are the instructions to use the sample:

1) Choose a JDBC Driver.  If the JDBC Driver you are using is not in the 
   list of JDBC Drivers, click on others and specify the "URL prefix" and 
   the "driver class name".
2) Enter the URL of the data source.  (When the actual connection occurs, 
   the URL prefix will be added in front of this URL as the actual URL 
   supplied to the "JDBCTransaction.connect" method.)
3) Enter the UserID and Password as required.
4) Click on the "Connect Transaction" button. Make sure the "Status" text 
   field says the operation is successful.
5) Enter the table name and columns to be used in the SQL statement.
6) Click on the "Open Query" button.  Make sure the "Status" text field 
   says the operation is successful.
7) If the query is opened successfully, the first ten rows are shown in 
   the "Result Set" list box.  Click on the "More Results" button to get 
   the next ten rows and so on.

Notes:

1) You need to set up the classpath to tell where to find the class files
   of the JDBC drivers (except for the Sybase jdbcDirect driver, whose
   class files are in the classpath by default).  To add classpaths,
   bring up the Targets windows in Starbuck. Expand "Default Options", 
   and bring up the property sheet of "Java Target".  Click on the 
   "Classpath" tab.  Add the necessary paths or zip files for the
   particular JDBC drivers.
2) You cannot use the JDBC-ODBC bridge driver together with the Microsoft
   interpreter.  To use the Sun VM, open the Targets window in Starbuck.
   Choose the menu item File/Run_Options. Click on "Use Sun's Java 
   interpreter".