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, 1817🔥, 0💬
Popular Posts:
The Digester package lets you configure an XML -> Java object mapping module, which triggers certain...
Jetty provides an HTTP server, HTTP client, and javax.servlet container. These components are open s...
What Is ojdbc5.jar for Oracle 11g R1? ojdbc5.jar for Oracle 11g R1 is the JAR files of ojdbc.jar, JD...
What Is mail.jar of JavaMail 1.4? I got the JAR file from javamail-1_4.zip. mail.jar in javamail-1_4...
JDOM provides a solution for using XML from Java that is as simple as Java itself. There is no compe...