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
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
jTDS is the most performant JDBC driver for both Microsoft SQL Server and Sybase. It is a complete implementation of JDBC 3.0, 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.
For more information on jTDS see http://jtds.sourceforge.net/
The release can be downloaded from: