Skip to content

Home

Introduction

Development

Overview

IDEs

Services

Service manager

API Explorer

Database connection pool properties

Properties are used to described database connections. TORO Integrate, which uses Bitronix underneath, will use these properties when connecting to the target database. You can learn more about these properties in Bitronix's documentation.

Database properties

Field Name Required Default Value Description
Name true null Name of the database connection.
Use XA false false Whether or not to enable XA transactions.
Driver Class true null The JDBC driver for the database you are connecting to.
URL true null The URL of the JDBC database you are connecting to.
Username true null Username to use when connecting to the database.
Password false null Password to use when connecting to the database.
Acquire Increment false 1 Controls how many connections are filled into the pool when the pool is empty but the maxPoolSize has not been reached.
Acquisition Interval false 1 Controls how long (in seconds) the pool waits between attempts to create new connections.
Acquisition Timeout false 30 Controls how long (in seconds) to wait for a pool connection request to succeed before being aborted (and throwing an exception).
Allow Local Transactions false true Whether or not you want to be able to run SQL statements outside of XA transactions scope.
Apply XA Transaction Timeout false false Whether or not the transaction timeout will be passed to the resource via XAResource#setTransactionTimeout(int).
Enlist to XA Automatically false true Controls whether connections from the PoolingDataSource are automatically enlisted or delisted in XA transactions.
Defer Connection Release false false Set this parameter to false if the vendor's XADataSource implementation supports the interleaving of transactions.
Enable JDBC4 Connection Test false false If your JDBC driver supports JDBC4, this method of testing the connection is likely much more efficient than using the testQuery parameter.
Ignore Recovery Failures false false Determines whether recovery errors should be ignored or not. This is useful in development environments.
Maximum Idle Time false 600 When the pool is above the minPoolSize, this parameter controls how long (in seconds) an idle connection will stay in the pool before being retired.
Isolation Level false READ_COMMITED Sets the default isolation level. All of the four standard values (READ_COMMITTED, READ_UNCOMMITTED, REPEATABLE_READ and SERIALIZABLE) are supported.
Minimum Pool Size false 1 The minimum number of active connections the pool will try to keep.
Maximum Pool Size false 5 The maximum number of active connections allowed in the pool.
Prepared Statements Cache Size false 100 Controls how many prepared statements are cached (per connection) by Bitronix.
Share Transaction Connections false true Determines whether or not connections share the same thread context.
Test Query false null In contrast with enableJdbc4ConnectionTest, this parameter is sent to the database to determine whether or not a connection is still usable.
Two-Phase Commit Order Position false 0 Controls the position of this resource during the 2PC protocol execution; used to guarantee the order of commits.
Unique Name false "Name" Required for crash recovery; uses "Name" if empty.
Use Transaction Manager Join false true Set this parameter to false if the vendor's XADataSource implementation does not implement XAResource#isSameRM(...) properly.

Configuration

Follow the steps below to edit the properties of a database connection pool:

Updating an existing database connection

Updating an existing database connection

  1. Stop the database connection pool you want to configure.
  2. Right click on the database connection pool and click Configure from the context menu.
  3. Edit the properties of the database connection pool in the displayed editor.
  4. To save your changes:

    • If you're using Coder Cloud, click on the floppy disk button.
    • If you're using Coder Studio, press .

Updating an existing database connection

  1. Stop the database connection pool you want to configure.
  2. Click the Edit button under the Action column of the database connection pool you want to configure.
  3. Edit the properties of the database connection pool in the displayed form. Click on the Advanced checkbox if you also want to see and edit advanced properties.
  4. To save your changes, click on the Update button.