renfei101
发贴: 1
积分: 0
|
于 2005-11-22 21:01
why wrote: http://sourceforge.net/projects/jtds/
Overview
jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12). jTDS is based on the work of the FreeTDS project and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all of the DatabaseMetaData and ResultSetMetaData methods. Check out the feature matrix for more details.
http://sourceforge.net/project/shownotes.php?release_id=299683 Release Name: 1.0
Notes: The jTDS Project has released version 1.0 of the jTDS JDBC driver for SQL Server and Sybase. After 3 1/2 years of development, 21 releases and 100K downloads, jTDS is finally considered stable enough and JDBC feature complete to grant the first official production release.
All important bugs fixed, jTDS is still the most performant JDBC driver for SQL Server and Sybase. It passes the J2EE 1.3 certification and Hibernate test suites and is the preferred SQL Server/Sybase driver for JBoss, Hibernate, Atlassian JIRA and Confluence, DbVisualizer and ComPiere.
New features: o Single Sign On (Windows authentication using the logged user's credentials) o SSL secure communication support o Local named pipes (greatly improved local communication speed) o Paged fetching for cursor based ResultSets
jTDS is THE JDBC driver for SQL Server. Open source, faster than any other SQL Server driver and with a full implementation of the JDBC 2.1 spec.
jTDS JDBC Driver 0.8-rc1 released
The 0.8-rc1 release comes with three major changes. From a functional point of view the release is centered around one major improvement: the new semantically correct Connection implementation, using a single physical connection (as opposed to previous releases, which used multiple physical connections to achieve Statement concurrency at the cost of correctness and possible deadlocking). Thanks to this one change 0.8-rc1 is the first jTDS release to pass the Hibernate test suite and to actually be a complete and correct JDBC implementation.
The two other areas where major changes took place are documentation and licensing. The documentation has been greatly improved both in the source package and online (the site and the documentation included in the source package are actually the same). Also, starting with 0.8-rc1 jTDS is licensed under the LGPL. We have decided to do this in order to give jTDS a greater chance to grow in the future, but also to prevent it from becoming a launchpad for new commercial drivers.
New features:
o Correct Connection implementation, using a single physical connection. o SQLExceptions thrown by jTDS now have associated SQL state values. o Improved performance (no kidding). o Closer to complete Blob/Clob support (there are still some memory issues).
Bugfixes:
o Scrollable/updateable ResultSets did not work with PreparedStatements. o macAddress and lastUpdateCount parameters work. o executeBatch() now works with empty batches too. o Bug #887508 (getObject() returns Integer-Object on Types.SMALLINT) fixed. o Bug #924030 (EscapeProcessor problem with "{}" brackets) fixed. o SELECT FOR BROWSE returned an extra column.
0.8 released (2004-06-21) Notes: The 0.8 release corrects a number of bugs reported against 0.8-rc1, and adds several more JDBC 3 features.
New features: o Support for passing parameters to stored procedures by name. o Support for Types.BOOLEAN. o Initial Savepoint implementation o Support for streaming Blob/Clob writes. o Added initial (limited) ParameterMetaData support. o initCause() is now called for SQLExceptions under 1.4+ JVMs.
0.8.1 released (2004-07-07) Notes: The 0.8.1 release primarily corrects a deployment problem with 0.8 in JREs prior to 1.4.
Hibernate的优点
|