SqlServerJdbcUrl.java - sqljdbc JDBC Connection URL Example

Q

How to use port number and database name in the connection URL string for SQL Server database using the sqljdbc JDBC driver? I want to see a Java program example.

✍: FYIcenter.com

A

Here is a Java example that shows you how to specify port number, database name, and instance name in the connection URL string for SQL Server database using the sqljdbc JDBC driver:

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

// Example of sqljdbc JDBC connection URL
public class SqlServerJdbcUrl {
   public static void main(String [] args) throws Exception {

      // sqljdbc JDBC connection URL with required elements
      String url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();

      // sqljdbc JDBC connection URL with port number
      url = "jdbc:sqlserver://localhost:1433;user=sa;password=fyicenter";
      con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();

      // sqljdbc JDBC connection URL with database (catalog) name
      url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master";
      con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      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 
   SqlServerJdbcUrl.java

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

JDBC connection URL: 
   jdbc:sqlserver://localhost;user=sa;password=fyicenter
   Connected to: master

JDBC connection URL: 
   jdbc:sqlserver://localhost:1433;user=sa;password=fyicenter
   Connected to: master

JDBC connection URL: 
   jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master
   Connected to: master

Note that "master" is the default system database name in a newly installed SQL Server. You can create your database and change the JDBC connection to your database.

 

SQL Server Browser Service on Instances for sqljdbc Test

SqlServerJdbcConnection.java - sqljdbc JDBC Connection Example

Examples for sqljdbc - JDBC Driver for SQL Server

⇑⇑ FAQ for sqljdbc - JDBC Driver for SQL Server

2016-12-24, 1803🔥, 0💬