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, 2751🔥, 0💬
Popular Posts:
JDK 17 java.desktop.jmod is the JMOD file for JDK 17 Desktop module. JDK 17 Desktop module compiled ...
What Is javamail-1_2.zip? javamail-1_2.zip is the binary package of JavaMail API 1.2 in ZIP format. ...
Where to find answers to frequently asked questions on Downloading and Using JDK (Java Development K...
Apache ZooKeeper is an open-source server which enables highly reliable distributed coordination. Ap...
JavaMail Source Code Files are provided in the source package file, httpcomponents-client-5. 2-src.zi...