JDBC Adapter Properties
The following JDBC adapter properties can be set for a JDBC adapter using the Info*Engine Property Administration JDBC adapter form. The properties are listed alphabetically by the JDBC adapter form label, followed by the property name in parenthesis:
Database Driver Class
drivers
The name of the JDBC driver class. This is specific to the database to which the adapter connects. For example, oracle.jdbc.driver.OracleDriver is the driver class for the Oracle Thin Driver. For more information, consult your driver manual.
Database Supports Auto Commit
autoCommitSupported
Identifies whether the underlying database supports the auto-commit facility. Specify true or false.
|
|
If Database Supports Auto Commit is set to false and you are using an Oracle database type, the property would be reset to true internally by the software. However, for other database types, it is your responsibility to provide valid and consistent values for Database Supports Auto Commit and Use Database Auto Commit.
|
Database Type
databaseType
The type of database to which the adapter connects.
Database URL
url
The JDBC URL used to establish the connection. For example, the URL for an Oracle Thin Driver could be in the following format:
jdbc:oracle:thin:@hostname:1521:databaseName
|
|
If you are using Oracle with Single Client Access Name (SCAN), the URL would be in the following format:
jdbc:oracle:thin:@hostname:1521/databaseName
|
Database User
dbuser
The default user who can connect to the database.
Maximum Cache Size
maxContextCacheSize
The maximum number of connections to cache. The default value is 10. Connection pooling is always active.
Maximum Context Age
maxContextAge
The maximum time, in seconds, a connection stays active if not used. The default is 60.
Maximum Query Size
maxQuerySize
The maximum number of rows returned from a database query. The default value is 2000. The JDBC drivers silently drop anything beyond the maximum.
Maximum Thread Count
socketAccess.maxThreadCount
The maximum number of concurrent threads used by the JDBC adapter. The default value is 5. Setting this value higher allows more concurrent connections, but also requires more resources (memory and CPU cycles).
Password
passwd
The default password to use when making the connection to the database.
Result Set Scrolling Capability
resultSetScrollingCapability
The scrolling capability for result sets that are generated when executing SQL queries.
◦ Default
◦ TYPE FORWARD ONLY—The cursor can move in the forward direction only, thereby rendering the result sets unscrollable. For most databases, such a setting is redundant since the default behavior itself provides for result sets that are unscrollable.
Secret
secret.text
A string used to sign and validate requests sent to the adapter.
Secret 2
secret.text2
Another string used to sign and validate requests sent to the adapter. This property generates a more comprehensive request signature, and can be used instead of or in addition to the Secret property.
|
|
For more information about validating requests, see the following resources:
|
Secret Algorithm
secret.algorithm
The algorithm used to encrypt secrets. Valid values for this property are SHA-1 and MD5.
Use Database Auto Commit
autoCommit
Specifies whether the auto-commit facility provided by the underlying database should be used. Select true or false.
◦ The Database Supports Auto Commit property must be set to true before the auto-commit facility is used.
◦ If Database Supports Auto Commit is false, then the value you enter here is disregarded. However, the changes caused by the execution of SQL statements would be explicitly committed.
|
|
If Database Supports Auto Commit is set to false and you are using an Oracle database type, the property would be reset to true internally by the software. However, for other database types, it is your responsibility to provide valid and consistent values for Database Supports Auto Commit and Use Database Auto Commit.
|
