The Artima Developer Community
Sponsored Link

Java Community News
Microsoft Releases New JDBC Driver for SQLServer

1 reply on 1 page. Most recent reply: Nov 1, 2007 2:56 AM by Infernoz Infernoz

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 1 reply on 1 page
Frank Sommers

Posts: 2642
Nickname: fsommers
Registered: Jan, 2002

Microsoft Releases New JDBC Driver for SQLServer Posted: Oct 18, 2007 2:14 PM
Reply to this message Reply
Summary
Microsoft released an update to its freely distributable JDBC driver for the SQLServer database engine. The new driver includes a re-architected communication stack aimed to significantly boost performance for enterprise Java applications.
Advertisement

Microsoft released a new version of the JDBC driver for its SQLServer database engine. The new driver provides a Type 4 JDBC interface to the latest version of SQLServer, and supports JDK releases above 1.4:

In this release we re-architected the communication stack resulting in significant performance and scalability improvements, as well as minimizing the driver memory footprint usage, especially with multiple active connections and result sets. These enhancements are most visible when the "responseBuffering=adaptive" connection property is used. The driver now supports SQL Server SSL encryption as part of our continual commitment to security.

Additional features of this release include:

  • Adaptive Buffering:
    The JDBC driver now provides an adaptive buffering feature, which is designed to retrieve any kind of large-value data without the overhead of server cursors.... The JDBC driver provides a new responseBuffering property and new streaming getter methods as part of this feature... The new getStream methods support the large value OUT parameters...
  • SSL Encryption:
    The JDBC driver now provides Secure Sockets Layer (SSL) encryption to secure the communication channel with SQL Server database... The JDBC driver provides new connection properties and new getter and setter methods as part of this feature. New connection properties are: encrypt, trustServerCertificate, trustStore, trustStorePassword, and hostNameInCertificate.
  • Tightly Coupled XA Transactions:
    The JDBC driver now provides a SSTRANSTIGHTLYCPLD flag to allow the applications to use the tightly coupled XA transactions, which have different XA branch transaction IDs (XIDs) but have the same global transaction ID (GTRID).

What do you think of SQLServer as a database for enterprise Java applications?


Infernoz Infernoz

Posts: 6
Nickname: infernoz
Registered: Nov, 2005

This should be irrelevant, OSS DB devs! Posted: Nov 1, 2007 2:56 AM
Reply to this message Reply
Unfortunately MS SQLServer is often chosen, for the following reasons:

1. It is free for <4GB, not that expensive for commercial use and has excellent database management tools e.g. it is piss easy to copy part or all of a database to other databases, on other machines, using enterprise manager (listening OSS tools ppl)!
2. Many people don't know or care that MS SQLServer can be a bloody pain for locking conflicts, Arghhh! Developers accept this, then don't allow for it, WTF! Are they morons?
3. Oracle is way too expensive despite being good and appears to have some really stupid enterprise/stand-alone management flaws.
4. MySQL looks too expensive for too little (for commercial licences), it is not a proper enterprise database and has amateurish database management tools.
5. Many people don't know that the impressive PostgreSQL exists, however it still has less capable management tools than MS SQLServer (getting better though).

I would really like the OSS database community to get a bloody-big world-of-hurt fire lit under them until they provide <i>decent, free, true enterprise level</i> database management tools for OSS databases, so that MS SQLServer can be dumped.

OSS DB guys, learn from the Linux mistakes, be a lot better than Microsoft, not chase them, both for the product core (PostgreSQL) and the tools (OSS not good enough yet), no weird or *nix terminal style GUIs, please!

Flat View: This topic has 1 reply on 1 page
Topic: Tom: A Pattern-Matching Compiler for Java Previous Topic   Next Topic Topic: Neal Gafter Releases First Java Closures Prototype

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use