Database Connection Configuration Reference

Configure the database connection for database concepts using the CDD file.

Note: The database concept settings and properties are applicable only for JDBC stores.

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.
  • If set to 0, the engine does not attempt to reconnect.
  • If set to -1, the engine retries with no limit.
  • If set to an integer greater than 0, the engine tries to connect for the specified number of times.

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:
  • true - All connections are checked in DBConcepts and if any connection fails then the connection pool is refreshed.
  • false - All connections are not checked in DBConcepts, and only if the test connection fails then the connection pool is refreshed.
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 0 which means there is no limit to the number of records that can be returned by an SQL query of database concepts.

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.