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, 1742🔥, 0💬
Popular Posts:
What is the sax\Counter.java provided in the Apache Xerces package? I have Apache Xerces 2.11.0 inst...
Java Architecture for XML Binding (JAXB) is a Java API that allows Java developers to map Java class...
commons-io-2.6-sources.j aris the source JAR file for Apache Commons IO 2.6, which is a library of u...
What Is jtds-1.2.2.jar? jtds-1.2.2.jar is the JAR files of jTDS Java library 1.2.2, which is a JDBC ...
What Is jsse.jar (JDK 6) Java Secure Socket Extension? jsse.jar, Java Secure Socket Extension, is Ja...