Previous Topic: DatabasesNext Topic: MSSQL Server Parameters


Oracle Parameters

Inherit Settings

If checked, values shown reflect the current values of the Domain. At runtime, the values are selected from the Environment (if defined).

Driver Type

Accepts one of the following options:

Thin

The thin driver is a pure Java implementation of Oracle's networking protocol (Net8). Being self-contained, it may be used on any machine with or without Oracle installed, or even distributed with application classes in an applet.

OCI

The "OCI" (type 2) driver consists of Java wrappers to the low-level Oracle call interface (OCI) libraries used by utilities like SQL*Plus to access the database server. The OCI driver offers potentially better performance that the thin driver. It however requires the OCI libraries to be installed on the local machine.

KPRB

The "KPRB" driver is used for Java stored procedures and database JSP's.

Driver

Specifies the Oracle JDBC driver.

Server Host

Specifies the host where the Oracle database is running.

UserName

Specifies the default Oracle database user.

Password

Specifies the password for the default Oracle user.

ServiceID

Specifies the Oracle service ID.

TNS Name

Oracle TNS Names translates a local database alias to all the connectivity information needed to connect to the database. This includes IP address, port, database Service ID or service name, and so on. This information is stored in a file called tnsnames.ora in the Oracle directory.

Maximum Rows

Specifies the maximum rows to retrieve.

Client Encryption

Oracle supports multiple data encryptions for the client (RC4_40, RC4_56, RC4_128, RC4_256, DES40C, DES56C, 3DES112, 3DES168, SSL, AES256, AES192, and AES128). The user should provide one of these values. These values will be set as properties as part of the connection. The encryption levels RC4_128 and RC4_256 are for domestic editions only.

Client Checksum

Specifies checksums supported by Oracle. Refer to your Oracle documentation.