Module java.sql
Package javax.sql

Interface PooledConnectionBuilder


  • public interface PooledConnectionBuilder
    A builder created from a ConnectionPoolDataSource object, used to establish a connection to the database that the data source object represents. The connection properties that were specified for the data source are used as the default values by the PooledConnectionBuilder.

    The following example illustrates the use of PooledConnectionBuilder to create a XAConnection:

    
         ConnectionPoolDataSource ds = new MyConnectionPoolDataSource();
         ShardingKey superShardingKey = ds.createShardingKeyBuilder()
                               .subkey("EASTERN_REGION", JDBCType.VARCHAR)
                               .build();
         ShardingKey shardingKey = ds.createShardingKeyBuilder()
                               .subkey("PITTSBURGH_BRANCH", JDBCType.VARCHAR)
                               .build();
         PooledConnection con = ds.createPooledConnectionBuilder()
                           .user("rafa")
                           .password("tennis")
                           .setShardingKey(shardingKey)
                           .setSuperShardingKey(superShardingKey)
                           .build();
     

    Since:
    9
    • Method Detail

      • user

        PooledConnectionBuilder user​(String username)
        Specifies the username to be used when creating a connection
        Parameters:
        username - the database user on whose behalf the connection is being made
        Returns:
        the same PooledConnectionBuilder instance
      • password

        PooledConnectionBuilder password​(String password)
        Specifies the password to be used when creating a connection
        Parameters:
        password - the password to use for this connection. May be null
        Returns:
        the same PooledConnectionBuilder instance
      • superShardingKey

        PooledConnectionBuilder superShardingKey​(ShardingKey superShardingKey)
        Specifies a superShardingKey to be used when creating a connection
        Parameters:
        superShardingKey - the SuperShardingKey. May be null
        Returns:
        the same PooledConnectionBuilder instance
        See Also:
        ShardingKey, ShardingKeyBuilder
      • build

        PooledConnection build()
                        throws SQLException
        Returns an instance of the object defined by this builder.
        Returns:
        The built object
        Throws:
        SQLException - If an error occurs building the object