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.