Skip to content

Toro Cloud Dev Center


Relational (SQL) database connection properties

Properties are used to describe Relational (SQL) database connections. Martini, which uses Bitronix for transaction management, will use these properties when connecting to the target database. You can learn more about these properties by referring to Bitronix's documentation.

Database properties

Field Name Required Default Value Description
Name true null Name of the database connection.
Auto Start false true Whether the database connection should start when Martini starts up.
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).
Login Timeout false 0 Controls how long (in seconds) to wait for a successful authentication against the database server. A value of zero specifies that the timeout is the default system timeout if there is one; otherwise, it assumes that there is no timeout.
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 60 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_COMMITTED 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 0 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 0 Controls how many prepared statements are cached (per connection) by Bitronix.
Share Transaction Connections false false Determines whether or not connections share the same thread context.
Test Query false null In contrast with enableJdbc4ConnectionTest, this query 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:

Updating an existing database connection

Updating an existing database connection

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