Overview of the JDBC Driver
What's New in the JDBC Driver
System Requirements for the JDBC Driver
Using the JDBC Driver
Understanding J2EE Support
Deploying the JDBC Driver
Finding Additional JDBC Driver Information
Connecting to SQL Server with the JDBC Driver
Building the Connection URL
Setting the Connection Properties
Setting the Data Source Properties
Working with a Connection
Using Connection Pooling
Using Database Mirroring (JDBC)
Understanding the JDBC Driver Data Types
Using Basic Data Types
Using Advanced Data Types
Understanding Data Type Differences
Understanding Data Type Conversions
Using Statements with the JDBC Driver
Using Statements with SQL
Using an SQL Statement with No Parameters
Using an SQL Statement with Parameters
Using an SQL Statement to Modify Database Objects
Using an SQL Statement to Modify Data
Using Statements with Stored Procedures
Using a Stored Procedure with No Parameters
Using a Stored Procedure with Input Parameters
Using a Stored Procedure with Output Parameters
Using a Stored Procedure with a Return Status
Using a Stored Procedure with an Update Count
Using Multiple Result Sets
Using SQL Escape Sequences
Using Auto Generated Keys
Performing Batch Operations
Handling Complex Statements
Managing Result Sets with the JDBC Driver
Understanding Cursor Types
Understanding Concurrency Control
Understanding Row Locking
Performing Transactions with the JDBC Driver
Understanding Transactions
Understanding XA Transactions
Understanding Isolation Levels
Using Savepoints
Using Holdability
Handling Metadata with the JDBC Driver
Using Database Metadata
Using Result Set Metadata
Using Parameter Metadata
Securing JDBC Driver Applications
Securing Connection Strings
Validating User Input
Application Security
Improving Performance and Reliability with the JDBC Driver
Closing Objects when Not In Use
Managing Transaction Size
Working with Statements and Result Sets
Diagnosing Problems with the JDBC Driver
Handling Errors
Getting the Driver Version
Tracing Driver Operation
Troubleshooting Connectivity
International Features of the JDBC Driver
Sample JDBC Driver Applications
Connecting and Retrieving Data
Connection URL Sample
Data Source Sample
Working with Data Types (JDBC)
Basic Data Types Sample
Working with Result Sets
Retrieving Result Set Data Sample
Modifying Result Set Data Sample
Caching Result Set Data Sample
JDBC Driver API Reference
SQLServerBlob Class
SQLServerBlob Members
SQLServerBlob Constructors
SQLServerBlob Constructor (SQLServerConnection, byte[])
SQLServerBlob Methods
getBinaryStream Method (SQLServerBlob)
getBytes Method (SQLServerBlob)
length Method (SQLServerBlob)
position Method (SQLServerBlob)
position Method (java.sql.Blob, long)
position Method (byte[], long)
setBinaryStream Method (SQLServerBlob)
setBytes Method (SQLServerBlob)
setBytes Method (long, byte[])
setBytes Method (long, byte[], int, int)
truncate Method (SQLServerBlob)
SQLServerCallableStatement Class
SQLServerCallableStatement Members
SQLServerCallableStatement Methods
getArray Method (SQLServerCallableStatement)
getArray Method (int)
getArray Method (java.lang.String)
getBigDecimal Method (SQLServerCallableStatement)
getBigDecimal Method (int)
getBigDecimal Method (int, int)
getBigDecimal Method (java.lang.String)
getBigDecimal Method (java.lang.String, int)
getBlob Method (SQLServerCallableStatement)
getBlob Method (int)
getBlob Method (java.lang.String)
getBoolean Method (SQLServerCallableStatement)
getBoolean Method (int)
getBoolean Method (java.lang.String)
getByte Method (SQLServerCallableStatement)
getByte Method (int)
getByte Method (java.lang.String)
getBytes Method (SQLServerCallableStatement)
getBytes Method (int)
getBytes Method (java.lang.String)
getClob Method (SQLServerCallableStatement)
getClob Method (int)
getClob Method (java.lang.String)
getDate Method (SQLServerCallableStatement)
getDate Method (int)
getDate Method (int, java.util.Calendar)
getDate Method (java.lang.String)
getDate Method (java.lang.String, java.util.Calendar)
getDouble Method (SQLServerCallableStatement)
getDouble Method (int)
getDouble Method (java.lang.String)
getFloat Method (SQLServerCallableStatement)
getFloat Method (int)
getFloat Method (java.lang.String)
getInt Method (SQLServerCallableStatement)
getInt Method (int)
getInt Method (java.lang.String)
getLong Method (SQLServerCallableStatement)
getLong Method (int)
getLong Method (java.lang.String)
getObject Method (SQLServerCallableStatement)
getObject Method (int)
getObject Method (int, java.util.Map)
getObject Method (java.lang.String)
getObject Method (java.lang.String, java.util.Map)
getRef Method (SQLServerCallableStatement)
getRef Method (int)
getRef Method (java.lang.String)
getShort Method (SQLServerCallableStatement)
getShort Method (int)
getShort Method (java.lang.String)
getString Method (SQLServerCallableStatement)
getString Method (int)
getString Method (java.lang.String)
getTime Method (SQLServerCallableStatement)
getTime Method (int)
getTime Method (int, java.util.Calendar)
getTime Method (java.lang.String)
getTime Method (java.lang.String, java.util.Calendar)
getTimestamp Method (SQLServerCallableStatement)
getTimestamp Method (int)
getTimestamp Method (int, java.util.Calendar)
getTimestamp Method (java.lang.String)
getTimestamp Method (java.lang.String, java.util.Calendar)
getURL Method (SQLServerCallableStatement)
getURL Method (int)
getURL Method (java.lang.String)
registerOutParameter Method (SQLServerCallableStatement)
registerOutParameter Method (int, int)
registerOutParameter Method (int, int, int)
registerOutParameter Method (int, int, java.lang.String)
registerOutParameter Method (java.lang.String, int)
registerOutParameter Method (java.lang.String, int, int)
registerOutParameter Method (java.lang.String, int, java.lang.String)
setAsciiStream Method (SQLServerCallableStatement)
setBigDecimal Method (SQLServerCallableStatement)
setBinaryStream Method (SQLServerCallableStatement)
setBoolean Method (SQLServerCallableStatement)
setByte Method (SQLServerCallableStatement)
setBytes Method (SQLServerCallableStatement)
setCharacterStream Method (SQLServerCallableStatement)
setDate Method (SQLServerCallableStatement)
setDate Method (java.lang.String, java.sql.Date)
setDate Method (java.lang.String, java.sql.Date, java.util.Calendar)
setDouble Method (SQLServerCallableStatement)
setFloat Method (SQLServerCallableStatement)
setInt Method (SQLServerCallableStatement)
setLong Method (SQLServerCallableStatement)
setNull Method (SQLServerCallableStatement)
setNull Method (java.lang.String, int)
setNull Method (java.lang.String, int, java.lang.String)
setObject Method (SQLServerCallableStatement)
setObject Method (java.lang.String, java.lang.Object)
setObject Method (java.lang.String, java.lang.Object, int)
setObject Method (java.lang.String, java.lang.Object, int, int)
setShort Method (SQLServerCallableStatement)
setString Method (SQLServerCallableStatement)
setTime Method (SQLServerCallableStatement)
setTime Method (java.lang.String, java.sql.Time)
setTime Method (java.lang.String, java.sql.Time, java.util.Calendar)
setTimestamp Method (SQLServerCallableStatement)
setTimestamp Method (java.lang.String, java.sql.Timestamp)
setTimestamp Method (java.lang.String, java.sql.Timestamp, java.util.Calendar)
setURL Method (SQLServerCallableStatement)
wasNull Method (SQLServerCallableStatement)
SQLServerClob Class
SQLServerClob Members
SQLServerClob Constructors
SQLServerClob Constructor (SQLServerConnection, java.lang.String)
SQLServerClob Methods
getAsciiStream Method (SQLServerClob)
getCharacterStream Method (SQLServerClob)
getSubString Method (SQLServerClob)
length Method (SQLServerClob)
position Method (SQLServerClob)
position Method (java.sql.Clob, long)
position Method (java.lang.String, long)
setAsciiStream Method (SQLServerClob)
setCharacterStream Method (SQLServerClob)
setString Method (SQLServerClob)
setString Method (long, java.lang.String)
setString Method (long, java.lang.String, int, int)
truncate Method (SQLServerClob)
SQLServerConnection Class
SQLServerConnection Members
SQLServerConnection Methods
clearWarnings Method (SQLServerConnection)
close Method (SQLServerConnection)
commit Method (SQLServerConnection)
createStatement Method (SQLServerConnection)
createStatement Method ()
createStatement Method (int, int)
createStatement Method (int, int, int)
getAutoCommit Method (SQLServerConnection)
getCatalog Method (SQLServerConnection)
getHoldability Method (SQLServerConnection)
getMetaData Method (SQLServerConnection)
getTransactionIsolation Method (SQLServerConnection)
getTypeMap Method (SQLServerConnection)
getWarnings Method (SQLServerConnection)
isClosed Method (SQLServerConnection)
isReadOnly Method (SQLServerConnection)
nativeSQL Method (SQLServerConnection)
prepareCall Method (SQLServerConnection)
prepareCall Method (java.lang.String)
prepareCall Method (java.lang.String, int, int)
prepareCall Method (java.lang.String, int, int, int)
prepareStatement Method (SQLServerConnection)
prepareStatement Method (java.lang.String)
prepareStatement Method (java.lang.String, int)
prepareStatement Method (java.lang.String, int[])
prepareStatement Method (java.lang.String, int, int)
prepareStatement Method (java.lang.String, int, int, int)
prepareStatement Method (java.lang.String, java.lang.String[])
releaseSavepoint Method (SQLServerConnection)
rollback Method (SQLServerConnection)
rollback Method ()
rollback Method (java.sql.Savepoint)
setAutoCommit Method (SQLServerConnection)
setCatalog Method (SQLServerConnection)
setHoldability Method (SQLServerConnection)
setReadOnly Method (SQLServerConnection)
setSavepoint Method (SQLServerConnection)
setSavepoint Method ()
setSavepoint Method (java.lang.String)
setTransactionIsolation Method (SQLServerConnection)
setTypeMap Method (SQLServerConnection)
SQLServerConnection Fields
TRANSACTION_SNAPSHOT Field (SQLServerConnection)
SQLServerConnectionPoolDataSource Class
SQLServerConnectionPoolDataSource Members
SQLServerConnectionPoolDataSource Constructors
SQLServerConnectionPoolDataSource Constructor ()
SQLServerConnectionPoolDataSource Methods
getPooledConnection Method (SQLServerConnectionPoolDataSource)
getPooledConnection Method ()
getPooledConnection Method (java.lang.String, java.lang.String)
getReference Method (SQLServerConnectionPoolDataSource)
SQLServerDatabaseMetaData Class
SQLServerDatabaseMetaData Members
SQLServerDatabaseMetaData Methods
allProceduresAreCallable Method (SQLServerDatabaseMetaData)
allTablesAreSelectable Method (SQLServerDatabaseMetaData)
dataDefinitionCausesTransactionCommit Method (SQLServerDatabaseMetaData)
dataDefinitionIgnoredInTransactions Method (SQLServerDatabaseMetaData)
deletesAreDetected Method (SQLServerDatabaseMetaData)
doesMaxRowSizeIncludeBlobs Method (SQLServerDatabaseMetaData)
getAttributes Method (SQLServerDatabaseMetaData)
getBestRowIdentifier Method (SQLServerDatabaseMetaData)
getCatalogs Method (SQLServerDatabaseMetaData)
getCatalogSeparator Method (SQLServerDatabaseMetaData)
getCatalogTerm Method (SQLServerDatabaseMetaData)
getColumnPrivileges Method (SQLServerDatabaseMetaData)
getColumns Method (SQLServerDatabaseMetaData)
getConnection Method (SQLServerDatabaseMetaData)
getCrossReference Method (SQLServerDatabaseMetaData)
getDatabaseMajorVersion Method (SQLServerDatabaseMetaData)
getDatabaseMinorVersion Method (SQLServerDatabaseMetaData)
getDatabaseProductName Method (SQLServerDatabaseMetaData)
getDatabaseProductVersion Method (SQLServerDatabaseMetaData)
getDefaultTransactionIsolation Method (SQLServerDatabaseMetaData)
getDriverMajorVersion Method (SQLServerDatabaseMetaData)
getDriverMinorVersion Method (SQLServerDatabaseMetaData)
getDriverName Method (SQLServerDatabaseMetaData)
getDriverVersion Method (SQLServerDatabaseMetaData)
getExportedKeys Method (SQLServerDatabaseMetaData)
getExtraNameCharacters Method (SQLServerDatabaseMetaData)
getIdentifierQuoteString Method (SQLServerDatabaseMetaData)
getImportedKeys Method (SQLServerDatabaseMetaData)
getIndexInfo Method (SQLServerDatabaseMetaData)
getJDBCMajorVersion Method (SQLServerDatabaseMetaData)
getJDBCMinorVersion Method (SQLServerDatabaseMetaData)
getMaxBinaryLiteralLength Method (SQLServerDatabaseMetaData)
getMaxCatalogNameLength Method (SQLServerDatabaseMetaData)
getMaxCharLiteralLength Method (SQLServerDatabaseMetaData)
getMaxColumnNameLength Method (SQLServerDatabaseMetaData)
getMaxColumnsInGroupBy Method (SQLServerDatabaseMetaData)
getMaxColumnsInIndex Method (SQLServerDatabaseMetaData)
getMaxColumnsInOrderBy Method (SQLServerDatabaseMetaData)
getMaxColumnsInSelect Method (SQLServerDatabaseMetaData)
getMaxColumnsInTable Method (SQLServerDatabaseMetaData)
getMaxConnections Method (SQLServerDatabaseMetaData)
getMaxCursorNameLength Method (SQLServerDatabaseMetaData)
getMaxIndexLength Method (SQLServerDatabaseMetaData)
getMaxProcedureNameLength Method (SQLServerDatabaseMetaData)
getMaxRowSize Method (SQLServerDatabaseMetaData)
getMaxSchemaNameLength Method (SQLServerDatabaseMetaData)
getMaxStatementLength Method (SQLServerDatabaseMetaData)
getMaxStatements Method (SQLServerDatabaseMetaData)
getMaxTableNameLength Method (SQLServerDatabaseMetaData)
getMaxTablesInSelect Method (SQLServerDatabaseMetaData)
getMaxUserNameLength Method (SQLServerDatabaseMetaData)
getNumericFunctions Method (SQLServerDatabaseMetaData)
getPrimaryKeys Method (SQLServerDatabaseMetaData)
getProcedureColumns Method (SQLServerDatabaseMetaData)
getProcedures Method (SQLServerDatabaseMetaData)
getProcedureTerm Method (SQLServerDatabaseMetaData)
getResultSetHoldability Method (SQLServerDatabaseMetaData)
getSchemas Method (SQLServerDatabaseMetaData)
getSchemaTerm Method (SQLServerDatabaseMetaData)
getSearchStringEscape Method (SQLServerDatabaseMetaData)
getSQLKeywords Method (SQLServerDatabaseMetaData)
getSQLStateType Method (SQLServerDatabaseMetaData)
getStringFunctions Method (SQLServerDatabaseMetaData)
getSuperTables Method (SQLServerDatabaseMetaData)
getSuperTypes Method (SQLServerDatabaseMetaData)
getSystemFunctions Method (SQLServerDatabaseMetaData)
getTablePrivileges Method (SQLServerDatabaseMetaData)
getTables Method (SQLServerDatabaseMetaData)
getTableTypes Method (SQLServerDatabaseMetaData)
getTimeDateFunctions Method (SQLServerDatabaseMetaData)
getTypeInfo Method (SQLServerDatabaseMetaData)
getUDTs Method (SQLServerDatabaseMetaData)
getURL Method (SQLServerDatabaseMetaData)
getUserName Method (SQLServerDatabaseMetaData)
getVersionColumns Method (SQLServerDatabaseMetaData)
insertsAreDetected Method (SQLServerDatabaseMetaData)
isCatalogAtStart Method (SQLServerDatabaseMetaData)
isReadOnly Method (SQLServerDatabaseMetaData)
locatorsUpdateCopy Method (SQLServerDatabaseMetaData)
nullPlusNonNullIsNull Method (SQLServerDatabaseMetaData)
nullsAreSortedAtEnd Method (SQLServerDatabaseMetaData)
nullsAreSortedAtStart Method (SQLServerDatabaseMetaData)
nullsAreSortedHigh Method (SQLServerDatabaseMetaData)
nullsAreSortedLow Method (SQLServerDatabaseMetaData)
othersDeletesAreVisible Method (SQLServerDatabaseMetaData)
othersInsertsAreVisible Method (SQLServerDatabaseMetaData)
othersUpdatesAreVisible Method (SQLServerDatabaseMetaData)
ownDeletesAreVisible Method (SQLServerDatabaseMetaData)
ownInsertsAreVisible Method (SQLServerDatabaseMetaData)
ownUpdatesAreVisible Method (SQLServerDatabaseMetaData)
storesLowerCaseIdentifiers Method (SQLServerDatabaseMetaData)
storesLowerCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)
storesMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)
storesMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)
storesUpperCaseIdentifiers Method (SQLServerDatabaseMetaData)
storesUpperCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)
supportsAlterTableWithAddColumn Method (SQLServerDatabaseMetaData)
supportsAlterTableWithDropColumn Method (SQLServerDatabaseMetaData)
supportsANSI92EntryLevelSQL Method (SQLServerDatabaseMetaData)
supportsANSI92FullSQL Method (SQLServerDatabaseMetaData)
supportsANSI92IntermediateSQL Method (SQLServerDatabaseMetaData)
supportsBatchUpdates Method (SQLServerDatabaseMetaData)
supportsCatalogsInDataManipulation Method (SQLServerDatabaseMetaData)
supportsCatalogsInIndexDefinitions Method (SQLServerDatabaseMetaData)
supportsCatalogsInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)
supportsCatalogsInProcedureCalls Method (SQLServerDatabaseMetaData)
supportsCatalogsInTableDefinitions Method (SQLServerDatabaseMetaData)
supportsColumnAliasing Method (SQLServerDatabaseMetaData)
supportsConvert Method (SQLServerDatabaseMetaData)
supportsConvert Method ()
supportsConvert Method (int, int)
supportsCoreSQLGrammar Method (SQLServerDatabaseMetaData)
supportsCorrelatedSubqueries Method (SQLServerDatabaseMetaData)
supportsDataDefinitionAndDataManipulationTransactions Method (SQLServerDatabaseMetaData)
supportsDataManipulationTransactionsOnly Method (SQLServerDatabaseMetaData)
supportsDifferentTableCorrelationNames Method (SQLServerDatabaseMetaData)
supportsExpressionsInOrderBy Method (SQLServerDatabaseMetaData)
supportsExtendedSQLGrammar Method (SQLServerDatabaseMetaData)
supportsFullOuterJoins Method (SQLServerDatabaseMetaData)
supportsGetGeneratedKeys Method (SQLServerDatabaseMetaData)
supportsGroupBy Method (SQLServerDatabaseMetaData)
supportsGroupByBeyondSelect Method (SQLServerDatabaseMetaData)
supportsGroupByUnrelated Method (SQLServerDatabaseMetaData)
supportsIntegrityEnhancementFacility Method (SQLServerDatabaseMetaData)
supportsLikeEscapeClause Method (SQLServerDatabaseMetaData)
supportsLimitedOuterJoins Method (SQLServerDatabaseMetaData)
supportsMinimumSQLGrammar Method (SQLServerDatabaseMetaData)
supportsMixedCaseIdentifiers Method (SQLServerDatabaseMetaData)
supportsMixedCaseQuotedIdentifiers Method (SQLServerDatabaseMetaData)
supportsMultipleOpenResults Method (SQLServerDatabaseMetaData)
supportsMultipleResultSets Method (SQLServerDatabaseMetaData)
supportsMultipleTransactions Method (SQLServerDatabaseMetaData)
supportsNamedParameters Method (SQLServerDatabaseMetaData)
supportsNonNullableColumns Method (SQLServerDatabaseMetaData)
supportsOpenCursorsAcrossCommit Method (SQLServerDatabaseMetaData)
supportsOpenCursorsAcrossRollback Method (SQLServerDatabaseMetaData)
supportsOpenStatementsAcrossCommit Method (SQLServerDatabaseMetaData)
supportsOpenStatementsAcrossRollback Method (SQLServerDatabaseMetaData)
supportsOrderByUnrelated Method (SQLServerDatabaseMetaData)
supportsOuterJoins Method (SQLServerDatabaseMetaData)
supportsPositionedDelete Method (SQLServerDatabaseMetaData)
supportsPositionedUpdate Method (SQLServerDatabaseMetaData)
supportsResultSetConcurrency Method (SQLServerDatabaseMetaData)
supportsResultSetHoldability Method (SQLServerDatabaseMetaData)
supportsResultSetType Method (SQLServerDatabaseMetaData)
supportsSavepoints Method (SQLServerDatabaseMetaData)
supportsSchemasInDataManipulation Method (SQLServerDatabaseMetaData)
supportsSchemasInIndexDefinitions Method (SQLServerDatabaseMetaData)
supportsSchemasInPrivilegeDefinitions Method (SQLServerDatabaseMetaData)
supportsSchemasInProcedureCalls Method (SQLServerDatabaseMetaData)
supportsSchemasInTableDefinitions Method (SQLServerDatabaseMetaData)
supportsSelectForUpdate Method (SQLServerDatabaseMetaData)
supportsStatementPooling Method (SQLServerDatabaseMetaData)
supportsStoredProcedures Method (SQLServerDatabaseMetaData)
supportsSubqueriesInComparisons Method (SQLServerDatabaseMetaData)
supportsSubqueriesInExists Method (SQLServerDatabaseMetaData)
supportsSubqueriesInIns Method (SQLServerDatabaseMetaData)
supportsSubqueriesInQuantifieds Method (SQLServerDatabaseMetaData)
supportsTableCorrelationNames Method (SQLServerDatabaseMetaData)
supportsTransactionIsolationLevel Method (SQLServerDatabaseMetaData)
supportsTransactions Method (SQLServerDatabaseMetaData)
supportsUnion Method (SQLServerDatabaseMetaData)
supportsUnionAll Method (SQLServerDatabaseMetaData)
updatesAreDetected Method (SQLServerDatabaseMetaData)
usesLocalFilePerTable Method (SQLServerDatabaseMetaData)
usesLocalFiles Method (SQLServerDatabaseMetaData)
SQLServerDataSource Class
SQLServerDataSource Members
SQLServerDataSource Constructors
SQLServerDataSource Constructor ()
SQLServerDataSource Methods
getApplicationName Method (SQLServerDataSource)
getConnection Method (SQLServerDataSource)
getConnection Method ()
getConnection Method (java.lang.String, java.lang.String)
getDatabaseName Method (SQLServerDataSource)
getDescription Method (SQLServerDataSource)
getFailoverPartner Method (SQLServerDataSource)
getInstanceName Method (SQLServerDataSource)
getLastUpdateCount Method (SQLServerDataSource)
getLockTimeout Method (SQLServerDataSource)
getLoginTimeout Method (SQLServerDataSource)
getLogWriter Method (SQLServerDataSource)
getPacketSize Method (SQLServerDataSource)
getPortNumber Method (SQLServerDataSource)
getReference Method (SQLServerDataSource)
getSelectMethod Method (SQLServerDataSource)
getSendStringParametersAsUnicode Method (SQLServerDataSource)
getServerName Method (SQLServerDataSource)
getURL Method (SQLServerDataSource)
getUser Method (SQLServerDataSource)
getWorkstationID Method (SQLServerDataSource)
getXopenStates Method (SQLServerDataSource)
setApplicationName Method (SQLServerDataSource)
setDatabaseName Method (SQLServerDataSource)
setDescription Method (SQLServerDataSource)
setFailoverPartner Method (SQLServerDataSource)
setInstanceName Method (SQLServerDataSource)
setIntegratedSecurity Method (SQLServerDataSource)
setLastUpdateCount Method (SQLServerDataSource)
setLockTimeout Method (SQLServerDataSource)
setLoginTimeout Method (SQLServerDataSource)
setLogWriter Method (SQLServerDataSource)
setPacketSize Method (SQLServerDataSource)
setPassword Method (SQLServerDataSource)
setPortNumber Method (SQLServerDataSource)
setSelectMethod Method (SQLServerDataSource)
setSendStringParametersAsUnicode Method (SQLServerDataSource)
setServerName Method (SQLServerDataSource)
setURL Method (SQLServerDataSource)
setUser Method (SQLServerDataSource)
setWorkstationID Method (SQLServerDataSource)
setXopenStates Method (SQLServerDataSource)
SQLServerDataSourceObjectFactory Class
SQLServerDataSourceObjectFactory Members
SQLServerDataSourceObjectFactory Constructors
SQLServerDataSourceObjectFactory Constructor ()
SQLServerDataSourceObjectFactory Methods
getObjectInstance Method (SQLServerDataSourceObjectFactory)
SQLServerDriver Class
SQLServerDriver Members
SQLServerDriver Constructors
SQLServerDriver Constructor ()
SQLServerDriver Methods
acceptsURL Method (SQLServerDriver)
connect Method (SQLServerDriver)
getMajorVersion Method (SQLServerDriver)
getMinorVersion Method (SQLServerDriver)
getPropertyInfo Method (SQLServerDriver)
jdbcCompliant Method (SQLServerDriver)
SQLServerException Class
SQLServerException Members
SQLServerException Constructors
SQLServerException Constructor (com.microsoft.sqlserver.jdbc.IOBuffer, java.lang.String, java.lang.String, int, boolean)
SQLServerException Constructor (com.microsoft.sqlserver.jdbc.IOBuffer, java.lang.String, java.lang.String, com.microsoft.sqlserver.jdbc.StreamError, boolean)
SQLServerException Methods
generateStateCode Method (SQLServerException)
makeFromDatabaseError Method (SQLServerException)
makeFromDriverError Method (SQLServerException)
mapFromXopen Method (SQLServerException)
SQLServerParameterMetaData Class
SQLServerParameterMetaData Members
SQLServerParameterMetaData Methods
getParameterClassName Method (SQLServerParameterMetaData)
getParameterCount Method (SQLServerParameterMetaData)
getParameterMode Method (SQLServerParameterMetaData)
getParameterType Method (SQLServerParameterMetaData)
getParameterTypeName Method (SQLServerParameterMetaData)
getPrecision Method (SQLServerParameterMetaData)
getScale Method (SQLServerParameterMetaData)
isNullable Method (SQLServerParameterMetaData)
isSigned Method (SQLServerParameterMetaData)
SQLServerPooledConnection Class
SQLServerPooledConnection Members
SQLServerPooledConnection Methods
addConnectionEventListener Method (SQLServerPooledConnection)
close Method (SQLServerPooledConnection)
getConnection Method (SQLServerPooledConnection)
removeConnectionEventListener Method (SQLServerPooledConnection)
SQLServerPreparedStatement Class
SQLServerPreparedStatement Members
SQLServerPreparedStatement Methods
addBatch Method (SQLServerPreparedStatement)
addBatch Method ()
addBatch Method (java.lang.String)
clearBatch Method (SQLServerPreparedStatement)
clearParameters Method (SQLServerPreparedStatement)
close Method (SQLServerPreparedStatement)
execute Method (SQLServerPreparedStatement)
execute Method ()
execute Method (java.lang.String)
executeBatch Method (SQLServerPreparedStatement)
executeQuery Method (SQLServerPreparedStatement)
executeQuery Method ()
executeQuery Method (java.lang.String)
executeUpdate Method (SQLServerPreparedStatement)
executeUpdate Method ()
executeUpdate Method (java.lang.String)
getMetaData Method (SQLServerPreparedStatement)
getParameterMetaData Method (SQLServerPreparedStatement)
setArray Method (SQLServerPreparedStatement)
setAsciiStream Method (SQLServerPreparedStatement)
setBigDecimal Method (SQLServerPreparedStatement)
setBinaryStream Method (SQLServerPreparedStatement)
setBlob Method (SQLServerPreparedStatement)
setBoolean Method (SQLServerPreparedStatement)
setByte Method (SQLServerPreparedStatement)
setBytes Method (SQLServerPreparedStatement)
setCharacterStream Method (SQLServerPreparedStatement)
setClob Method (SQLServerPreparedStatement)
setDate Method (SQLServerPreparedStatement)
setDate Method (int, java.sql.Date)
setDate Method (int, java.sql.Date, java.util.Calendar)
setDouble Method (SQLServerPreparedStatement)
setFloat Method (SQLServerPreparedStatement)
setInt Method (SQLServerPreparedStatement)
setLong Method (SQLServerPreparedStatement)
setNull Method (SQLServerPreparedStatement)
setNull Method (int, int)
setNull Method (int, int, java.lang.String)
setObject Method (SQLServerPreparedStatement)
setObject Method (int, java.lang.Object)
setObject Method (int, java.lang.Object, int)
setObject Method (int, java.lang.Object, int, int)
setRef Method (SQLServerPreparedStatement)
setShort Method (SQLServerPreparedStatement)
setString Method (SQLServerPreparedStatement)
setTime Method (SQLServerPreparedStatement)
setTime Method (int, java.sql.Time)
setTime Method (int, java.sql.Time, java.util.Calendar)
setTimestamp Method (SQLServerPreparedStatement)
setTimestamp Method (int, java.sql.Timestamp)
setTimestamp Method (int, java.sql.Timestamp, java.util.Calendar)
setUnicodeStream Method (SQLServerPreparedStatement)
setURL Method (SQLServerPreparedStatement)
SQLServerResource Class
SQLServerResource Members
SQLServerResource Constructors
SQLServerResource Constructor ()
SQLServerResource Methods
getContents Method (SQLServerResource)
SQLServerResultSet Class
SQLServerResultSet Members
SQLServerResultSet Methods
absolute Method (SQLServerResultSet)
afterLast Method (SQLServerResultSet)
beforeFirst Method (SQLServerResultSet)
cancelRowUpdates Method (SQLServerResultSet)
clearWarnings Method (SQLServerResultSet)
close Method (SQLServerResultSet)
deleteRow Method (SQLServerResultSet)
finalize Method (SQLServerResultSet)
findColumn Method (SQLServerResultSet)
first Method (SQLServerResultSet)
getArray Method (SQLServerResultSet)
getArray Method (int) (SQLServerResultSet)
getArray Method (java.lang.String) (SQLServerResultSet)
getAsciiStream Method (SQLServerResultSet)
getAsciiStream Method (int)
getAsciiStream Method (java.lang.String)
getBigDecimal Method (SQLServerResultSet)
getBigDecimal Method (int) (SQLServerResultSet)
getBigDecimal Method (int, int) (SQLServerResultSet)
getBigDecimal Method (java.lang.String) (SQLServerResultSet)
getBigDecimal Method (java.lang.String, int) (SQLServerResultSet)
getBinaryStream Method (SQLServerResultSet)
getBinaryStream Method (int)
getBinaryStream Method (java.lang.String)
getBlob Method (SQLServerResultSet)
getBlob Method (int) (SQLServerResultSet)
getBlob Method (java.lang.String) (SQLServerResultSet)
getBoolean Method (SQLServerResultSet)
getBoolean Method (int) (SQLServerResultSet)
getBoolean Method (java.lang.String) (SQLServerResultSet)
getByte Method (SQLServerResultSet)
getByte Method (int) (SQLServerResultSet)
getByte Method (java.lang.String) (SQLServerResultSet)
getBytes Method (SQLServerResultSet)
getBytes Method (int) (SQLServerResultSet)
getBytes Method (java.lang.String) (SQLServerResultSet)
getCharacterStream Method (SQLServerResultSet)
getCharacterStream Method (int)
getCharacterStream Method (java.lang.String)
getClob Method (SQLServerResultSet)
getClob Method (int) (SQLServerResultSet)
getClob Method (java.lang.String) (SQLServerResultSet)
getConcurrency Method (SQLServerResultSet)
getCursorName Method (SQLServerResultSet)
getDate Method (SQLServerResultSet)
getDate Method (int) (SQLServerResultSet)
getDate Method (int, java.util.Calendar) (SQLServerResultSet)
getDate Method (java.lang.String) (SQLServerResultSet)
getDate Method (java.lang.String, java.util.Calendar) (SQLServerResultSet)
getDouble Method (SQLServerResultSet)
getDouble Method (int) (SQLServerResultSet)
getDouble Method (java.lang.String) (SQLServerResultSet)
getFetchDirection Method (SQLServerResultSet)
getFetchSize Method (SQLServerResultSet)
getFloat Method (SQLServerResultSet)
getFloat Method (int) (SQLServerResultSet)
getFloat Method (java.lang.String) (SQLServerResultSet)
getInt Method (SQLServerResultSet)
getInt Method (int) (SQLServerResultSet)
getInt Method (java.lang.String) (SQLServerResultSet)
getLong Method (SQLServerResultSet)
getLong Method (int) (SQLServerResultSet)
getLong Method (java.lang.String) (SQLServerResultSet)
getMetaData Method (SQLServerResultSet)
getObject Method (SQLServerResultSet)
getObject Method (int) (SQLServerResultSet)
getObject Method (int, java.util.Map) (SQLServerResultSet)
getObject Method (java.lang.String) (SQLServerResultSet)
getObject Method (java.lang.String, java.util.Map) (SQLServerResultSet)
getRef Method (SQLServerResultSet)
getRef Method (int) (SQLServerResultSet)
getRef Method (java.lang.String) (SQLServerResultSet)
getRow Method (SQLServerResultSet)
getShort Method (SQLServerResultSet)
getShort Method (int) (SQLServerResultSet)
getShort Method (java.lang.String) (SQLServerResultSet)
getStatement Method (SQLServerResultSet)
getString Method (SQLServerResultSet)
getString Method (int) (SQLServerResultSet)
getString Method (java.lang.String) (SQLServerResultSet)
getTime Method (SQLServerResultSet)
getTime Method (int) (SQLServerResultSet)
getTime Method (int, java.util.Calendar) (SQLServerResultSet)
getTime Method (java.lang.String) (SQLServerResultSet)
getTime Method (java.lang.String, java.util.Calendar) (SQLServerResultSet)
getTimestamp Method (SQLServerResultSet)
getTimestamp Method (int) (SQLServerResultSet)
getTimestamp Method (int, java.util.Calendar) (SQLServerResultSet)
getTimestamp Method (java.lang.String) (SQLServerResultSet)
getTimestamp Method (java.lang.String, java.util.Calendar) (SQLServerResultSet)
getType Method (SQLServerResultSet)
getUnicodeStream Method (SQLServerResultSet)
getUnicodeStream Method (int)
getUnicodeStream Method (java.lang.String)
getURL Method (SQLServerResultSet)
getURL Method (int) (SQLServerResultSet)
getURL Method (java.lang.String) (SQLServerResultSet)
getWarnings Method (SQLServerResultSet)
insertRow Method (SQLServerResultSet)
isAfterLast Method (SQLServerResultSet)
isBeforeFirst Method (SQLServerResultSet)
isFirst Method (SQLServerResultSet)
isLast Method (SQLServerResultSet)
last Method (SQLServerResultSet)
moveToCurrentRow Method (SQLServerResultSet)
moveToInsertRow Method (SQLServerResultSet)
next Method (SQLServerResultSet)
previous Method (SQLServerResultSet)
refreshRow Method (SQLServerResultSet)
relative Method (SQLServerResultSet)
rowDeleted Method (SQLServerResultSet)
rowInserted Method (SQLServerResultSet)
rowUpdated Method (SQLServerResultSet)
setFetchDirection Method (SQLServerResultSet)
setFetchSize Method (SQLServerResultSet)
updateArray Method (SQLServerResultSet)
updateArray Method (int, java.sql.Array)
updateArray Method (java.lang.String, java.sql.Array)
updateAsciiStream Method (SQLServerResultSet)
updateAsciiStream Method (int, java.io.InputStream, int)
updateAsciiStream Method (java.lang.String, java.io.InputStream, int)
updateBigDecimal Method (SQLServerResultSet)
updateBigDecimal Method (int, java.math.BigDecimal)
updateBigDecimal Method (java.lang.String, java.math.BigDecimal)
updateBinaryStream Method (SQLServerResultSet)
updateBinaryStream Method (int, java.io.InputStream, int)
updateBinaryStream Method (java.lang.String, java.io.InputStream, int)
updateBlob Method (SQLServerResultSet)
updateBlob Method (int, java.sql.Blob)
updateBlob Method (java.lang.String, java.sql.Blob)
updateBoolean Method (SQLServerResultSet)
updateBoolean Method (int, boolean)
updateBoolean Method (java.lang.String, boolean)
updateByte Method (SQLServerResultSet)
updateByte Method (int, byte)
updateByte Method (java.lang.String, byte)
updateBytes Method (SQLServerResultSet)
updateBytes Method (int, byte[])
updateBytes Method (java.lang.String, byte[])
updateCharacterStream Method (SQLServerResultSet)
updateCharacterStream Method (int, java.io.Reader, int)
updateCharacterStream Method (java.lang.String, java.io.Reader, int)
updateClob Method (SQLServerResultSet)
updateClob Method (int, java.sql.Clob)
updateClob Method (java.lang.String, java.sql.Clob)
updateDate Method (SQLServerResultSet)
updateDate Method (int, java.sql.Date)
updateDate Method (java.lang.String, java.sql.Date)
updateDouble Method (SQLServerResultSet)
updateDouble Method (int, double)
updateDouble Method (java.lang.String, double)
updateFloat Method (SQLServerResultSet)
updateFloat Method (int, float)
updateFloat Method (java.lang.String, float)
updateInt Method (SQLServerResultSet)
updateInt Method (int, int)
updateInt Method (java.lang.String, int)
updateLong Method (SQLServerResultSet)
updateLong Method (int, long)
updateLong Method (java.lang.String, long)
updateNull Method (SQLServerResultSet)
updateNull Method (int)
updateNull Method (java.lang.String)
updateObject Method (SQLServerResultSet)
updateObject Method (int, java.lang.Object)
updateObject Method (int, java.lang.Object, int)
updateObject Method (java.lang.String, java.lang.Object)
updateObject Method (java.lang.String, java.lang.Object, int)
updateRef Method (SQLServerResultSet)
updateRef Method (int, java.sql.Ref)
updateRef Method (java.lang.String, java.sql.Ref)
updateRow Method (SQLServerResultSet)
updateShort Method (SQLServerResultSet)
updateShort Method (int, short)
updateShort Method (java.lang.String, short)
updateString Method (SQLServerResultSet)
updateString Method (int, java.lang.String)
updateString Method (java.lang.String, java.lang.String)
updateTime Method (SQLServerResultSet)
updateTime Method (int, java.sql.Time)
updateTime Method (java.lang.String, java.sql.Time)
updateTimestamp Method (SQLServerResultSet)
updateTimestamp Method (int, java.sql.Timestamp)
updateTimestamp Method (java.lang.String, java.sql.Timestamp)
wasNull Method (SQLServerResultSet)
SQLServerResultSet Fields
CONCUR_SS_OPTIMISTIC_CC Field (SQLServerResultSet)
CONCUR_SS_OPTIMISTIC_CCVAL Field (SQLServerResultSet)
CONCUR_SS_SCROLL_LOCKS Field (SQLServerResultSet)
TYPE_SS_DIRECT_FORWARD_ONLY Field (SQLServerResultSet)
TYPE_SS_SCROLL_DYNAMIC Field (SQLServerResultSet)
TYPE_SS_SCROLL_KEYSET Field (SQLServerResultSet)
TYPE_SS_SCROLL_STATIC Field (SQLServerResultSet)
TYPE_SS_SERVER_CURSOR_FORWARD_ONLY Field (SQLServerResultSet)
SQLServerResultSetMetaData Class
SQLServerResultSetMetaData Members
SQLServerResultSetMetaData Methods
getCatalogName Method (SQLServerResultSetMetaData)
getColumnClassName Method (SQLServerResultSetMetaData)
getColumnCount Method (SQLServerResultSetMetaData)
getColumnDisplaySize Method (SQLServerResultSetMetaData)
getColumnLabel Method (SQLServerResultSetMetaData)
getColumnName Method (SQLServerResultSetMetaData)
getColumnType Method (SQLServerResultSetMetaData)
getColumnTypeName Method (SQLServerResultSetMetaData)
getPrecision Method (SQLServerResultSetMetaData)
getScale Method (SQLServerResultSetMetaData)
getSchemaName Method (SQLServerResultSetMetaData)
getTableName Method (SQLServerResultSetMetaData)
isAutoIncrement Method (SQLServerResultSetMetaData)
isCaseSensitive Method (SQLServerResultSetMetaData)
isCurrency Method (SQLServerResultSetMetaData)
isDefinitelyWritable Method (SQLServerResultSetMetaData)
isNullable Method (SQLServerResultSetMetaData)
isReadOnly Method (SQLServerResultSetMetaData)
isSearchable Method (SQLServerResultSetMetaData)
isSigned Method (SQLServerResultSetMetaData)
isWritable Method (SQLServerResultSetMetaData)
SQLServerSavepoint Class
SQLServerSavepoint Members
SQLServerSavepoint Constructors
SQLServerSavepoint Constructor (SQLServerConnection, java.lang.StringName)
SQLServerSavepoint Methods
getLabel Method (SQLServerSavepoint)
getSavepointId Method (SQLServerSavepoint)
getSavepointName Method (SQLServerSavepoint)
isNamed Method (SQLServerSavepoint)
SQLServerStatement Class
SQLServerStatement Members
SQLServerStatement Methods
addBatch Method (SQLServerStatement)
cancel Method (SQLServerStatement)
clearBatch Method (SQLServerStatement)
clearWarnings Method (SQLServerStatement)
close Method (SQLServerStatement)
execute Method (SQLServerStatement)
execute Method (java.lang.String) (SQLServerStatement)
execute Method (java.lang.String, int)
execute Method (java.lang.String, int[])
execute Method (java.lang.String, java.lang.String[])
executeBatch Method (SQLServerStatement)
executeQuery Method (SQLServerStatement)
executeUpdate Method (SQLServerStatement)
executeUpdate Method (java.lang.String) (SQLServerStatement)
executeUpdate Method (java.lang.String, int)
executeUpdate Method (java.lang.String, int[])
executeUpdate Method (java.lang.String, java.lang.String[])
getConnection Method (SQLServerStatement)
getFetchDirection Method (SQLServerStatement)
getFetchSize Method (SQLServerStatement)
getGeneratedKeys Method (SQLServerStatement)
getMaxFieldSize Method (SQLServerStatement)
getMaxRows Method (SQLServerStatement)
getMoreResults Method (SQLServerStatement)
getMoreResults Method ()
getMoreResults Method (int)
getQueryTimeout Method (SQLServerStatement)
getResultSet Method (SQLServerStatement)
getResultSetConcurrency Method (SQLServerStatement)
getResultSetHoldability Method (SQLServerStatement)
getResultSetType Method (SQLServerStatement)
getUpdateCount Method (SQLServerStatement)
getWarnings Method (SQLServerStatement)
setCursorName Method (SQLServerStatement)
setEscapeProcessing Method (SQLServerStatement)
setFetchDirection Method (SQLServerStatement)
setFetchSize Method (SQLServerStatement)
setMaxFieldSize Method (SQLServerStatement)
setMaxRows Method (SQLServerStatement)
setQueryTimeout Method (SQLServerStatement)
SQLServerXAConnection Class
SQLServerXAConnection Members
SQLServerXAConnection Methods
getXAResource Method (SQLServerXAConnection)
SQLServerXADataSource Class
SQLServerXADataSource Members
SQLServerXADataSource Constructors
SQLServerXADataSource Constructor ()
SQLServerXADataSource Methods
getReference Method (SQLServerXADataSource)
getXAConnection Method (SQLServerXADataSource)
getXAConnection Method ()
getXAConnection Method (java.lang.String, java.lang.String)
SQLServerXAResource Class
SQLServerXAResource Members
SQLServerXAResource Methods
commit Method (SQLServerXAResource)
end Method (SQLServerXAResource)
forget Method (SQLServerXAResource)
getTransactionTimeout Method (SQLServerXAResource)
isSameRM Method (SQLServerXAResource)
prepare Method (SQLServerXAResource)
recover Method (SQLServerXAResource)
rollback Method (SQLServerXAResource)
setTransactionTimeout Method (SQLServerXAResource)
start Method (SQLServerXAResource)
JDBC Driver Copyright and Legal Information