JDBC for SQL Server - Herong's Tutorial Examples - v3.14, by Herong Yang
Specifying Database Name in Connection URL
This section describes how to specify database name in connection URL.
When you create a connection object to a SQL Server without specifying any database name, the SQL Server will connect you to the default database that is linked to the login name. For example, "master" is the default database for login name "sa". If you create a connection with "sa" login name, the connection will be linked to "master" database.
If you want to work with a different database, you must specify the database name in the connection url in the following syntax:
jdbc:sqlserver://server_name:port;database=name;...
The tutorial program below shows you how to connect to the local SQL Server and select the sample database "AdventureWorks2014" as the working database.
/* SelectDatabase.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*; public class SelectDatabase { public static void main(String [] args) { Connection con = null; try { // Obtaining a connection to SQL Server con = DriverManager.getConnection( "jdbc:sqlserver://localhost\\SQLEXPRESS;" + "user=herong;password=T0pSecret;" + "database=AdventureWorks2019"); // Checking the database name Statement sta = con.createStatement(); ResultSet res = sta.executeQuery("SELECT DB_NAME()"); res.next(); String name = res.getString(1); System.out.println("Connected to database: "+name); con.close(); } catch (Exception e) { e.printStackTrace(); } } }
The program output will confirm you that the database is selected correctly.
herong> java -cp .;mssql-jdbc-9.4.1.jre16.jar SelectDatabase.java Connected to database: AdventureWorks2019
Table of Contents
JDBC (Java Database Connectivity) Introduction
Microsoft SQL Server Express Edition
►Microsoft JDBC Driver for SQL Server
Installing Microsoft JDBC Driver for SQL Server
Loading Driver Class Automatically
Loading Driver Class with Class.forName()
DriverManager.getConnection() and Connection URL
Enable TCP/IP with SQL Server Configuration Manager
Specifying Port Number in Connection URL
Instance Name Better than Port Number
Specifying Instance Name in Connection URL
Closing the Database Connection - con.close()
►Specifying Database Name in Connection URL
Incorrect Database Name in Connection URL
Creating Connections with DataSource Class
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
Using Connection Pool with JDBC
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access