jTDS

Description

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, 15). jTDS is based on FreeTDS 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 the DatabaseMetaData and ResultSetMetaData methods. Quite a few of the commercial JDBC drivers out there are based on jTDS (or FreeTDS), even if they no longer acknowledge this. jTDS has been tested with virtually all JDBC-based database management tools and is the driver of choice for most of these (recommended for DbVisualizer and SQuirreL SQL, distributed with Aqua Data Studio and DataDino). jTDS is also becoming a common choice for enterprise-level applications: it passes both the J2EE 1.3 certification and Hibernate test suites, and is recommended for JBoss, Hibernate, Atlassian JIRA and Confluence and Compiere. jTDS is free software. jTDS is released under the terms of the GNU LGPL, giving you not only the posibility to debug and tweak it to your own liking but also to use it in and distribute it with your free or commercial applications. The other "free" choices, the JDBC-ODBC bridge and Microsofts own JDBC driver are not actually free. If you encounter an issue with any of them you wont be able to fix it yourself and response times from both Microsoft and Sun are anything but short. Also, both of them lack functionality (the Microsoft driver implements JDBC 2.0, while the bridge is just a JDBC 1.0 implementation) and have serious stability problems: the bridge crashes the JVM if the ODBC driver has any problem and Microsoft just has no intention of really supporting Java/JDBC. jTDS is also the most performant JDBC driver for both SQL Server and Sybase. We have an older benchmark result but we strongly encourage you to download any benchmark published by commercial JDBC driver vendors and see for yourself. Here are a couple of benchmarks you could use: JNetDirects JDBC Performance Benchmark and i-net Softwares BenchTest 2.1 for MS SQL Server. Anyway, just give it a spin. Whats New in This Release: New features: &middot; Support for Sybase ASE 15 &middot; Improved support for SQL Server 2005 varchar(max) and varbinary(max) &middot; Complete handling of cursor exceptions and downgrading &middot; Better handling of cancels and timeouts &middot; Configurable socket timeout &middot; Subclasses of basic JDBC types recognized as setObject() values Major bug fixes (out of over 30 fixes): &middot; Statement pool memory leak &middot; Java 1.5 BigDecimal problems &middot; Possible synchronization problems &middot; setAutoCommit() behavior not according to specification &middot; getTimestamp() returns invalid value after calling getString() &middot; Cursor opens fails when cursor threshold <> -1 &middot; iso_1 charset and Sybase &middot; "All pipe instances are busy" not handled properly &middot; SSL fails with SQL Server 2005 &middot; Sybase: insert UTF8 string fails when length is 255.

Microsoft Sql Server - Sql Server - Type 4 - Microsoft Sql - Jdbc Driver - Jtds - Driver - Server - Microsoft - Sybase - Libraries - Programming

Published By:Alin Sinpalean

License Type:Freeware

Date Added:22 October, 2010

Version:1.2

Price:Free

Downloads:73

Size:460.8 KB

Platform: Linux

What people say
- required fields
     
Related Downloads

Cross database engine developer IDE for InterBase, SQL Server, Firebird, MySQL, Oracle, NexusDB, MSDE and Sybase SQL Anywhere. Database Workbench offers a single development environment for developing with multiple database engines.

DateApr 2, 2015

AuthorUpscene Productions

Size28.7 MB

LicenseShareware

Price$316.00

PlatformLinux, Windows Server, Linux Gnome, Mac OS X

CategoryLinux Business

Database Workbench Pro

StelsDBF is a DBF JDBC type 4 driver that allows to perform SQL queries and other JDBC operations on DBF files (dBase III/ IV/ V, xBase, FoxPro, FoxBase, Clipper).

DateOct 28, 2010

AuthorJ-Stels Software

Size235.5 KB

LicenseFreeware

PriceFree

PlatformLinux

CategoryLinux Programming

Caigen Access is a MDB (ACCDB) JDBC type 4 driver that allows to perform SQL operations on Microsoft Access database files .

DateSep 5, 2011

AuthorCaigen Software

Size2.0 MB

LicenseShareware

Price$149.00

PlatformLinux, Unix, Mac OS X, WinXP

CategoryLinux Programming

Pure Java Type 4 Cobol JDBC(1.2, 2.0, 3.0, 4.0) driver packages for Cobol data, whichs supports COBOL 68, COBOL 74, COBOL 1985, RM COBOL, MF COBOL, IBM COBOL, COBOL II, MS COBOL, Fujitsu COBOL, ACUCOBOL, CA Realia COBOL, Open Cobol, and so on.

DateSep 5, 2011

AuthorHongxin Technology & Trade Ltd.

Size968.6 KB

LicenseShareware

Price$285.00

PlatformLinux, Unix, Mac OS X, WinXP

CategoryLinux Programming

HXTT Cobol

Caigen CSV is a CSV JDBC type 4 driver that allows to perform SQL operations on raw data, flat text , CSV file, TSV file, PSV file, fixed-length, and variable-length binary file.

DateSep 5, 2011

AuthorCaigen Software

Size683.9 KB

LicenseShareware

Price$124.00

PlatformLinux, Unix, Mac OS X, WinXP

CategoryLinux Programming