Create Connection With Properties : Connection « Database SQL JDBC « Java

Create Connection With Properties

import java.sql.Connection;
import java.sql.DriverManager;

public class TestCreateConnectionWithProperties_MySQL {

  public static final String DATABASE_USER = "user";

  public static final String DATABASE_PASSWORD = "password";

  public static final String MYSQL_AUTO_RECONNECT = "autoReconnect";

  public static final String MYSQL_MAX_RECONNECTS = "maxReconnects";

  public static Connection getConnection() throws Exception {
    String driver = "";
    // load the driver
    String dbURL = "jdbc:mysql://localhost/databaseName";
    String dbUsername = "root";
    String dbPassword = "root";

    java.util.Properties connProperties = new java.util.Properties();
    connProperties.put(DATABASE_USER, dbUsername);
    connProperties.put(DATABASE_PASSWORD, dbPassword);

    // set additional connection properties:
    // if connection stales, then make automatically
    // reconnect; make it alive again;
    // if connection stales, then try for reconnection;
    connProperties.put(MYSQL_AUTO_RECONNECT, "true");
    connProperties.put(MYSQL_MAX_RECONNECTS, "4");
    Connection conn = DriverManager.getConnection(dbURL, connProperties);
    return conn;

  public static void main(String[] args) {
    Connection conn = null;
    try {
      // get connection to an Oracle database
      conn = getConnection();
      System.out.println("conn=" + conn);
    } catch (Exception e) {
      // handle the exception
    } finally {
      // release database resources
      try {
      } catch (Exception ignore) {

Related examples in the same category

1.Connect to more than one database
2.Verify database setup
3.Debug Database connection
4.Set save point
5.JDBC Simple Connection
6.Load some drivers
7.Encapsulate the Connection-related operations that every JDBC program seems to use
8.Test of loading a driver and connecting to a database
9.Load MySQL JDBC Driver
10.Oracle JDBC Driver load
11.Oracle JDBC Driver load test: NewInstance
12.Test Register Oracle JDBC Driver
13.Install Oracle Driver and Execute Resultset
14.Test Thin Net8 App
15.Specify a CharSet when connecting to a DBMS
16.Listing All Available Parameters for Creating a JDBC Connection
17.String (Get name of property)
18.boolean java.sql.DriverPropertyInfo.required (Is property value required?)
19.String java.sql.DriverPropertyInfo.value (Get current value)
20.String java.sql.DriverPropertyInfo.description (Get description of property)
21.String[] java.sql.DriverPropertyInfo.choices (Get possible choices for property; if null, value can be any string)
22.Determining If a Database Supports Transactions
23.Committing and Rolling Back Updates to a Database
24.Disable auto commit mode in JDBC
25.Print warnings on a Connection to STDERR.
26.Print warnings on a Connection to a specified PrintWriter.
27.This program tests that the database and the JDBC driver are correctly configured.
28.Manage Db connections providing shortcuts for Statements, PreparedStatements and ResultSets.