Release Notes

Microsoft JDBC-to-ODBC bridge

Installation

Install the JDBC-to-ODBC runtime support from http://microsoft.com/java/sdk

Sample Application

The JDBC sample application requires an ODBC data source, and its corresponding ODBC driver.

Exceptions to the JDBC Specification

The following methods do not fully implement the JDBC specification. They always either return a default value or throw a default exception with a descriptive message.

 

Driver

getPropertyInfo()

 

Connection

nativeSQL()

isClosed()

setReadOnly()

getReadOnly()

setAutoClose()

getAutoClose()

 

Statement / PreparedStatement / CallableStatement

cancel()

getMaxFieldSize()

setMaxFieldSize()

setEscapeProcessing()

setLong()

getLong()

setCursorName()

 

DatabaseMetaData

getBestRowIdentifier()

getCatalogs()

getCatalogSeparator()

getColumns()

getColumnPriviledges()

getCrossReference()

getExportedKeys()

getExtraNameCharacters()

getIdentifierQuoteString()

getImportedKeys()

getIndexInfo()

getMaxBinaryLiteralLength()

getMaxCatalogNameLength()

getMaxCharLiteralLength()

getMaxColumnNameLength()

getMaxConnections()

getMaxCursorNameLength()

getMaxIndexLength()

getProcedures()

getProcedureColumns()

getMaxProcedureNameLength()

getMaxSchemaNameLength()

getMaxStatementLength()

getMaxStatements()

getMaxTableNameLength()

getMaxUserNameLength()

getPrimaryKeys()

getSchemas()

getSearchStringEscape()

getSQLKeywords()

getTables()

getTableTypes()

getTablePriviledges()

getTypeInfo()

getVersionColumns()

supportsAlterTableWithAddColumn()

supportsAlterTableWithDropColumn()

supportsCatalogsInProcedureCalls()

supportsColumnAliasing()

supportsDifferentTableCorrelationNames()

supportsExpressionsInOrderBy()

supportsMultipleTransactions()

supportsPositionedDelete()

supportsPositionedUpdate()

supportsSchemasInProcedureCalls()

supportsSelectForUpdate()

supportsTableCorrelationNames()

supportsUnion()

supportsUnionAll()