JSQLConnect is the fastest, most reliable way to access Microsoft SQL Server products from your Java, .JSP or J2EE applications. 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 and 3.0 support for Microsoft SQL Server. Quickly access Microsoft SQL Server from Java applications, Servlets, EJBs, JSPs and applets. JSQLConnect is Sun certified J2EE 1.4 compliant.

What's New in JSQLConnect

• Enhanced BigDecimal Handling - JSQLConnect contains a new JSQLBigDecimal class which will translate all incoming BigDecimal values to ensure compliance with SQL Server limitations. This new class allows developers to pass any precision or scale BigDecimal value regardless of construction into SQL Server.
• Improved Network Packet Size options - JSQLConnect provides a connection option which allows developers to tailor their application specific usage with more efficiency and robustness. The packetSize options defaults to 8000 and can be set to any size supported by SQL Server.
• Updated to Java - With Java 1.4 reaching End of Life, JSQLConnect now requires a minimum runtime of Java5. In addition, support and inclusion of JDBC2.0 has been removed. Customers requiring Java1.4 or JDBC2.0 can still request a custom solution through JNetDirect Support.
• New IPv6 Address Support - JSQLConnect provide full resolution of host names via IPv6 naming conventions automatically.
• XML Features - JSQLConnect supports the new XML features of the JDBC 4.0 specification. In addition, XML content handling in JSQLConnect is compatible with the new Streaming API for XML (StAX). StAX is a groundbreaking new Java API for parsing and writing XML easily and efficiently. StAX lets developers process XML in a stream oriented fashion without having to deal with the complexity of working with low level StAX streams. StAX also provides an alternative to using the resource-intensive DOM XML processing model. JSQLConnect allows developers to create SQLXML objects at the connection level that can store and retrieve XML content to columns within database tables. SQLXML objects can be directly stored to or retreived from the database using regular JDBC statements, prepared statements, result sets and callable procedures. SQLXML types can generally be used in JDBC API's wherever traditional JDBC types are allowed. For example, SQLXML objects can be specified as parameters for prepared statements or as parameters for callable procedures. SQLXML objects can be set simply with XML string values or populated using the various stream methods of the StAX XMLStreamWriter API. JSQLConnect allows developers to read XML contents from columns in the database as SQLXML objects. XML may be returned as Strings or StAX XMLStreamReader streams.
• BLOB/CLOB Upgrades - Instances of the BLOB and CLOB data types can now be created directly from a JDBC connection. Previously BLOB and CLOB could only be instanced from database resident data. BLOBs and CLOBs that are instantiated from a connection can be be subsequently used with any BLOB/CLOB JDBC API. For example they can be used as prepared statement parameters.
• Connection Management - The connecton level isValid() API is now supported. IsValid provides a realtime, programmable check of the underlying connection's validity by confirming that a small packet can successfully make a full round trip to the database. IsValid() can be used in a number of scenarios to determine connection viability. For example, it can be used to guarantee connection validation in a custom connection pool implementation. Applications may now use the new connection-level clientInfo API to set custom properties on a connection. An example of a custom property is the application name. The application name property can be be used by system administrators to analyse database activity generated by a specific client or group of clients.
• Server Provider Compliance - JSQLConnect supports the new Java Standard Edition Service Provider mechanism. An application no longer needs to explictly load the JSQLConnect driver using Class.forName(). Existing programs which currently the driver using Class.forName() will continue to work without modification.
• Statement Pooling - JSQLConnect supports the new prepared statement pooling API in JDBC 4.0 that allow statement pool implementations to gain more control over managed statements. Pool managers may now control objects at the level of statement granularity to attain more precise pool management.
• Secure Connections - JSQLConnect provides encrypted connections via SSL to secure instances of SQL Server. The driver also provides the ability to query a SQL Server instance to determine whether it supports secure connections and if it requires secure connections for all client access. Secure connections are available in a range of highly secure cipher suites. Applications can enable secure connections by simply setting a connection property - no coding changes will be required.
• NTLM Authentication - JSQLConnect provides database authentication using Microsoft's integrated NTLM challenge/response authentication protocol. NTLM authentication provides integrated and secure authentication within a Windows domain environment. Integrated authentication provides a number of additional advantages over SQL Server authentication such as the implementation of account policies enforcing password complexity, maximum and minimum age, history, as well as lockout settings.
• Support for WebSphere 5.0 and 6.0 - JSQLConnect provides enhanced support for IBM's Websphere 5.0 and 6.0 application servers by shipping with a customized data store helper that will be used by the Websphere relational resource adapter runtime. The JSQLConnect data store helper provides driver specific information to Websphere that optimizes driver performance in areas such as statement and connection pooling, driver meta data support, target database capabilities and error handling.

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.