User guide

Chapter 2

Oracle JDBC for Rdb

There are two types of Oracle JDBC for Rdb drivers:

 Oracle JDBC for Rdb native driver

 Oracle JDBC for Rdb thin driver

2.1 Oracle JDBC for Rdb Native Driver

The Oracle JDBC for Rdb native driver is a Type II driver intended for use with client-

server Java applications.

The native driver, written in a combination of Java and C, converts JDBC invocations to

calls to SQLMOD modules, using native methods to call C-entry points.

When you use the native driver, the driver connects directly to the Oracle Rdb database

system using SQLMOD. If you are not using Rdb Remote Access then there are no

network connections involved. This means that the native driver is potentially the fastest

JDBC access method available within the Oracle JDBC for Rdb drivers.

Because the driver uses SQLMOD libraries to carry out Oracle Rdb access, the driver can

only be used on a client machine if

Oracle Rdb Client libraries are also available on that same machine. In addition, it is

necessary for the driver to dynamically load a shared image to use with its Java JNI

interface. Thus this driver is not suitable for use with applications that require Java applets.

2.1.1 Oracle Rdb Database URL Specification Used with the Oracle

JDBC for Rdb native driver

When you use the JDBC DriverManager to connect to an Oracle Rdb database using the

native driver the following connection URL format should be used:

Format

jdbc:RdbNative:<database_specification><connect_switches>

Elements

The format elements are described in Table 2–1 RdbNative Format Elements