Categories:
Audio (13)
Biotech (29)
Bytecode (36)
Database (77)
Framework (7)
Game (7)
General (507)
Graphics (53)
I/O (35)
IDE (2)
JAR Tools (101)
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 (309)
Collections:
Other Resources:
SqlServerInstanceJdbcUrl.java - sqljdbc JDBC URL for Instance
How to use instance name instead of port number in the connection URL string for a specific SQL Server database instance using the sqljdbc JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
If your SQL Server is running multiple instances on a single host, and the SQL Server Browser service is running to serve instance name to port number conversion, you can following the Java example below specify instance name instead of port number in the connection URL string using the sqljdbc JDBC driver:
// Copyright (c) 2016 FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; // Example of sqljdbc JDBC connection URL public class SqlServerInstanceJdbcUrl { public static void main(String [] args) throws Exception { // sqljdbc JDBC connection URL to the default instance String url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter"; Connection con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // sqljdbc JDBC connection URL with instance name appended to host name url = "jdbc:sqlserver://localhost\\SQLEXPRESS;user=sa;password=fyicenter"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // sqljdbc JDBC connection URL with instance name as a property url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter;instanceName=SQLEXPRESS"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); 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 SqlServerInstanceJdbcUrl.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar SqlServerInstanceJdbcUrl JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost\SQLEXPRESS;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter;instanceName=SQLEXPRESS Connected to: master
⇒ sqljdbc JDBC getClientInfo() Method Not Supported
⇐ SQL Server Browser Service on Instances for sqljdbc Test
2016-12-24, 1704🔥, 0💬
Popular Posts:
JDK 11 jdk.localedata.jmod is the JMOD file for JDK 11 Localedata module. JDK 11 Locale Data module ...
The Digester package lets you configure an XML -> Java object mapping module, which triggers certain...
How to read XML document from socket connections with the socket\DelayedInput.java provided in the A...
JDK 17 jdk.hotspot.agent.jmod is the JMOD file for JDK 17 Hotspot Agent module. JDK 17 Hotspot Agent...
The Web Services Description Language for Java Toolkit (WSDL4J), Release 1.6.2, allows the creation,...