Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (102)
JavaBeans (21)
JDBC (121)
JDK (426)
JSP (20)
Logging (108)
Mail (58)
Messaging (8)
Network (84)
PDF (97)
Report (7)
Scripting (84)
Security (32)
Server (121)
Servlet (26)
SOAP (24)
Testing (54)
Web (15)
XML (322)
Collections:
Other Resources:
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();
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
2016-12-18, ∼2841🔥, 0💬
Popular Posts:
How to merge two JAR files with "jar" commands? I am tired of specifying multiple JAR files in the c...
JDK 11 jdk.jshell.jmod is the JMOD file for JDK 11 JShell tool, which can be invoked by the "jshell"...
JDK 17 java.rmi.jmod is the JMOD file for JDK 17 RMI (Remote Method Invocation) module. JDK 17 RMI m...
SLF4J API is a simple API that allows to plug in any desired logging library at deployment time. Her...
JDK 11 java.xml.jmod is the JMOD file for JDK 11 XML (eXtensible Markup Language) module. JDK 11 XML...