All Examples
package examples.jdbc.oracle
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
- Set up your development shell as described in Setting up your environment.
- 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.
- Compile the examples using the instructions for each example. (See the links at the top of this page.)
- 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.