Oracle
Last updated
Last updated
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
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.
Other properties (Proxy...) are detailed in section common properties
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.
