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

The fastest, most reliable way to access Microsoft SQL Server.- 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 Features PDF Print E-mail

NEW: JSQLConnect 6.0 - Now SQL Server 2008 R2 Compliant.

JNetDirect remains committed to providing the industry's best support for Java connectivity for Microsoft SQL Server products.  JSQLConnect is a robust type 4 driver that currently executes millions of transactions daily for SQL Server applications worldwide.  No other product offers the breadth of support for Microsoft SQL Server and the commitment to JDBC standards as JSQLConnect.

Capable for providing database access for any sized enterprise, JSQLConnect includes Trusted Authentication for Microsoft Windows 2000 and NT 4.0 user accounts, pre-verified connection pools, distributed transactions and secure JDBC/HTTP firewall tunneling.

FEATURES:

JNetDirect has dramatically extended the capabilities of JSQLConnect.  These features allow you to enhance your application's ability to leverage additional security, performance and distributed transaction facilities within Microsoft SQL Server and your application server.  These facilities include firewall tunneling, trusted authentication, pre-verified connection pools and distributed transactions with the Microsoft Distributed Transaction Coordinator.

JSQLConnect can use integrated Windows Authentication mode to connect through a Microsoft Windows Windows 2000 or NT 4.0 user account.  Provides increased security via your Windows domain controller.  Avoids configuring and using additional user names and passwords and exposing them in configuration files.

JSQLConnect managed connection pools pre-verify each logical connection issued to your application.  Pre-verification means that connection pool remains valid after a database restart since stale connections are removed from the connection pool.

JSQLConnect provides seamless integration with Microsoft Distributed Transaction Coordinator.  DTC uses proven transaction processing technology from Microsoft to support XA features such as the complete two-phase distributed commit protocol and the recovery of distributed transactions.

 

Feature Summary
Full JDBC 4.0 Implementation Full Unicode Support Optimistic and Pessimistic Conncurrency
SQL Server 2008 R2, 2008, 2005,
2000, 7.0, 6.5 compliant
Updateable Result Sets Support for all popular Java IDE's
Sun Certified for J2EE Scrolling Server Side Result Sets Complete Driver logging and tracing
Sun Certified 100% Pure Java Scrolling Client Side Result Sets Full Timeout Support
Solaris, Linux, Windows Compliant Full Range of Cursor Types SQL Server Condition Codes in SQLExceptions
JDK 1.4, 1.3 and 1.2 Compliant True XA Support via MS-DTC NTEXT, NCHAR and NVARCHAR Support
64 Bit Support Secure Connections via SSL NTLM Authentication
Optimized Native Protocol Performance Full BLOB and CLOB Support Unlimited Statements per Connection


J2EE Support
JNDI Data Sources Connection Pooling XA Distributed Transactions

 

More details about advanced features.

 

English Chinese (Traditional) French German Italian Korean Portuguese Russian Spanish