DBeaver-SystemUserConnection-Failure-Solution

[bshclosegrip]

• system 유저로 접속한 후 작업하기_21.04.02
  ALTER USER hr IDENTIFIED BY 1111;

• 계정에 LOCK이 걸린 경우
  ALTER USER hr account unlock;

package kr.jobtc.json;

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

public class DBconn {
	String driver = "oracle.jdbc.driver.OracleDriver";
	String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
	String user = "system";
	String pwd = "1234";
	Connection conn = null;
	
	public Connection getConn() {
		try {
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, pwd);
		} catch(Exception ex) {
			ex.printStackTrace();
		}
		return conn;	
	}
}