Sharding Data Source for Transparent Access to Sharded Databases

13.3 Sharding Data Source for Transparent Access to Sharded Databases

Oracle Database Release 21c introduced 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.