The Oracle Connection can be configured with global settings as well as with DID as with DID Module specific settings. The following listing describes the available settings.
The following settings are available:
Setting |
Default |
Description |
ConnStr |
Empty |
One string containing user-id, password and server. The format is "userid/password@server". All three parts are optional. Forms like "userid/password" or "userid/password@server" or "@server" are most common. In the latter case, ITP will ask the user to enter user-id and password. |
CacheStats |
Y |
The ITP Oracle Connection caches SQL statements intelligently for performance reasons. There are currently no known reasons to set the setting to N. |
DisconnectAfterModel |
N |
Normally the connection to the database will stay open until the DataManager is stopped. If you set DisconnectAfterModel to Y, ITP closes the connection to the database after every model. |
UserId |
Empty |
The userid for the database login. |
Password |
Empty |
The password for the database login. |
Server |
Empty |
Oracle database to connect to. |
We advise to use the UserId, Password and Server setting to specify a userid, password and server and not the Connstr setting. If a Connstr setting has been specified, it will be split into userid, password and server (if provided). Any available values specified at UserId, Password or Server will overwrite these values.