Incorrect Database Name in Connection URL

JDBC Tutorials - Herong's Tutorial Examples - Version 3.03, by Dr. Herong Yang

JDBC Tutorials - Herong's Tutorial Examples

∟Microsoft JDBC Driver for SQL Server - sqljdbc42.jar

∟Incorrect Database Name in Connection URL

This section describes what will happen if incorrect database names specified in the connection URL.

If you selected a wrong database, or the login name has no access to that database, getConnection() method will throw a SQLExection object for you to catch. In this case, the getMessage() method of the SQLExection object will give you the detailed error message.

The tutorial program below shows you an example of the SQLException resulting from a wrong database name in the connection URL:

/* WrongDatabase.java
 - Copyright (c) 2015, HerongYang.com, All Rights Reserved.
 */
import java.sql.*;
public class WrongDatabase {
  public static void main(String [] args) {
    Connection con = null;
    try {

// Obtaining a connection to SQL Server
      con = DriverManager.getConnection(
          "jdbc:sqlserver://localhost\\SQLEXPRESS;"
        + "user=sa;password=HerongY@ng;"
        + "database=AdventureWorksWrong");

      con.close();        
    } catch (SQLException e) {
      System.err.println("SQLException: "
        +e.getMessage());
    }
  }
}

You will get the following message, if you run it with JDK 1.8, JDBC Driver 4.2 and SQL Server 2014:

C:\herong>\Progra~1\java\jdk1.8.0_45\bin\java 
   -cp .;\local\lib\sqljdbc42.jar WrongDatabase

SQLException: Cannot open database "AdventureWorksWrong" requested by
the login. The login failed. ClientConnectionId:
d72c009b-1cf0-425d-b315-2d7618a5df26

The error message is not so accurate. The login was correct. The select database operation was failed, because database "AdventureWorksWrong" does not exist on the SQL Server.

Last update: 2015.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Java DB - Derby

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Java DB (Derby) - DML Statements

Java DB (Derby) - ResultSet Objects of Queries

Java DB (Derby) - PreparedStatement

MySQL Installation on Windows