    All Examples

# package examples.jdbc.oracle

##

- exsql
- longvarchar
- login
- records
- simpleselect
- simplesql
- spcursors
- storedprocs
- waiton

# about this package

This package contains several standalone examples that can be run independently. Each illustrates a particular JDBC-related task:

- `exsql` shows how to use Extended SQL.

- `longvarchar` shows how to insert and retrieve data from Oracle long raw columns.

- login demonstrates three different ways to connect to a database, including setting explicit properties for connection in the code, using command-line arguments, and embedding properties for connection in a URL.

- `records` illustrates inserting and updates records using a JDBC PreparedStatement.

- `simpleselect` shows how to select data and database metadata, using a Statement, a ResultSet, and a ResultSetMetaData.

- `simplesql` illustrates how to drop and create tables and add and delete rows using a Statement and standard SQL.

- `spcursors` illustrates how to use the WebLogic extension to JDBC that supports binding an Oracle cursor to an output parameter. It uses the file `spcursors.sql` that is included in this directory.

- `storedprocs` shows how to create and execute stored procedures and get results.

- `waiton` demonstrates how the WebLogic extension to JDBC `Connection.waitOnResources()` can be used to return control to the program when the current operation would otherwise wait (in this case indefinitely) for locked DBMS resources. This example requires that you use the Oracle 7 API client libraries.

# how to use this package

1. Set up your development shell as described in Setting up your environment.

2. Change connection parameters to correspond to your Oracle configuration. If you need more help, check the section on connecting to a database in the Developers Guide, Using WebLogic jDriver for Oracle.

3. Compile the examples using the instructions for each example. (See the links at the top of this page.)

4. Run the examples using the instructions for each example. (See the links at the top of this page.)

# there's more . . .

Read more about using this JDBC driver in the Developers Guide for WebLogic jDriver for Oracle, Using WebLogic jDriver for Oracle. More information about WebLogic JDBC is in its Developers Guide, Using WebLogic JDBC.