Creating Connections with DataSource Class

MySQL Tutorials - Herong's Tutorial Examples

∟Creating Connections with DataSource Class

Describes how to create connection objects with the DataSource class.

Newer version of JDBC recommends now that connection objects should be created by the DataSource implementation classes:

// MySQL Connector/J 8.0.17
com.mysql.cj.jdbc.MysqlDataSource

// MySQL Connector/J 5.1.38
com.mysql.jdbc.jdbc2.optional.MysqlDataSource

Here is a sample program that creates a connection object using the DataSource class:

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

// Setting up the DataSource object
      // For MySQL Connector/J 5.1.38
      // com.mysql.jdbc.jdbc2.optional.MysqlDataSource ds
      //   = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource();

      // For MySQL Connector/J 8.0.17
      com.mysql.cj.jdbc.MysqlDataSource ds
        = new com.mysql.cj.jdbc.MysqlDataSource();

      ds.setServerName("localhost");
      ds.setPortNumber(3306);
      ds.setDatabaseName("test");
      ds.setUser("root");
      ds.setPassword("TopSecret");

// Getting a connection object
      con = ds.getConnection();

// Getting database info
      DatabaseMetaData meta = con.getMetaData();
      System.out.println("Server name: "
        + meta.getDatabaseProductName());
      System.out.println("Server version: "
        + meta.getDatabaseProductVersion());

// Closing the connection
      con.close();
    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

The output below confirms that I got a good connection. Remember to include mysql-connector-java-8.0.17.jar in the classpath for compilation and execution:

herong> javac -cp .;\local\lib\mysql-connector-java-8.0.17.jar
  MySqlDataSource.java

herong> java -cp .;\local\lib\mysql-connector-java-8.0.17.jar
  MySqlDataSource

Server name: MySQL
Server version: 8.0.16

Here is output when I ran the test with the com.mysql.jdbc.jdbc2.optional.MysqlDataSource implementation class and MySQL Connector/J 5.1.38:

herong> javac -cp .;\local\lib\mysql-connector-java-5.1.38-bin.jar
  MySqlDataSource.java

herong> java -cp .;\local\lib\mysql-connector-java-5.1.38-bin.jar
  MySqlDataSource

Server name: MySQL
Server version: 5.7.10-log