Topic: jTDS JDBC Driver 1.2 released (for M$ SQL Server)

  Print this page

1.jTDS JDBC Driver 1.2 released (for M$ SQL Server) Copy to clipboard
Posted by: why
Posted on: 2004-03-31 12:28

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.

2.Re:jTDS JDBC Driver 0.8-rc1 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: boyard
Posted on: 2004-06-01 09:41

不错,好东西
大家可以把ms的sql server driver扔了。
hehe

3.Re:jTDS JDBC Driver 0.9-rc1 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2004-08-13 10:35

http://sourceforge.net/project/shownotes.php?release_id=259223

The 0.9-rc1 release includes a large number of new features, implementing almost
everything in the JDBC 3.0 specification. The driver has been re-written to
provide TDS 5.0 and 8.0 support. Initial support for named pipes has also been
added via the jCIFS library (http://jcifs.samba.org/). Further, the driver now
works with SQL Server 2005. A lot of work has gone into this release as can be
seen by looking at the change log.

New features:

o TDS 5.0 support
o TDS 8.0 support.
o Named pipes.
o SQL Server 2005 support.
o Blob and Clob memory control.
o Control over prepared statement calls with the prepareSql property.
o RFE #956800 setNull(): Not implemented

4.Re:jTDS JDBC Driver 0.9-rc2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2004-09-07 03:03

http://sourceforge.net/project/shownotes.php?release_id=264045

2004.08.27

The 0.9-rc2 corrects a number of bugs and adds new prepared statement and
cursor functionality. Bug #966274 introduced in 0.8-rc1 has finally been
resolved and windows authentication works again with SQL Server regardless
of the service pack used.

New features:

o Added initial support for prepareSql=4 (sp_prepexec)
o Added initial support for sp_cursorprepare, sp_cursorprepexec and sp_cursorexecute.

5.Re:jTDS JDBC Driver 0.9-rc2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: luckbird888
Posted on: 2004-09-16 18:20

各位,有没有遇到过0.9-rc2乱码的问题?
在做项目的时候,通过hibernate与sql server连接,从数据库中检索出的数据全为乱码,该怎么解决?

6.Re:jTDS JDBC Driver 0.9 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2004-10-09 02:00

http://sourceforge.net/project/shownotes.php?release_id=271340
2004.09.28

The 0.9 release is a complete rewrite from 0.8, a lot simpler and with fewer
issues. It is the first major release after 3 months of continuous development
and bugfixing. jTDS has become fully compatible with JDBC 3.0 and it passes
the JDBC Certification Test Suite. Around 85 bugs were fixed and a lot of new
features added:

o TDS 5.0 (Sybase 11 and 12) support
o TDS 8.0 (SQL Server 2000) support.
o Named pipes support.
o SQL Server 2005 support.
o Blob and Clob memory control.
o Control over preparing statement calls with the prepareSql property.
o Localized error messages support.
o Automatic protocol detection for all versions except 4.2.

7.Re:jTDS JDBC Driver 0.9-rc2 released (for M$ SQL Server) [Re: luckbird888] Copy to clipboard
Posted by: mmwy
Posted on: 2004-10-09 08:32

luckbird888 wrote:
各位,有没有遇到过0.9-rc2乱码的问题?
在做项目的时候,通过hibernate与sql server连接,从数据库中检索出的数据全为乱码,该怎么解决?

读vachar字段的时候,要用iso8859-1转码。如果是nvarchar的字段就不用转了

8.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2005-04-08 10:23

Release Name: 1.0.2

Notes:
jTDS is a type 4 JDBC 3.0 driver for Microsoft SQL Server and Sybase.

jTDS 1.0.2 is a minor release, containing a single bug fix over 1.0.1: because
of a regression the jTDS 1.0.1 DataSource implementation failed to work with
JNDI. If you encountered this problem please upgrade to 1.0.2. We appologize
for any problems we might have caused.

--------------------------------------------------------------------------------
Changes:
Changes from jTDS 1.0.1
=======================

02/14/2005 - Alin Sinpalean
o Corrected bug [1122481] how handle new behavior since 1.0.1. The DataSource
factory failed with NPE because the properties are no longer initialized in
the constructor. Added tests to ensure no regressions.
o Updated version number to 1.0.2.

Changes from jTDS 1.0
=======================

02/09/2005 - Alin Sinpalean
o Corrected bug [1118956] statement.setMaxFieldSize() sends a statement every
time. Max field size is now set at the same time and in the same way as row
count.
o Applied Mike's patch [1118912] Small enhancements. Extended DataTruncation
support, better transaction isolation support for Sybase and a fixed NPE in
Logger.

02/08/2005 - Alin Sinpalean
o Synchronized JtdsStatement.close(); a race condition could occur between a
pool implementation closing Statements after a timeout and finalize().

02/07/2005 - Alin Sinpalean
o Added the explanation for the "Connection refused" error message to the FAQ.
o Removed tests that were failing because of the fix for bug [1113709]
Connecting via DataSource (the assumptions of these tests were incorrect, to
start with).

02/05/2005 - Alin Sinpalean
o Applied patch [117010] Instance parameter support for local named pipes,
submitted by Matthias Germann.

02/04/2005 - Alin Sinpalean
o Applied Mike's fix for bugs [1116113] (SSL fails to build or run under java
1.3) and [1102505] (SSL Resume Failure). TLS resume is now disabled
altogether until we find out what the actual cause is and work around it.
o Applied Mike's fix for bug [1116046] {fn} escape can't handle nested
functions.

