Using connection properties

You can use connection properties to customize the driver for your environment. You can use these connection properties with either the JDBC DriverManager or a JDBC data source. For a DriverManager connection, a property is expressed as a key value pair and takes the form property=value. For a data source connection, a property is expressed as a JDBC method and takes the form setProperty(value). For a complete list of supported properties, refer to "Connection Property Descriptions" in the Progress DataDirect for JDBC for Oracle Driver User's Guide

The following table summarizes the minimum connection properties required to connect to a database. For a list of properties that affect performance, see "Tuning for Performance."

Note: All connection property names are case-insensitive. For example, Password is the same as password. Required properties are noted as such.

Table 1. Required properties
Property	Characteristic
PortNumber	Specifies the TCP port of the primary database server that is listening for connections to the database. The default is 1521.
ServerName	Specifies the name or IP address of the server to which you want to connect.
ServiceName	Database service name that specifies the database used for the connection. This property is mutually exclusive with the SID property.
SID	Oracle System Identifier that refers to the instance of the Oracle database running on the server. This property is mutually exclusive with the ServiceName property. The default is ORCL.