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:
SqlServerJdbcUrl.java - sqljdbc JDBC Connection URL Example
How to use port number and database name in the connection URL string for SQL Server database using the sqljdbc JDBC driver? I want to see a Java program example.
✍: FYIcenter.com
Here is a Java example that shows you how to specify
port number, database name, and instance name
in the connection URL string for SQL Server database 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 SqlServerJdbcUrl { public static void main(String [] args) throws Exception { // sqljdbc JDBC connection URL with required elements 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 port number url = "jdbc:sqlserver://localhost:1433;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 database (catalog) name url = "jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master"; 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 SqlServerJdbcUrl.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\sqljdbc_6.0\enu\sqljdbc42.jar SqlServerJdbcUrl JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost:1433;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:sqlserver://localhost;user=sa;password=fyicenter;database=master Connected to: master
Note that "master" is the default system database name in a newly installed SQL Server. You can create your database and change the JDBC connection to your database.
⇒ SQL Server Browser Service on Instances for sqljdbc Test
⇐ SqlServerJdbcConnection.java - sqljdbc JDBC Connection Example
2016-12-24, 1867🔥, 0💬
Popular Posts:
What Is commons-net-ftp-2.0.jar? commons-net-ftp-2.0.jar is the JAR file for Apache Commons Net FTP ...
ASM is an all purpose Java bytecode manipulation and analysis framework. It can be used to modify ex...
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 ...
JDK 11 jdk.internal.JVM Stat.jmod is the JMOD file for JDK 11 Internal Jvmstat module. JDK 11 Intern...
Guava is a suite of core and expanded libraries that include utility classes, google's collections, ...