JDBC Properties
This section describes custom engine properties that can be set for resources in the JDBC palette.
Engine.Database.TestStatement.<name>
When a SQL error occurs during statement execution, TIBCO ActiveMatrix BusinessWorks executes a test SQL statement to determine if the error is caused by a bad connection. If the error is due to a bad connection, the statement can be re-executed using a different connection in the connection pool.
This property allows you to specify a test SQL statement. Specify the database name in the <
name
>
portion of the property and set the value of the property to a valid SQL statement.
Engine.DBConnection.idleTimeout
Normally, connections in the database connection pool close after a period of time when they are idle. This property specifies the time (in minutes) to allow database connections to remain idle before closing them. The default timeout for database connections is 5 minutes, but you can set this property to the amount of time you would like to keep database connections open.
Config.JDBC.Connection.SetLoginTimeout
Time (in seconds) to wait for a successful database connection. Only JDBC drivers that support connection timeouts can use this property. If the JDBC driver does not support connection timeouts, the value of this field is ignored. Most JDBC drivers should support connection timeouts. The value of this property overrides any value set for connection timeouts in the Configuration tab of the JDBC Connection resource.