11 Shared Pool for Sharded Databases

This chapter describes UCP Shared Pool for sharded database in the following sections:

• Overview of UCP Shared Pool for Database Sharding

• About Handing Connection Requests for a Sharded Database

• Sharding Data Source for Transparent Access to Sharded Databases

• Middle-Tier Routing Using UCP

• UCP APIs for Database Sharding Support

• UCP APIs for Middle-Tier Routing Support

• UCP Sharding Example

• Middle-Tier Routing with UCP Example

Sharding Data Source for Transparent Access to Sharded Databases

Oracle Database Release 21c introduces a new JDBC data source that enables Java connectivity to a sharded database without the need for an application to furnish a sharding key.

If you use the sharding data source, then you do not have to identify and build the sharding key and the super sharding key to establish a connection to the sharded database. This data source scales out to sharded databases transparently if you set the connection property oracle.jdbc.useShardingDriverConnection to true.

See Also:

Overview of the Sharding Data Source