SQLServerConnectionPoolDataSource Class

Package:
com.microsoft.sqlserver.jdbc
Maven Artifact:
com.microsoft.sqlserver:mssql-jdbc:12.8.0.jre11

Implements

javax.sql.ConnectionPoolDataSource

public class SQLServerConnectionPoolDataSource
extends SQLServerDataSource
implements javax.sql.ConnectionPoolDataSource

Provides physical database connections for connection pool managers. SQLServerConnectionPoolDataSource is typically used in Java Application Server environments that support built-in connection pooling and require a ConnectionPoolDataSource to provide physical connections. For example, J2EE application servers that provide JDBC 3.0 API spec connection pooling.

Constructor Summary

Constructor Description
SQLServerConnectionPoolDataSource()

default constructor

Method Summary

Modifier and Type Method and Description
javax.sql.PooledConnection getPooledConnection()
javax.sql.PooledConnection getPooledConnection(String user, String password)
javax.naming.Reference getReference()

Methods inherited from SQLServerDataSource

<T>unwrap getAADSecurePrincipalId getAccessToken getAccessTokenCallback getAccessTokenCallbackClass getApplicationIntent getApplicationName getAuthentication getCalcBigDecimalPrecision getCancelQueryTimeout getClientCertificate getClientKey getColumnEncryptionSetting getConnectRetryCount getConnectRetryInterval getConnection getConnection getDatabaseName getDatetimeParameterType getDelayLoadingLobs getDescription getDisableStatementPooling getDomain getEnablePrepareOnFirstPreparedStatementCall getEnclaveAttestationProtocol getEnclaveAttestationUrl getEncrypt getFIPS getFailoverPartner getGSSCredentials getHostNameInCertificate getIPAddressPreference getInstanceName getJAASConfigurationName getJASSConfigurationName getKeyStoreAuthentication getKeyStoreLocation getKeyStorePrincipalId getKeyVaultProviderClientId getLastUpdateCount getLockTimeout getLogWriter getLoginTimeout getMSIClientId getMaxResultBuffer getMsiTokenCacheTtl getMultiSubnetFailover getPacketSize getParentLogger getPortNumber getPrepareMethod getQueryTimeout getRealm getReference getReplication getResponseBuffering getSSLProtocol getSelectMethod getSendStringParametersAsUnicode getSendTemporalDataTypesAsStringForBulkCopy getSendTimeAsDatetime getServerCertificate getServerName getServerNameAsACE getServerPreparedStatementDiscardThreshold getServerSpn getSocketFactoryClass getSocketFactoryConstructorArg getSocketTimeout getStatementPoolingCacheSize getTransparentNetworkIPResolution getTrustManagerClass getTrustManagerConstructorArg getTrustServerCertificate getTrustStore getTrustStoreType getURL getUseBulkCopyForBatchInsert getUseDefaultGSSCredential getUseDefaultJaasConfig getUseFlexibleCallableStatements getUseFmtOnly getUser getWorkstationID getXopenStates getcacheBulkCopyMetadata com.microsoft.sqlserver.jdbc.SQLServerDataSource.isWrapperFor(java.lang.Class< setAADSecurePrincipalId setAADSecurePrincipalSecret setAccessToken setAccessTokenCallback setAccessTokenCallbackClass setApplicationIntent setApplicationName setAuthentication setAuthenticationScheme setCalcBigDecimalPrecision setCancelQueryTimeout setClientCertificate setClientKey setClientKeyPassword setColumnEncryptionSetting setConnectRetryCount setConnectRetryInterval setDatabaseName setDatetimeParameterType setDelayLoadingLobs setDescription setDisableStatementPooling setDomain setEnablePrepareOnFirstPreparedStatementCall setEnclaveAttestationProtocol setEnclaveAttestationUrl setEncrypt setEncrypt setFIPS setFailoverPartner setGSSCredentials setHostNameInCertificate setIPAddressPreference setInstanceName setIntegratedSecurity setJAASConfigurationName setJASSConfigurationName setKeyStoreAuthentication setKeyStoreLocation setKeyStorePrincipalId setKeyStoreSecret setKeyVaultProviderClientId setKeyVaultProviderClientKey setLastUpdateCount setLockTimeout setLogWriter setLoginTimeout setMSIClientId setMaxResultBuffer setMsiTokenCacheTtl setMultiSubnetFailover setPacketSize setPassword setPortNumber setPrepareMethod setQueryTimeout setRealm setReplication setResponseBuffering setSSLProtocol setSelectMethod setSendStringParametersAsUnicode setSendTemporalDataTypesAsStringForBulkCopy setSendTimeAsDatetime setServerCertificate setServerName setServerNameAsACE setServerPreparedStatementDiscardThreshold setServerSpn setSocketFactoryClass setSocketFactoryConstructorArg setSocketTimeout setStatementPoolingCacheSize setTransparentNetworkIPResolution setTrustManagerClass setTrustManagerConstructorArg setTrustServerCertificate setTrustStore setTrustStorePassword setTrustStoreType setURL setUseBulkCopyForBatchInsert setUseDefaultGSSCredential setUseDefaultJaasConfig setUseFlexibleCallableStatements setUseFmtOnly setUser setWorkstationID setXopenStates setcacheBulkCopyMetadata toString

Methods inherited from java.lang.Object

java.lang.Object.clone java.lang.Object.equals java.lang.Object.finalize java.lang.Object.getClass java.lang.Object.hashCode java.lang.Object.notify java.lang.Object.notifyAll java.lang.Object.wait java.lang.Object.wait java.lang.Object.wait

Constructor Details

SQLServerConnectionPoolDataSource

public SQLServerConnectionPoolDataSource()

default constructor

Method Details

getPooledConnection

public PooledConnection getPooledConnection()

Throws:

java.sql.SQLException

getPooledConnection

public PooledConnection getPooledConnection(String user, String password)

Parameters:

user
password

Throws:

java.sql.SQLException

getReference

public Reference getReference()

Overrides:

SQLServerConnectionPoolDataSource.getReference()

Applies to