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

1. Java
2. Database SQL JDBC
3. Connection

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 = "org.gjt.mm.mysql.Driver";
    // load the driver
    Class.forName(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
      e.printStackTrace();
      System.exit(1);
    } finally {
      // release database resources
      try {
        conn.close();
      } catch (Exception ignore) {
      }
    }
  }
}
           
         
    
    
    
  

Related examples in the same category