Package oracle.ucp.jdbc

Class UCPDataSource

java.lang.Object
oracle.ucp.jdbc.UCPDataSource
All Implemented Interfaces:
Wrapper, CommonDataSource, DataSource, org.springframework.beans.factory.InitializingBean
@Deprecated @Configuration @ConfigurationProperties("spring.datasource.ucp") public class UCPDataSource extends Object implements DataSource, org.springframework.beans.factory.InitializingBean
Deprecated.

This decorator of PoolDataSource allows UCP to be configured as the pooled datasource in Spring Boot applications using Autoconfigure.

In order for Spring to use this data source, the following attribute needs to be set: spring.datasource.type=oracle.ucp.jdbc.UCPDataSource

Spring injects both camel-case notation or slash separated. Eg: both maxPoolSize and max-pool-size will update maxPoolSize attribute.

Common attributes with other connection pool implementors:

  • spring.datasource.url
  • spring.datasource.username
  • spring.datasource.password
  • spring.datasource.driver-class-name

Common attribute, to use this bean:

  • spring.datasource.type=oracle.ucp.jdbc.UCPDataSource

Non-optional attribute, specific to UCP:

  • spring.datasource.ucp.connection-factory-class-name

Optional attributes, specific to UCP:

  • spring.datasource.ucp.server-name
  • spring.datasource.ucp.port-number
  • spring.datasource.ucp.database-name
  • spring.datasource.ucp.data-source-name
  • spring.datasource.ucp.description
  • spring.datasource.ucp.network-protocol
  • spring.datasource.ucp.role-name
  • spring.datasource.ucp.validate-connection-on-borrow
  • spring.datasource.ucp.sql-for-validate-connection
  • spring.datasource.ucp.connection-pool-name
  • spring.datasource.ucp.initial-pool-size
  • spring.datasource.ucp.min-pool-size
  • spring.datasource.ucp.max-pool-size
  • spring.datasource.ucp.abandoned-connection-timeout
  • spring.datasource.ucp.time-to-live-connection-timeout
  • spring.datasource.ucp.inactive-connection-timeout
  • spring.datasource.ucp.max-idle-time
  • spring.datasource.ucp.timeout-check-interval
  • spring.datasource.ucp.property-cycle
  • spring.datasource.ucp.max-statements
  • spring.datasource.ucp.connection-wait-timeout
  • spring.datasource.ucp.max-connection-reuse-time
  • spring.datasource.ucp.max-connection-reuse-count
  • spring.datasource.ucp.connection-harvest-trigger-count
  • spring.datasource.ucp.connection-harvest-max-count
  • spring.datasource.ucp.fast-connection-fail-over-enabled
  • spring.datasource.ucp.ons-configuration
  • spring.datasource.ucp.seconds-to-trust-idle-connection
  • spring.datasource.ucp.login-timeout
  • spring.datasource.ucp.connection-labeling-high-cost
  • spring.datasource.ucp.connection-repurpose-threshold
  • spring.datasource.ucp.high-cost-connection-reuse-threshold
  • spring.datasource.ucp.max-connections-per-shard
  • spring.datasource.ucp.sharding-mode
  • spring.datasource.ucp.connection-validation-timeout

This feature is now deprecated in 23ai, please use spring boot version 2.4 or higher, to use the auto-configure feature in spring boot, use spring.datasource.type=oracle.ucp.jdbc.PoolDataSource and rest of the ucp properties can be set similarly using 'spring.datasource.oracleucp' prefix