OEM1DB on decisionsdb: sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Mon Oct 22 12:09:26 2001

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> @RunJServerApplication.sql
DOC> ** +----------------------------------------------+
DOC> ** | EXAMPLE: #1                                  |
DOC> ** | -------------------------------------------- |
DOC> ** | The following example will create a sample   |
DOC> ** | table, populate it with values, query the    |
DOC> ** | sample table using both "normal" and         |
DOC> ** | "scrollable" cursors, delete all sample data |
DOC> ** | and finally drop the table.                  |
DOC> ** +----------------------------------------------+
DOC>*/
Connected.

Call completed.

+-------------------------------+
| METHOD: createTables          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Creating Statement...
*** -> Created Table: jserver_demo_table ...

Call completed.

+-------------------------------+
| METHOD: insertValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Prepare Statement...
*** -> Binding Variables...
*** ->   RESULTS            -> 1 row created.
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: insertValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Prepare Statement...
*** -> Binding Variables...
*** ->   RESULTS            -> 1 row created.
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: insertValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Prepare Statement...
*** -> Binding Variables...
*** ->   RESULTS            -> 1 row created.
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: insertValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Prepare Statement...
*** -> Binding Variables...
*** ->   RESULTS            -> 1 row created.
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: insertValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Prepare Statement...
*** -> Binding Variables...
*** ->   RESULTS            -> 1 row created.
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: queryForward          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Executing Forward (NORMAL) Query...
*** ->   USING DEFAULTS:
*** ->   - (P1) ResultSet.TYPE_FORWARD_ONLY
*** ->   - (P2) ResultSet.CONCUR_READ_ONLY
*** -> Opening ResultsSet...
*** ->   RESULTS            -> [R1] 100 - James Smith - <null>
*** ->   RESULTS            -> [R2] 101 - Amy Miller - <null>
*** ->   RESULTS            -> [R3] 102 - Andy Phillips - <null>
*** ->   RESULTS            -> [R4] 103 - Jimmy Black - <null>
*** ->   RESULTS            -> [R5] 104 - Jane Dee - <null>
*** -> Closing ResultSet...
*** -> Closing Statement...

Call completed.

+-------------------------------+
| METHOD: queryReverse          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Executing Forward (SCROLLABLE) Query...
*** ->   USING DEFAULTS:
*** ->   - (P1) ResultSet.TYPE_SCROLL_INSENSITIVE
*** ->   - (P2) ResultSet.CONCUR_READ_ONLY
*** -> Opening ResultsSet...
*** ->
*** -> NOTE:
*** -> --------------------------------------------------------------
*** -> Got results. The ResultPointer Pointer is before the first row.
*** -> Position ResultSet Pointer after the last row.
*** -> --------------------------------------------------------------
*** ->   RESULTS            -> [R5] 104 - Jane Dee - <null>
*** ->   RESULTS            -> [R4] 103 - Jimmy Black - <null>
*** ->   RESULTS            -> [R3] 102 - Andy Phillips - <null>
*** ->   RESULTS            -> [R2] 101 - Amy Miller - <null>
*** ->   RESULTS            -> [R1] 100 - James Smith - <null>
*** -> Closing ResultSet...
*** -> Closing Statement...

Call completed.

+-------------------------------+
| METHOD: deleteValues          |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Creating Statement...
*** ->   RESULTS            -> 5 rows deleted.
*** -> Closing Statement...
*** -> Commiting Transaction...

Call completed.

+-------------------------------+
| METHOD: dropObject            |
+-------------------------------+
*** -> Connecting to        -> jdbc:default:connection:
*** -> Connected as URL     -> jdbc:default:connection:
*** -> Turning Off AutoCommit...
*** -> Creating Statement...
*** -> Drop TABLE JSERVER_DEMO_TABLE...

Call completed.