Featured Solution

Eliminate forgotten Active Directory user passwords with our Windows integrated and web-based platform, Password Reset Server. All employees can now securely reset their own Active Directory password through a series of secure questions. Learn More...

JSQLConnect 7.0

Thousands of companies worldwide depend on JSQLConnect. Download trial and see why! Learn More...

Global Customer Base

Over 4000 organizations worldwide rely on JNetDirect's software and services. See what JNetDirect can do for your organization. 

JDBC Connectivity

JNetDirect leads the industry in providing a range of high performance, full featured & scalable JDBC solutions.

SQL Locator

Unique productivity tool that can change how you view your data. Learn More...

Combine

Take control of your database environments. Learn More...

JSQLConnect Driver PDF Print E-mail

JSQLConnect Version 7.0 Released!

JSQLConnect 7.0 is fully compatible with the recently released SQL Server ’12 and takes advantage of the new features available in the Microsoft product while maintaining high performance and reliability.

Version 7.0 continues the close working relationship between Microsoft SQL Server development and the JNetDirect programming team. In addition to compatibility with the new version of SQL Server, JSQLConnect has incorporated several new features in version 2012 including:

  • Implemented ReadOnly Intent Support

AlwaysOn Availability Groups, introduced in SQL Server 2012, is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. One of its benefits is to configure a given availability replica to support Read-only connection access. "Using active secondary capabilities improves your IT efficiency and reduces cost through better resource utilization of secondary hardware. In addition, offloading read-intent applications and backup jobs to secondary replicas helps to improve performance on the primary replica." (See http://msdn.microsoft.com/en-us/library/hh510230%28v=sql.110%29.aspx for more details)

  • Routing Support

Availability Group Listeners is another new feature in SQL Server 2012. The Listeners routes incoming connections to a suitable replica.”An Availability Group Listener is a virtual network name (VNN) to which clients can connect in order to access a database in a primary or secondary replica of an AlwaysOn Availability Group. An Availability Group Listener enables a client to connect to an availability replica without knowing the name of the physical instance of SQL Server to which the client is connecting. The client connection string does not need to be modified to  connect to the current location of the current primary replica.” (Seehttp://msdn.microsoft.com/en-gb/library/hh213417%28v=sql.110%29.aspx for more details)

  • Added transaction isolation level SNAPSHOT support

This new feature is important for projects that use frameworks with transaction management support. We have added a constant for the fifth isolation level 'SNAPSHOT' and moreover a driver property that enables 'use SNAPSHOT instead of TRANSACTION_REPEATABLE_READ mode'. In this case a call of setTransactionIsolation (Connection. TRANSACTION_REPEATABLE_READ) would be interpreted as setting the isolation level to snapshot.

 

View the key JSQLConnect 7.0 new features.

JSQLConnect is the fastest, most reliable way to access Microsoft SQL Server products from Java applications. In addition to being SQL Server 2012 and 2008 R2 compliant, JSQLConnect supports Microsoft SQL Server 2008, Microsoft SQL Server 2005, and Microsoft SQL Server 2000 with the latest JDBC capabilities.

JSQLConnect is a high performance, native type 4 JDBC driver providing comprehensive JDBC 4.0 support for Microsoft SQL Server. It allows for quick access to Microsoft SQL Server from Java applications, Servlets, EJBs, JSPs, and applets.

Evaluate JSQLConnect today with a fully-functional trial download freely accessible to test within your application.

 

FREE JSQLConnect Single Open License
JSQL for Everyone - JSQLConnect is available for free to anyone needing a fast and stable single connection to Microsoft SQL Server. The free Single License, downloadable after registering, is perfect for students, developers, or anyone looking to access Microsoft SQL Server with Java and JDBC. The JSQLConnect Single License can be used on any Java-enabled computer.

JSQLConnect is also offered as a Group License (3 connections); as a Business License (unlimited connections) or an Enterprise / OEM (embedded) version. A free trial version is downloadable after registering.

 JSQLConnect - The Most Reliable JDBC Driver for Microsoft SQL Server

Top 3 of the many reasons JSQLConnect leads the pack in the JDBC drivers arena:

  • Performance
    Significantly better performance than Data Direct's JDBC Driver and the “free” drivers.
  • JDBC 4.0 XML Feature
    Supports the XML features of the JDBC 4.0 specification while Microsoft’s SQL Server Driver does not.
  • Continuous Support and Development
    No stale driver here! JSQLConnect 6.06 was just released and we stay current with the latest MS SQL Server developments.  Check the last release date for those other drivers you are testing.

Evaluate JSQLConnect today with a fully-functional trial download freely accessible to test within your application. Compare performance against your current driver with our free JDBC Performance Benchmark. Purchase a license online at our secure online store or contact a JNetDirect sales representative for a custom quote.

 

(* Note: SQL Server and Data Direct are registered trademarks of Microsoft Inc. and Progress Software Corporation respectively).