Database Connection Configuration Reference
Configure the database connection for database concepts using the CDD file.
Studio Settings
Add the project paths to all JDBC resources used for database concepts, and configure other properties as desired. See Configuring the Database Connection for the procedure.
Property | Default Value | Description |
---|---|---|
Check Interval | 60
|
The time interval (in seconds) between two consecutive checks of database connection status. |
Inactivity Timeout | 0
|
The time period (in seconds) after which the database connection in the pool closes unused connections. |
Initial Size | 5
|
The initial pool size in number of connections. |
Max Size | 5
|
Maximum number of connections allowed. |
Min Size | 5
|
Minimum number of connections to retain. |
Property Check Interval | 900
|
After this interval (in seconds), all connections which are already marked as inactive are flushed to the pool. |
Retry Count | -1
|
Specifies behavior for reconnecting to the database.
When a connection is lost or stale, it cannot be recovered, and engine restart would be required. |
Wait Timeout | 1
|
The maximum time (in seconds) to wait to retrieve a connection from the connection pool. |
Database URIs | Required. Add the project path of all JDBC shared resources used for database concepts in the project. For example:
/SharedResources/DBConceptsConnection.sharedjdbc |
Properties
These configuration properties can be added in the CDD file. For more details on the CDD configuration see TIBCO BusinessEvents Configuration Guide.
Property | Default Value | Description |
---|---|---|
be.dbconcepts.connections.checkall | false | Specifies whether
TIBCO BusinessEvents checks all connections for validity in DBConcepts. The values are:
|
be.dbconcepts.connections.logall | Specifies whether DBPool check operations are logged when logLevel is set to debug |
|
be.dbconcepts.connection.check.interval | Specifies the intervals in which the TIBCO BusinessEvents agent checks connections in the DB connection pool of DBConcepts. The agent only checks the connections that not in use currently. | |
be.dbconcepts.connections.checkratio |
Specify the number of connections that the TIBCO BusinessEvents agent checks in each interval. Specify a number such that the following equation gives you the percentage of connections to check: percent connections to check = (1/number)*100 For example, to check all connections on each interval set the property to 1. To check 25% of the connections set it to 4. Default value: 5 |
|
be.dbconcepts.oracle.pool.v12 | false | Specifies whether you can use the Oracle 12 driver for the new pool. Set this property to
true to use the Oracle 12 driver.
Note: For JDBC, copy ojdbc7.jar and ucp.jar+ to the BE_HOME\lib\ext\tpcl. |
be.dbconcepts.templates.jdbc.resultset.maxRows | 0 | Specifies the maximum number of records (result set) that can be returned by an SQL query of database concepts.
The default value is
|
be.dbconcepts.query.sqltimeout | 0 | Specifies the timeout value for database queries in seconds.
The default value is 0. |
be.dbconcepts.cursor.closeQuery.closeConnection | true | Specifies whether the database transactions are auto committed when Database.closeQuery() function is executed. Set this property to
false to prevent autocommit.
|
be.dbconcepts.quote.column.names | true | Specifies whether a case-sensitive search is enabled for names of entities like columns, tables, and schemas. The default value is
true .
|
be.dbconcepts.sqlquery.delimiters | "" | Specifies the delimiter for searching entities like columns, tables, and schemas for a case-sensitive search. |