Contents

Preface
Purpose of This Document
How to Use This Document
Related Documentation
Contact Information

Using the jdbcKona Drivers
Platforms Supported by the jdbcKona Drivers
Adding the jdbcKona JAR File to Your CLASSPATH
jdbcKona/Oracle Shared Libraries and Dynamic Link Libraries
Requirements for Making a Connection to a Database Management System (DBMS)
Support for JDBC Extended SQL
The JDBC API, with WebLogic Extensions
Implementing a WLE Java Application Using the jdbcKona Drivers
  Importing Packages
  Setting Properties for Connecting to the DBMS
  Connecting to the DBMS
  Making a Simple SQL Query
  Inserting, Updating, and Deleting Records
  Creating and Using Stored Procedures and Functions
  Disconnecting and Closing Objects
  Code Example

Using the jdbcKona/Oracle Driver
Data Type Mapping
Connecting the jdbcKona/Oracle Driver to an Oracle DBMS
  Method 1
  Method 2
  Other Properties You Can Set for the jdbcKona/Oracle Driver
  General Notes
Waiting for Oracle DBMS Resources
Autocommit
Using Oracle Blobs
Support for Oracle Array Fetches
Using Stored Procedures
  Syntax for Stored Procedures in the jdbcKona/Oracle Driver
  Binding a Parameter to an Oracle Cursor
  Using CallableStatement
DatabaseMetaData Methods
jdbcKona/Oracle and the Oracle NUMBER Column

Using the jdbcKona/MSSQLServer4 Driver
Connecting to an SQL Server with the jdbcKona/MSSQLServer4 Driver
  Method 1
  Method 2
  Method 3
Setting Properties for Microsoft SQL
Server 7
Using the jdbcKona/MSSQLServer4 Driver in Java Development Environments
JDBC Extensions and Limitations
  Support for JDBC Extended SQL
  cursorName Method Not Supported
  java.sql.TimeStamp Limitations
  Querying Metadata
  Changing autoCommit Mode
  Statement.executeWriteText() Methods Not Supported
  Sharing a Connection Object in Multithreaded Applications
  EXECUTE Keyword with Stored Procedures

Extensions to the JDBC API
Class CallableStatement
  weblogic.jdbc.oci.CallableStatement.getResultSet
Class Connection
  weblogic.jdbc.oci.Connection.waitOnResources
Class weblogic.jdbc.oci.Statement
  weblogic.jdbc.oci.Statement.fetchsize
  weblogic.jdbc.oci.Statement.parse