sqljdbc JDBC getClientInfo() Method Not Supported


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

✍: FYIcenter.com


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();

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


   -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar 

JDBC connection URL: 
   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💬