Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# 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` | 5 | 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.
`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.use.oracle.pool` | false | For Oracle database connection, when the property is set to `true`, Oracle connection pool is used to maintain the database connection. When the property is set to `false`, BusinessEvents JDBC connection pool is used to maintain the database connection.
`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 `0` indicates 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.
`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.
`be.dbconcepts.sqlquery.delimiters` | "" | Specifies the delimiter for searching entities like columns, tables, and schemas for a case-sensitive search.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.