io.helidon.data.sql.datasource.ucp.UcpDataSourceConfig

Description

UCP specific configuration for javax.sql.DataSource

Configuration options

Key	Type	Description
`connection-repurpose-threshold`	`Integer`	Sets the connection repurpose threshold for the pool
`min-idle`	`Integer`	Sets the minimum number of idle connections
`role-name`	`String`	Sets the data source role name
`ons-configuration`	`String`	Sets the configuration string used for remote ONS subscription
`description`	`String`	Sets the data source description
`connection-harvest-max-count`	`Integer`	Sets the maximum number of connections that may be harvested when the connection harvesting occurs
`connection-factory-class-name`	`String`	Sets the connection factory class name
`connection-harvest-trigger-count`	`Integer`	Sets the number of available connections below which the connection pool's connection harvesting will occur
`query-timeout`	`Integer`	Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds
`max-connection-reuse-count`	`Integer`	Sets the maximum connection reuse count
`read-only-instance-allowed`	`Boolean`	Sets the read-only instance allowed value on the datasource
`server-name`	`String`	Sets the database server name
`timeout-check-interval`	`Integer`	Sets the timeout check interval in seconds
`max-connections-per-shard`	`Integer`	Sets the max number of connections that can be created per shard from this connection pool
`validate-connection-on-borrow`	`Boolean`	Makes the pool validate the connection before returning it to the user by calling the JDBC API `isValid`
`max-idle-time`	`Integer`	Sets the maximum idle time for available connections in the pool in seconds
`max-statements`	`Integer`	Sets the maximum number of statements that may be pooled or cached on a connection
`connection-wait-duration`	`Duration`	Configures how much time a connection request call may wait before it either successfully returns a connection or throws an exception
`property-cycle`	`Integer`	Sets the property cycle in seconds
`connection-validation-timeout`	`Integer`	Sets the connection validation timeout in seconds
`high-cost-connection-reuse-threshold`	`Integer`	Sets the high-cost connection reuse threshold for connection labeling
`fast-connection-failover-enabled`	`Boolean`	Enables Fast Connection Failover (FCF) for the connection pool accessed using this pool-enabled data source
`sharding-mode`	`Boolean`	Change the mode of UCP when UCP is using a Sharded Database
`connection-labeling-high-cost`	`Integer`	Sets the cost value which identifies a connection as "high-cost" for connection labeling
`network-protocol`	`String`	Sets the data source network protocol
`commit-on-connection-return`	`Boolean`	Sets the `boolean` value for the property that controls the behavior of UCP when a connection is released back to the pool with pending uncommitted changes in an active transaction
`min-pool-size`	`Integer`	Sets the minimum number of connections
`initial-pool-size`	`Integer`	Sets the initial pool size
`abandoned-connection-timeout`	`Integer`	Sets the abandoned connection timeout
`seconds-to-trust-idle-connection`	`Integer`	Sets the time to trust an idle connection to skip a validation test in seconds
`xa-data-source`	`Boolean`	Support for distributed transactions
`port-number`	`Integer`	Sets the database port number
`connection-properties`	`Map<String, String>`	Sets the connection properties on the connection factory
`time-to-live-connection-timeout`	`Integer`	Sets the maximum time a connection may remain in-use in seconds
`max-pool-size`	`Integer`	Sets the maximum number of connections
`connection-factory-properties`	`Map<String, String>`	Sets the connection factory properties on the connection factory
`max-connection-reuse-time`	`Long`	Sets the maximum connection reuse time in seconds
`sql-for-validate-connection`	`String`	Sets the SQL statement to validate the database connection
`database-name`	`String`	Sets the database name
`connection-pool-name`	`String`	Sets the connection pool name
`data-source-name`	`String`	Sets the data source name
`inactive-connection-timeout`	`Integer`	Sets the inactive connection timeout
`create-connection-in-borrow-thread`	`Boolean`	Set this flag to `true` to make UCP use the borrowing thread to create new connections

Usages

data.sources.sql.provider.ucp

See the manifest for all available types.

Edit this page or Report an issue