sqljdbc JDBC getClientInfoProperties() Method Not Supported

Q

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

✍: FYIcenter.com

A

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

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

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

// Demo of sqljdbc JDBC connection getClientInfoProperties() not supported
public class SqlServerGetClientInfoProperties {
   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()); 
      
      System.out.println("All properties:"); 
      DatabaseMetaData meta = con.getMetaData();
      ResultSet rs = meta.getClientInfoProperties();
      while (rs.next()) {
         System.out.println("      "+rs.getInt("NAME")+", "
            +rs.getString("DESCRIPTION"));
      }
      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 
   SqlServerGetClientInfoProperties.java

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

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

This confirms that the sqljdbc JDBC driver does not support the getClientInfoProperties() method.

 

SqlServerCreateDatabase.java - sqljdbc JDBC Create Database

sqljdbc JDBC getClientInfo() Method Not Supported

Examples for sqljdbc - JDBC Driver for SQL Server

⇑⇑ FAQ for sqljdbc - JDBC Driver for SQL Server

2016-12-18, 1886🔥, 0💬