02/02/2005 - Alin Sinpalean
o Applied patch [1110911] Encryption request causes conn reset, submitted by
Mike Hutchinson. SSL negotiation has been implemented to handle the encrypt
only login case.
o Applied a modified version of patch [1107090] Revised query timeout logic,
submitted by Mike. Timeouts should now have millisecond precision, using a
single timer thread per VM.
o Fixed bug [1113709] Connecting via DataSource. Invalid default TDS version
was used by JtdsDataSource when connecting to Sybase. Breaks all default
property tests (which relied on DataSource setting default values in the
constructor), but the previous behavior was incorrect.
o Fixed bug [1113040] Small bug in net.sourceforge.jtds.jdbcx.PooledConnection
Thanks go to Marcus Nylander for finding the bug and providing a fix.

02/01/2005 - Alin Sinpalean
o Updated FAQ to include information about local named pipes.
o Modified SQLParser to only extract table names when requested to, because it
was unable to parse function calls.

01/28/2005 - Alin Sinpalean
o Added checks for timeout exceptions to JtdsStatement.executeSQLQuery() and
executeSQL(); if a cursor creation fails because of a timeout, the exception
is thrown back and a direct select is not attempted anymore.
o commit() and rollback() now throw SQLException if called in auto-commit
mode, per API documentation.
o Added checks to setAutoCommit() and setTransactionIsolation() to no longer
submit requests to the server if already in the correct mode.

01/27/2005 - Alin Sinpalean
o Fixed bug in CharsetInfo, caused by getClassLoader() returning null when the
class loader is the bootstrap classloader.

9.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: huajiazhou
Posted on: 2005-04-08 21:00

请问这个连接MS SQL数据库的代码是什么样子的啊 ?
能给个例子吗 ?
多谢

10.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: huajiazhou] Copy to clipboard
Posted by: why
Posted on: 2005-04-08 22:58

huajiazhou wrote:
请问这个连接MS SQL数据库的代码是什么样子的啊 ?

As you should know, the only differences would be the class name and URL format.
You could find these easily on jTDS's FAQ page: http://jtds.sourceforge.net/faq.html

11.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: huajiazhou
Posted on: 2005-04-09 13:05

thank u very much!Smile

12.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: huajiazhou
Posted on: 2005-04-09 14:49

当我下载了jtds-1.0.2来连接我的SQL SERVER 2000数据库的时候出错了
主要源代码是:
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String url="jdbc:jtds:sqlserver://localhost:1433/jspdev;user=sa;password=5696285";
Connection con= DriverManager.getConnection(url);
Statement stmt=con.createStatement();
String inq="select * from book";
ResultSet rst=stmt.executeQuery(inq);

错误提示是:
exception
javax.servlet.ServletException: Network error IOException: Connection refused: connect
  org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
  org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
  org.apache.jsp.testMssql3_jsp._jspService(testMssql3_jsp.java:118)
  org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
  org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:298)
  org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
  org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
  javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
怎么好像是网络错误啊 ??能告诉我是什么原因吗 ?
机器环境是这样的XP SP2,Tomcat 5.0,jtds-1.0.2,SQL SERVER 2000

13.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: huajiazhou] Copy to clipboard
Posted by: why
Posted on: 2005-04-09 20:16

huajiazhou wrote:
机器环境是这样的XP SP2,Tomcat 5.0,jtds-1.0.2,SQL SERVER 2000

it could be related to XP SP2's "security features"
check recent SQL Server related posts on this board and on Google.

14.Re:jTDS JDBC Driver 1.0.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: huajiazhou
Posted on: 2005-04-09 23:18

