Feature Matrix for MS SQL Server JDBC drivers

Feature Groups JDBC Version Introduced i-net UNA i-net SPRINTA i-net OPTA i-net MERLIA Comments
minimum Java Version  1.1 1.2 1.2 1.4 1.6  
JDBC API Version  1.22 2.0 Core 2.0 Opt. 3.0 4.0  
Unicode support- Yes Yes Yes Yes  
Batch Update2.0 Core Yes Yes Yes  
Blob/Clob2.0 Core Yes Yes Yes  
JNDI DataSources2.0 Optional Yes Yes  
Distributed Transaction2.0 Optional Yes Yes  
Connection Pooling2.0 Optional Yes Yes  
Statement Pooling3.0 Yes Yes Yes Yes  
Cluster support- Yes Yes additional API for high availability clients
Failover support- Yes Yes Yes Yes JDBC URL property “failover”
Transaction SavePoints3.0 Yes  
Trusted Connections- Yes Yes Yes Yes valid with named pipes, only
SSL Connections  Yes Yes protected by U.S. Patent
OEM licenses available- Yes Yes Yes Yes  
jar file size - 149 KB 303 KB 471 KB 564 KB
JDBC Classes JDBC Version Introduced i-net UNA i-net SPRINTA i-net OPTA i-net MERLIA Comments
minimum Java Version 1.1 1.2 1.2 1.4 1.6
Array2.0 Core Yes Yes Yes
Blob2.0 Core Yes Yes Yes
CallableStatement1.0 Yes Yes Yes Yes
Clob2.0 Core Yes Yes Yes
Connection1.0 Yes Yes Yes Yes
ConnectionPoolDataSource2.0 Optional Yes Yes
DatabaseMetaData1.0 Yes Yes Yes Yes
DataSource2.0 Optional Yes Yes
Driver1.0 Yes Yes Yes Yes
NClob4.0 Yes
ParameterMetaData3.0 Yes
PreparedStatement1.0 Yes Yes Yes Yes
Ref2.0 Core
ResultSet1.0 Yes Yes Yes Yes
ResultSetMetaData1.0 Yes Yes Yes Yes
RowId4.0 Yes
RowSet2.0 Optional Yes Yes CachedRowsSet, JdbcRowSet
Savepoint3.0 Yes
SQLXML4.0 Yes
Statement1.0 Yes Yes Yes Yes
Struct2.0 Core
XAConnection2.0 Optional Yes Yes
XADataSource2.0 Optional Yes Yes
XAResource2.0 Optional Yes Yes
 

© Copyright 1996 - 2017, i-net software; All Rights Reserved.