All Examples 

package examples.jdbc.oracle

• exsql
• longvarchar
• login
• records
• simpleselect
• simplesql
• spcursors
• storedprocs
• t3spcursors
• 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.

• t3spcursors shows how to use the WebLogic extension to JDBC that supports binding an Oracle cursor to an output parameter in a multitier environment, using WebLogic JDBC with jdbcKona/Oracle. It uses the file spcursors.sql that is included in this directory.

• 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.

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 jdbcKona/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 . . .