| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
|---|---|---|---|---|---|---|---|
SQLServerConnection Class |
Learn the public API details for the SQLServerConnection class in the JDBC Driver for SQL Server. |
David-Engel |
v-davidengel |
01/19/2017 |
sql |
connectivity |
reference |
[!INCLUDEDriver_JDBC_Download]
Represents a JDBC connection to a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] database.
Package: com.microsoft.sqlserver.jdbc
Implements: ISQLServerConnection, java.io.Serializable
public class SQLServerConnection
SQLServerConnection supports JDBC connection pooling and can be either a physical JDBC connection or a logical JDBC connection. SQLServerConnection manages transaction control for all statements that were created from it, and it can participate in XA distributed transactions managed via a XAResource adapter.
SQLServerConnection manages a pool of prepared statement handles. Prepared statements are prepared once and are typically run many times with different data values for their parameters. Prepared statements are also maintained across logical (pooled) connection closes.
Note
SQLServerConnection is not thread safe. However, multiple statements that are created from a single connection can be processed simultaneously in concurrent threads.
This class supports unwrapping to SQLServerConnection class, java.sql.connection interface, and ISQLServerConnection interface. For more information, see Wrappers and Interfaces.