Bootstrap settings reference

The bootstrap object inside a connection's configuration sets default session settings applied each time the connection opens.

Info

For information on initializing database session settings, see Configure connection initialization settings.

Fields¶

Field	Type	Default	Description
`autocommit`	boolean	`true`	Enable auto-commit for the session
`txnIsolation`	integer	`1`	Transaction isolation level. Learn more
			- 1 - Read uncommitted
			- 2 - Read committed
			- 4 - Repeatable read
			- 8 - Serializable
`defaultCatalog`	string	-	Default database (catalog) to select when the connection opens
`defaultSchema`	string	-	Default schema to select when the connection opens
`query`	array	-	SQL queries to run automatically when the connection opens
`ignoreErrors`	boolean	`false`	Ignore errors in bootstrap queries

Example

{
  "bootstrap": {
    "autocommit": false,
    "txnIsolation": 8
  }
}