Oracle

Establishing a Connection

Before you Connect

To connect to Oracle, you'll first need to update the appropriate environment variable and ensure it contains a folder location that includes the Oracle OCI Library assemblies.

If appRules is already installed on your computer, a windows PATH variable to [Installation Folder]/appStrategy/appRules/bin/x64 must have been created by the Installer.

If not, create it manually : see here

Connecting to Oracle OCI

The following are the properties for connecting to Oracle. The required properties are identified using the *** characters.

If a connection property value has special characters such as semicolons, single quotes, spaces, etc., then you must quote the value using either single or double quotes.

Server***

The host name or IP of the server hosting the Oracle database.

Port*** The port used to connect to the server hosting the Oracle database.

Service Name*** The service name of the Oracle database.

User***

The Oracle OCI user account used to authenticate.

Password***

The password used to authenticate the user.

Browsable Schemas***

Comma-separated list of schemas to restrict browse-able database object tree.

Datasource Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect.

Connection Life Time

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed.

Max Lob Size

The volume in numbers of bytes or UTF-8 chars which is allowed to query by non-parameterized SELECT query.

Pool Idle Timeout	The allowed idle time for a connection before it is closed.
Pool Max Size	The maximum connections in the pool.
Pool Min Size	The minimum number of connections in the pool.
Pool Wait Time	The max seconds to wait for an available connection.

Other properties (Proxy...) are detailed in section common properties