Create Connection With Properties
import java.sql.Connection; import java.sql.DriverManager; publicclass TestCreateConnectionWithProperties_MySQL { publicstaticfinal String DATABASE_USER = "user"; publicstaticfinal String DATABASE_PASSWORD = "password"; publicstaticfinal String MYSQL_AUTO_RECONNECT = "autoReconnect"; publicstaticfinal String MYSQL_MAX_RECONNECTS = "maxReconnects"; publicstatic 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; } publicstaticvoid 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
