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
Major bug fixes (out of over 30 fixes):
o Statement pool memory leak
o Java 1.5 BigDecimal problems
o Possible synchronization problems
o setAutoCommit() behavior not according to specification
o getTimestamp() returns invalid value after calling getString()
o Cursor opens fails when cursor threshold <> -1
o iso_1 charset and Sybase
o "All pipe instances are busy" not handled properly
o SSL fails with SQL Server 2005
o Sybase: insert UTF8 string fails when length is 255
jTDS is a complete implementation of JDBC 3.0, passing 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.
Make sure to check the changelog for detailed listings of the bugs fixed and new features. The source code and binaries can be downloaded from SourceForge.
-
jTDS JDBC Driver 1.2 released (19 messages)
- Posted by: Alin Sinpalean
- Posted on: November 08 2005 09:32 EST
Threaded Messages (19)
- jTDS JDBC Driver 1.2 released by Victor C. on November 08 2005 13:30 EST
- jtds rocks! by Kai Virkki on November 08 2005 14:03 EST
- very good driver by Simone Avogadro on November 08 2005 15:52 EST
- very good driver by Alin Sinpalean on November 09 2005 04:53 EST
- jTDS JDBC Driver 1.2 released by Sergei Batiuk on November 08 2005 15:55 EST
- What's the point? by Kurt Williams on November 08 2005 16:03 EST
-
One other possibly unimportant point... by Kurt Williams on November 08 2005 04:07 EST
- One other possibly unimportant point... by Francisco A Lozano on November 08 2005 05:04 EST
-
JTDS works with Windows (Native) Authentication by Brian Smith on November 08 2005 08:43 EST
-
JTDS works with Windows (Native) Authentication by Mark N on November 08 2005 09:19 EST
-
Read the README.SSO file by Brian Smith on November 09 2005 02:59 EST
- Read the README.SSO file by Alin Sinpalean on November 09 2005 05:00 EST
- Read the README.SSO file by Mark N on November 10 2005 12:02 EST
-
Read the README.SSO file by Brian Smith on November 09 2005 02:59 EST
-
JTDS works with Windows (Native) Authentication by Mark N on November 08 2005 09:19 EST
-
What's the point? by Michael Chan on November 08 2005 09:10 EST
-
What's the point? by Neil Bartlett on November 09 2005 04:40 EST
-
What's the point? by Alin Sinpalean on November 09 2005 05:11 EST
- What's the point? by shelby goerlitz on November 11 2005 06:18 EST
- What's the point? by Mark N on November 09 2005 08:56 EST
-
What's the point? by Alin Sinpalean on November 09 2005 05:11 EST
-
What's the point? by Neil Bartlett on November 09 2005 04:40 EST
-
One other possibly unimportant point... by Kurt Williams on November 08 2005 04:07 EST
- What's the point? by Kurt Williams on November 08 2005 16:03 EST
- jTDS and SQL2K Source Code by Mo Na on February 16 2006 22:15 EST
-
jTDS JDBC Driver 1.2 released[ Go to top ]
- Posted by: Victor C.
- Posted on: November 08 2005 13:30 EST
- in response to Alin Sinpalean
Most JDBC drivers are poor.
This one is GREAT!
.V -
jtds rocks![ Go to top ]
- Posted by: Kai Virkki
- Posted on: November 08 2005 14:03 EST
- in response to Victor C.
I've been really satisfied with the jTDS driver. I'm quite impressed of its reliability and performance. Sure there are other JDBC drivers for SQL Server, mostly commercial ones, but jTDS is the best I've come across. -
very good driver[ Go to top ]
- Posted by: Simone Avogadro
- Posted on: November 08 2005 15:52 EST
- in response to Alin Sinpalean
really a very good driver, we had many headhackes with MS drivers and are now using jTDS with satisfaction.
If I may suggest I'd like to see something like a 'compatibility' statement extended to:
- various OS platforms
- various SQLServer versions
e.g.: is it OK to install SQLServer 2000 Enterprise SP4 over a Win2003 Server?
service packs compatibility is a serious issue under some conditions. -
very good driver[ Go to top ]
- Posted by: Alin Sinpalean
- Posted on: November 09 2005 04:53 EST
- in response to Simone Avogadro
As far as I can tell there are no compatibility issues between jTDS and particular SQL Server/OS versions. The only issues come from bugs in particular SQL Server service packs but they are completely internal to SQL Server.
Of course every time a new version comes out there is a possibility that some new features take a while to become available through jTDS but on the other hand not a lot of users jump on those features right away. -
jTDS JDBC Driver 1.2 released[ Go to top ]
- Posted by: Sergei Batiuk
- Posted on: November 08 2005 15:55 EST
- in response to Alin Sinpalean
What's the point? Sybase and MS have their own JDBC drivers. In my recent projects I used MS driver for SQL Server and it worked ok for me. -
What's the point?[ Go to top ]
- Posted by: Kurt Williams
- Posted on: November 08 2005 16:03 EST
- in response to Sergei Batiuk
What's the point? Well, for one Microsoft's JDBC driver is slow, buggy, and doesn't implement all of JDBC 3.0. jTDS is fast, high-quality, and fully implemented. I, for one, am very glad I don't have to depend on Microsoft to provide me with a decent JDBC implementation. Lets face it, it's not exactly in Microsoft's best interest to provide a top-notch Java implementation of anything. Java isn't exactly a priority in Redmond. Other than that, I guess there isn't a point. -
One other possibly unimportant point...[ Go to top ]
- Posted by: Kurt Williams
- Posted on: November 08 2005 16:07 EST
- in response to Kurt Williams
I forgot, the other point is that jTDS is fully supported by Hibernate. The Microsoft driver is not. -
One other possibly unimportant point...[ Go to top ]
- Posted by: Francisco A Lozano
- Posted on: November 08 2005 17:04 EST
- in response to Kurt Williams
I forgot, the other point is that jTDS is fully supported by Hibernate. The Microsoft driver is not.
Not only in hibernate, but also in hibernate synchronizer. I've found out that if you try to reverse-engineer PostgreSQL, Oracle or MySQL databases with it, you get very poor hibernate maps. But if you implement your schema in SQL Server 2000 and reverse-engineer it with jTDS, you get a very accurate mapping and you have to make almost no corrections. Provided that hibernate makes almost RDBMS-independent apps, I can happily develop against my "MS-SQL Server 2000 Developer" and deploy on anything I want to (currently PostgreSQL). -
JTDS works with Windows (Native) Authentication[ Go to top ]
- Posted by: Brian Smith
- Posted on: November 08 2005 20:43 EST
- in response to Kurt Williams
JTDS lets you connect to SQL Server using native Windows domain authentication. The Microsoft-supplied JDBC driver for SQL Server only lets you use SQL Server Authentication. That means that you can have transparent single-sign-on with JTDS but not with the Microsoft driver.
It is easier to download and install JTDS than it is to download and install the Microsoft driver.
JTDS is actively developed and supported by people that want JDBC access to SQL Server to work well. The Microsoft-supplied driver is just a stripped-down, OEM version ofthe DataDirect driver; it is (barely) supported by a company (Microsoft) that actively discourages JDBC and Java altogether.
JTDS is open-source, the Microsoft-supplied driver is not.
FWIW, My companies server only allows native domain authentication, which made the native Microsoft driver a non-option. -
JTDS works with Windows (Native) Authentication[ Go to top ]
- Posted by: Mark N
- Posted on: November 08 2005 21:19 EST
- in response to Brian Smith
JTDS lets you connect to SQL Server using native Windows domain authentication.
You can? Please share! -
Read the README.SSO file[ Go to top ]
- Posted by: Brian Smith
- Posted on: November 09 2005 02:59 EST
- in response to Mark N
I have only used it with a Windows client though. Connect to the server with a JDBC URL like "jdbc:jtds:sqlserver://server-name/DATABASE" (no username, no password). As the README.SSO file says "This is done using a native (Windows-only) library, ntlmauth.dll," which must be in the path. -
Read the README.SSO file[ Go to top ]
- Posted by: Alin Sinpalean
- Posted on: November 09 2005 05:00 EST
- in response to Brian Smith
There's also the possibility of providing Windows credentials instead of SQL Server user name and password. For this you have to specify a domain property in the URL:
jdbc:jtds:sqlserver://server-name/DATABASE;user=WIN_USER;password=WIN_PASSWD;domain=WIN_DOMAIN
The SSO approach will obviously only work from Windows (as it uses a Windows DLL) but this will work from any OS (I have used it from Linux). Chech the jTDS FAQ for detailed information on the domain property and the list of all other URL properties. -
Read the README.SSO file[ Go to top ]
- Posted by: Mark N
- Posted on: November 10 2005 12:02 EST
- in response to Brian Smith
I see your title now too. Sadly, I'm not much on directions. :) -
What's the point?[ Go to top ]
- Posted by: Michael Chan
- Posted on: November 08 2005 21:10 EST
- in response to Kurt Williams
Well, for one Microsoft's JDBC driver is slow, buggy, and
>> doesn't implement all of JDBC 3.0.
My impression is that M$ intentionally made a slow and buggy JDBC driver for MSSQL so ppl will be lured to use .net. -
What's the point?[ Go to top ]
- Posted by: Neil Bartlett
- Posted on: November 09 2005 04:40 EST
- in response to Michael Chan
<blockquoteMy impression is that M$ intentionally made a slow and buggy JDBC driver for MSSQL so ppl will be lured to use .net.
Actually their recently released driver is much, much better. I don't know how it compares to jTDS but it's certainly not "intentionally slow and buggy".
There's a very good reason for that, I think: Microsoft may not like Java much, but they can see that there's a good market for databases to sit behind Java applications. Of course they'd prefer you to use .Net, but if you do use Java then they still want you to use SQL Server instead of Oracle. -
What's the point?[ Go to top ]
- Posted by: Alin Sinpalean
- Posted on: November 09 2005 05:11 EST
- in response to Neil Bartlett
The old (SQL Server 2000) JDBC driver from Microsoft was a very old DataDirect driver with ony a few dozen minor bugs fixed in over 4 years. That says something about Microsoft's commitment to Java.
Their recently released driver is OEMed from JNetDirect. Microsoft looks much more determined to make this work (and it's definitely already better than the old driver) but it still has a lot of bugs (in my testing I found serious concurrency issues and even data consistency problems). It's difficult to say how much effort will Microsoft put into it, but the main reason while we keep working on jTDS is that for the moment we think it's the better choice overall; there's no financial reward. -
What's the point?[ Go to top ]
- Posted by: shelby goerlitz
- Posted on: November 11 2005 18:18 EST
- in response to Alin Sinpalean
Nice work Alin. jTDS continues to improve and making a great JDBC driver is a non-trivial activity -- this driver has made a lot of SQL Server customers happy.
Everyone looking for the release version of the new Microsoft driver will have to wait a few weeks more (JAN '06) -- we had some good feedback from our Beta 2 customers that we need to accomodate in the product.
-shelby
Shelby Goerlitz
Microsoft, SQL Server -
What's the point?[ Go to top ]
- Posted by: Mark N
- Posted on: November 09 2005 20:56 EST
- in response to Neil Bartlett
<blockquoteMy impression is that M$ intentionally made a slow and buggy JDBC driver for MSSQL so ppl will be lured to use .net.
Actually their recently released driver is much, much better. I don't know how it compares to jTDS but it's certainly not "intentionally slow and buggy".There's a very good reason for that, I think: Microsoft may not like Java much, but they can see that there's a good market for databases to sit behind Java applications. Of course they'd prefer you to use .Net, but if you do use Java then they still want you to use SQL Server instead of Oracle.
Thanks. I would rather use a SQL Server user/pwd (no need to create a network user) because most of my apps don't need db access by the users. But I do have a SQL server DBA who likes to just give trusted access. This way I don't have to explain to him why I need a sql user/pwd. -
jTDS and SQL2K Source Code[ Go to top ]
- Posted by: Mo Na
- Posted on: February 16 2006 22:15 EST
- in response to Alin Sinpalean
Can anybody post source code for jTDS and SQL Server connections.
TIA,
Mohan