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
Last updated