Tóm Tắt
JDBC 4.1 compliance for the JDBC driver
Trong bài viết này
Download JDBC driver
Note
Versions prior to Microsoft JDBC Driver 4.2 for SQL Server are compliant for Java Database Connectivity API 4.0 specifications. This section does not apply for versions prior to the 4.2 release.
The Java Database Connectivity API 4.1 specification is supported by the Microsoft JDBC Driver 4.2 for SQL Server, with the following API methods.
SQLServerConnection class
New Method
Description
JDBC Driver Implementation
void abort(Executor executor)
Terminates an open connection to SQL Server.
Implemented as described in the java.sql.Connection interface. For more information, see java.sql.Connection.
void setSchema(String schema)
Sets schema for the current connection.
SQL Server doesn’t support setting schema for the current session. The driver silently logs a warning message if this method is called. For more information, see java.sql.Connection.
String getSchema()
Returns the schema name for the current connection.
Since SQL Server doesn’t support setting schema for the current connection, the driver instead returns the default schema of the user. For more information, see java.sql.Connection.
SQLServerDatabaseMetaData class
New Method
Description
JDBC Driver Implementation
boolean generatedKeyAlwaysReturned()
Returns true as the driver supports retrieving generated keys
Implemented as described in the java.sql. DatabaseMetaData interface. For more information, see java.sql.DatabaseMetaData.
ResultSet getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Retrieves a description of the pseudo/hidden columns
Return an empty result set as SQL Server doesn’t have a formal notion of pseudo-columns. For more information, see java.sql.DatabaseMetaData.
SQLServerStatement class
New Method
Description
JDBC Driver Implementation
void closeOnCompletion()
Specifies that this Statement will be closed when all its dependent result sets are closed.
Implemented as described in the java.sql.Statement interface. For more information, see java.sql.Statement.
boolean isCloseOnCompletion()
Returns a value indicating whether this Statement will be closed when all its dependent result sets are closed.
Implemented as described in the java.sql.Statement interface. For more information, see java.sql.Statement.
The Java Database Connectivity API 4.1 specification is supported by the Microsoft JDBC Driver 4.2 for SQL Server, with the following features.
New Feature
Description
New Escape Function
Limited Return Rows Escape
Partially supported
Escape syntax: LIMIT <rows> OFFSET <row_offset>.
The Java Database Connectivity API 4.1 specification is supported by the Microsoft JDBC Driver 4.2 for SQL Server, with the following Data Type Mappings.
Data Type Mappings
Description
New data type mappings are now supported in PreparedStatement.setObject() and PreparedStatement.setNull() methods.
1. New Java to JDBC type mapping
(a) java.math.BigInteger to JDBC BIGINT
(b) java.util.Date and java.util.Calendar to JDBC TIMESTAMP
2. New data type conversions:
(a) java.math.BigInteger to CHAR, VARCHAR, LONGVARCHAR, and BIGINT
(b) java.util.Date and java.util.Calendar to CHAR, VARCHAR, LONGVARCHAR, DATE, TIME, and TIMESTAMP
For more information, see JDBC 4.1 specification.