JDBC Tutorials - Herong's Tutorial Examples - Version 3.03, by Dr. Herong Yang
Loading Driver Class with Class.forName()
This section provides a tutorial program on how to load Microsoft JDBC Driver 1.0 class explicitly using the Class.forName() method.
If you are using an older version of JDK, you need to load the JDBC driver class yourself. To do this you need to use the Class.forName() method to load the driver class, com.microsoft.sqlserver.jdbc.SQLServerDriver, which represents the Microsoft JDBC Driver.
Here is my sample program to load Microsoft JDBC Driver 4.2 class explicitly using the forName() method:
/* ConnectionTest1.java - Copyright (c) 2015, HerongYang.com, All Rights Reserved. */ import java.sql.*; public class ConnectionTest1 { public static void main(String [] args) { Connection con = null; try { // Load Microsoft JDBC Driver Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver"); System.out.println("JDBC driver loaded ok."); } catch (java.lang.ClassNotFoundException e) { System.err.println("ClassNotFoundException: " +e.getMessage()); } } }
Compile and run this program:
C:\herong>\Progra~1\java\jdk1.8.0_45\bin\javac ConnectionTest1.java C:\herong>\Progra~1\java\jdk1.8.0_45\bin\java ConnectionTest1 ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
I was getting this exception, because I forgot to add the JDBC driver jar file to the classpath in the "-cp" option. Here is the correct way to run this Java program with the JDBC driver jar file:
C:\herong>\Progra~1\java\jdk1.8.0_45\bin\java -cp .;\local\lib\sqljdbc42.jar ConnectionTest1 JDBC driver loaded ok.
Last update: 2015.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Java DB - Derby
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
MySQL JDBC Driver (MySQL Connector/J)
MySQL - Reference Implementation of JdbcRowSet
MySQL - JBDC CallableStatement
MySQL CLOB (Character Large Object) - TEXT
MySQL BLOB (Binary Large Object) - BLOB
Oracle Express Edition Installation on Windows
Oracle - Reference Implementation of JdbcRowSet
Oracle - JBDC CallableStatement
Oracle CLOB (Character Large Object) - TEXT
Oracle BLOB (Binary Large Object) - BLOB
Microsoft SQL Server 2005 Express Edition
►Microsoft JDBC Driver for SQL Server - sqljdbc42.jar
Installing Microsoft JDBC Driver for SQL Server
Loading Driver Class Automatically
►Loading Driver Class with Class.forName()
DriverManager.getConnection() and Connection URL
Enabling 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
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access
JDBC-ODBC Bridge Driver - MS SQL Server
Summary of JDBC Drivers and Database Servers