JtdsSqlServerJdbcUrl.java - jTDS JDBC Connection URL Example

Q

How to use port number, database name, and instance name in the connection URL string for SQL Server database using the jTDS 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 jTDS JDBC driver:

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

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

      // jTDS JDBC connection URL with required elements
      String url = "jdbc:jtds: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();

      // jTDS JDBC connection URL with port number
      url = "jdbc:jtds: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();

      // jTDS JDBC connection URL with database (catalog) name
      url = "jdbc:jtds:sqlserver://localhost/master;user=sa;password=fyicenter";
      con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      con.close();

      // jTDS JDBC connection URL with property "instance"
      url = "jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter;instance=EXPRESS";
      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 
   -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar 
   JtdsSqlServerJdbcUrl.java

C:\fyicenter>\local\jdk-1.8.0\bin\java
   -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar 
   JtdsSqlServerJdbcUrl

JDBC connection URL: 
   jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter
   Connected to: master
   
JDBC connection URL: 
   jdbc:jtds:sqlserver://localhost:1433;user=sa;password=fyicenter
   Connected to: master
   
JDBC connection URL: 
   jdbc:jtds:sqlserver://localhost/master;user=sa;password=fyicenter
   Connected to: master
   
JDBC connection URL: 
   jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter;instance=EXPRESS
   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.

 

Examples for jTDS - JDBC Driver for SQL Server

⇒⇒FAQ for jTDS - JDBC Driver for SQL Server

2017-01-29, 969👍, 0💬