SqlServerJdbcConnection.java - sqljdbc JDBC Connection Example

Q

How to create a JDBC connection to SQL Server database using the sqljdbc JDBC driver? I want to see a Java program example.

✍: FYIcenter.com

A

If you have a SQL Server running on your local computer with TCP/IP protocol turned on and listening on port 1433, you can use the following example, SqlServerJdbcConnection.java, to learn how to create a JDBC connection:

// Copyright (c) 2016 FYIcenter.com
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.DatabaseMetaData;

// Example of sqljdbc JDBC connection to SQL Server
public class SqlServerJdbcConnection {
   public static void main(String [] args) throws Exception {

      // Build the sqljdbc JDBC connection URL
      String url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter";
      Connection con = DriverManager.getConnection(url);
      
      System.out.println("JDBC connection and database server information:"); 
      DatabaseMetaData meta = con.getMetaData();
      System.out.println("Database Product Name: "
        + meta.getDatabaseProductName());
      System.out.println("Database Product Version: "
        + meta.getDatabaseProductVersion());
      System.out.println("Driver Name: "
        + meta.getDriverName());
      System.out.println("Driver Version: "
        + meta.getDriverVersion());
      System.out.println("JDBC Major Version: "
        + meta.getJDBCMajorVersion());
      System.out.println("JDBC Minor Version: "
        + meta.getJDBCMinorVersion());

      // Close the connection
      con.close();
   }
}

You can compile and run the above example in a command window as shown below:

C:\fyicenter>\local\jdk-1.8.0\bin\javac 
   SqlServerJdbcConnection.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar
   SqlServerJdbcConnection

JDBC connection and database server information:
Database Product Name: Microsoft SQL Server
Database Product Version: 12.00.2000
Driver Name: Microsoft JDBC Driver 6.0 for SQL Server
Driver Version: 6.0.7728.100
JDBC Major Version: 4
JDBC Minor Version: 2

The output confirms that:

  • The database server is SQL Server 2014 (Version 12).
  • The JDBC driver is sqljdbc 6.0.
  • The JDBC API supported is JDBC 4.2.

 

Examples for sqljdbc - JDBC Driver for SQL Server

⇒⇒FAQ for sqljdbc - JDBC Driver for SQL Server

2016-12-24, 233👍, 0💬