Note: Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview by Microsoft
In its continued commitment to interoperability, Microsoft has released a new Java Database Connectivity (JDBC) driver. The SQL Server JDBC Driver 2.0 download is available to all SQL Server users at no additional charge, and provides access to SQL Server 2000, SQL Server 2005, and SQL Server 2008 from any Java application, application server, or Java-enabled applet. This is a Type 4 JDBC driver that provides database connectivity through the standard JDBC application program interfaces (APIs) available in Java Platform, Enterprise Edition 5.
This Community Technology Preview (CTP) release of the JDBC Driver is JDBC 4.0 compliant and runs on the Java Development Kit (JDK) version 5.0 or later. It has been tested against all major application servers including BEA WebLogic, IBM WebSphere, and JBoss.
Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview
Abstract courtesy : Microsoft
Tips for Connecting With SQL Server JDBC Driver 2.0 and Later
A Type 4 driver is written fully in Java. You do not need native client libraries on the machine, which makes it easy to deploy on any operating system that runs Java. That was a big deal for teams running application servers on Linux or Unix while their database lived on Windows.
Most first connection problems are not about the driver at all. Here is what I check:
- TCP/IP is enabled for the instance in SQL Server Configuration Manager.
- The firewall allows the port, which is 1433 by default for a default instance.
- For a named instance, either give the port number in the connection URL or make sure the SQL Server Browser service is running.
- The login works with SQL Server authentication, unless you have set up Windows integrated authentication, which needs extra setup on the client.
A basic URL looks like jdbc:sqlserver://myserver:1433;databaseName=MyDb, and it is a good test before you add pooling or other settings.
This CTP is history now. Microsoft kept developing the driver, and today it is open source and available through Maven. Recent versions turn on encryption by default, so an old connection string may need a trusted certificate or an extra setting to connect.
Published by Pinal Dave on SQLAuthority. More of my work at pinaldave.com.
3 Comments. Leave new
hello pianl dave!
i have this driver and i connected java and my ms sql server2008 but when i rty to querying the db from the java code for ex:
ResultSet rSet = state.executeQuery(“select * from dbo.categories”);
it wont display the fields or any data,
don’t know where is the problem,
Did you get any error?
no i didn’t get, i use netbeans 6.9.1
i don’t have any problem when i use embed database,
is it possible that the db have problem?