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:
JtdsSqlServerJdbcUrl.java - jTDS JDBC Connection URL Example
How to use port number, database name, and instance name in the connection URL string for SQL Server database using the jTDS 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 jTDS JDBC driver:
// Copyright (c) 2016 FYIcenter.com import java.sql.DriverManager; import java.sql.Connection; import java.sql.DatabaseMetaData; // Example of jTDS JDBC connection URL public class JtdsSqlServerJdbcUrl { public static void main(String [] args) throws Exception { // jTDS JDBC connection URL with required elements String url = "jdbc:jtds: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(); // jTDS JDBC connection URL with port number url = "jdbc:jtds: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(); // jTDS JDBC connection URL with database (catalog) name url = "jdbc:jtds:sqlserver://localhost/master;user=sa;password=fyicenter"; con = DriverManager.getConnection(url); System.out.println("JDBC connection URL: "+url); System.out.println(" Connected to: "+con.getCatalog()); con.close(); // jTDS JDBC connection URL with property "instance" url = "jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter;instance=EXPRESS"; 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 -cp C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerJdbcUrl.java C:\fyicenter>\local\jdk-1.8.0\bin\java -cp .;C:\local\jtds-1.3.1\jtds-1.3.1.jar JtdsSqlServerJdbcUrl JDBC connection URL: jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:jtds:sqlserver://localhost:1433;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:jtds:sqlserver://localhost/master;user=sa;password=fyicenter Connected to: master JDBC connection URL: jdbc:jtds:sqlserver://localhost;user=sa;password=fyicenter;instance=EXPRESS 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.
⇒ JtdsSqlServerCreateDatabase.java - jTDS JDBC Create Database
⇐ JtdsSqlServerJdbcConnection.java - jTDS JDBC Connection Example
2017-01-29, 2668🔥, 0💬
Popular Posts:
JasperReports, the world's most popular open source business intelligence and reporting engine and J...
iText is an ideal library for developers looking to enhance web- and other applications with dynamic...
How to perform XML Schema validation with sax\Writer.java provided in the Apache Xerces package? You...
ZooKeeper is a centralized service for maintaining configuration information, naming, providing dist...
What Is ojdbc8.jar for Oracle 12c R2? ojdbc8.jar for Oracle 12c R2 is the JAR files of ojdbc.jar, JD...