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 getClientInfoProperties() Method Not Supported
Is the getClientInfoProperties() method supported by sqljdbc JDBC driver?
✍: FYIcenter.com
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
2016-12-18, ∼2571🔥, 0💬
Popular Posts:
maven-model-builder-3.5. 4.jaris the JAR file for Apache Maven 3.5.4 Model Builder module. Apache Ma...
What is the jaxp\TypeInfoWriter.java provided in the Apache Xerces package? I have Apache Xerces 2.1...
JDK 11 jrt-fs.jar is the JAR file for JDK 11 JRT-FS (Java RunTime - File System) defined in the "jdk...
What Is poi-scratchpad-3.5.jar? poi-scratchpad-3.5.jar is one of the JAR files for Apache POI 3.5, w...
JDK 11 jdk.crypto.mscapi.jmod is the JMOD file for JDK 11 Crypto MSCAPI module. JDK 11 Crypto MSCAPI...