sqljdbc JDBC getClientInfo() Method Not Supported

Q

Is the getClientInfo() method supported by sqljdbc JDBC driver?

✍: FYIcenter.com

A

No. The instance getClientInfo() method on java.sql.Connection interface is not supported by sqljdbc JDBC driver in all versions.

You can use the following Java example to test the getClientInfo() method:

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

// Demo of sqljdbc JDBC connection getClientInfo() not supported
public class SqlServerGetClientInfo {
   public static void main(String [] args) throws Exception {

      // sqljdbc JDBC connection URL with instance name appended to host name
      String url = "jdbc:sqlserver://localhost\\SQLEXPRESS;user=sa;password=fyicenter";
      Connection con = DriverManager.getConnection(url);
      System.out.println("JDBC connection URL: "+url); 
      System.out.println("   Connected to: "+con.getCatalog()); 
      
      con.setClientInfo("applicationName", "FYIcenter.com Test");
      System.out.println("   applicationName: "+con.getClientInfo("applicationName")); 
      
      System.out.println("All properties:"); 
      Properties list = con.getClientInfo();
      list.list(System.out);
      
      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 
   SqlServerGetClientInfo.java

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

JDBC connection URL: 
   jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=fyicenter
   Connected to: master
   applicationName: null
All properties:
-- listing properties --

This confirms that the sqljdbc JDBC driver does not support setClientInfo() and getClientInfo() methods.

 

sqljdbc JDBC getClientInfoProperties() Method Not Supported

SqlServerInstanceJdbcUrl.java - sqljdbc JDBC URL for Instance

Examples for sqljdbc - JDBC Driver for SQL Server

⇑⇑ FAQ for sqljdbc - JDBC Driver for SQL Server

2016-12-18, 2298🔥, 0💬