多谢大家了
这个问题已经被我解决了
我下载了一个SQL SERVER 2000 SP3A的补丁后终于可以连上SQL SERVER 了

15.Re:jTDS JDBC Driver 1.0.3 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2005-06-02 13:02

http://sourceforge.net/project/shownotes.php?release_id=320711
Notes:
The jTDS Project has released version 1.0.3 of the open source JDBC
driver for Microsoft SQL Server and Sybase. jTDS 1.0.3 is a major bugfix
release, greatly improving stability over previous versions.

Fixes:
o get/setTimestamp() DST problem
o Server side cursors: ResultSet.relative() and updateRow() issues
o Timeouts: memory leaks, not working correctly
o Connection.close() hanging on network failure
o ParameterMetaData: incomplete implementation
o Sybase: Batch updates using JDBC escapes not working
o Sybase: TEXT and IMAGE values truncated on write
o Single Sign On crashing the JVM
o Clob disk caching: data loss, temp file leaks
o Statement cancel: race condition, hang
o CallableStatement update count caching
o WRITETEXT and UPDATETEXT generating spurious output parameters
o SQL query parser issues

New features:
o Client side cursors and multiple open ResultSets per Statement
o Added a batchSize parameter to control executed batch size
o Added a WSID URL parameter to set the workstation ID
o Connection recovery after OutOfMemoryError

16.Re:jTDS JDBC Driver 1.0.3 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: mazalet
Posted on: 2005-07-05 15:49

发现开源的东西的好处了,装上源代码后,可以直接发现原因,呵呵!

17.Re:jTDS JDBC Driver 1.1 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2005-07-05 21:02

http://sourceforge.net/forum/forum.php?forum_id=474418
Date: 2005-06-16 04:05
Summary: jTDS JDBC Driver 1.1 released

The jTDS Project has released version 1.1 of the open source JDBC driver
for Microsoft SQL Server and Sybase. jTDS 1.1 is a major feature release,
notable new features including much improved statement caching,
configurable metadata caching, optimistic/pessimistic locking support and
fast forward-only cursors.

Other major changes are the switch to sp_prepare as default prepare
method for prepared statements instead of temporary stored procedures
-- which means better performance and no more depending on
transaction rollbacks -- and optimistic concurrency instead of row locks on
default updatable result sets.

Make sure to check the jTDS FAQ for detailed explanations of the new features and new defaults.

Other new features:
o Configurable mapping of large types to LOBs or standard Java types
o Extended scrollability and updatability options
o byte[] to String conversions now generate hex values
o Control over memory/disk buffering
o Optimized handling of date/time values
o Complete SQLException chaining

Bug fixes:
o absolute() and relative() with larger than row count values
o cancel() synchronization
o 'Hidden' columns visible with prepared statements
o Deadlocking with c3p0 due to thread interrupt flag being set
o BigDecimal to String conversion dropping insignificant trailing zeroes
o updateRow() reset the position to the beginning of the block
o Execution failed if statement could not be prepared
o Deadlocking when parsing an unterminated multi-line comment
o Sybase getProcedureColumns bug
o Blob/Clob position methods failed

18.Re:jTDS JDBC Driver 0.9-rc2 released (for M$ SQL Server) [Re: mmwy] Copy to clipboard
Posted by: flyingis
Posted on: 2005-07-13 18:44

mmwy wrote:
读vachar字段的时候,要用iso8859-1转码。如果是nvarchar的字段就不用转了


这样就可以了吗?是不是在1.1版中支持的要好些?
JDBC真的很烦,感觉不是很稳定,有时我能在JSF中读取数据,过两天再运行的时候就不行了,真的是很郁闷!

19.Re:jTDS JDBC Driver 1.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: why
Posted on: 2005-11-09 20:48

from http://www.theserverside.com/news/thread.tss?thread_id=37471

The jTDS Project has released version 1.2 of the open source JDBC driver
for Microsoft SQL Server and Sybase. jTDS 1.2 is a major bugfix release,
improving over the very successful jTDS 1.1. A few new features, such as
support for Sybase ASE 15, SQL Server 2005 and improved exceptions
also made it into the release.

New features:
o Support for Sybase ASE 15
o Improved support for SQL Server 2005 varchar(max) and varbinary(max)
o Complete handling of cursor exceptions and downgrading
o Better handling of cancels and timeouts
o Configurable socket timeout
o Subclasses of basic JDBC types recognized as setObject() values

Check the changelog for detailed listings of the bugs fixed and new features.

20.Re:jTDS JDBC Driver 1.2 released (for M$ SQL Server) [Re: why] Copy to clipboard
Posted by: renfei101
Posted on: 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.


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923