Oracle JDBC 접속 테스트 하기

JDBC 드라이버를 이용하여 접속 테스트 하기

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ page language="java" import="java.sql.*" %>
 
<%
String url = "jdbc:oracle:thin:@211.58.154.212:1521:test";
//String url = "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=211.58.154.212)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=test)(SERVER=DEDICATED)))";
String user = "apps";
String pwd = "apps";
 
Connection conn = null;
 
try  {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    out.println("드라이버 로딩 성공");
    out.println("<br /><br />");
 
    conn = DriverManager.getConnection(url, user, pwd);
 
    out.println("드라이버 버전 : " + conn.getMetaData().getDriverVersion());
    out.println("<br /><br />");
 
    out.println("DB 접속 성공");
    out.println("<br /><br />");
}  catch (ClassNotFoundException e)  {
    e.printStackTrace();
    out.println("드라이버 로딩 에러 : " + e.getMessage());
    out.println("<br /><br />");
}  catch (SQLException e) {
    e.printStackTrace();
    out.println("DB 접속 에러 : " + e.getMessage());
    out.println("<br /><br />");
}  finally  {
    if (null != conn)  {
        try  {
            conn.close();
        }  catch (Exception e) {
            e.printStackTrace();
        } finally {
            conn = null;
        }
    }
}
%>





WAS 컨넥션 풀을 이용하여 접속 테스트 하기
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ page language="java" import="java.sql.*" %>
<%@ page language="java" import="javax.sql.*" %>
<%@ page language="java" import="javax.naming.*" %>
 
<%
String jndi = "java:/jdbc/Oracle";
String user = "system";
String pwd = "manager";
 
Context context = new InitialContext();
DataSource ds = null;
Connection conn = null;
 
try  {
    ds = (DataSource)context.lookup(jndi);
    out.println("DataSource lookup 성공");
    out.println("<br /><br />");
}  catch (NamingException e)  {
    e.printStackTrace();
    out.println("풀 에러 : " + e.getMessage());
    out.println("<br /><br />");
} finally  {
    if (null != context) {
        try  {
            context.close();
        }  catch (NamingException e)  {
            e.printStackTrace();
        }  finally  {
            context = null;
        }
    }
}
 
try  {
    conn = ds.getConnection();
 
    out.println("드라이버 버전 : " + conn.getMetaData().getDriverVersion());
    out.println("<br /><br />");
 
    out.println("getConnection() - DB 접속 성공");
    out.println("<br /><br />");
}  catch (SQLException e)  {
    e.printStackTrace();
    out.println("getConnection() - DB 접속 에러 : " + e.getMessage());
    out.println("<br /><br />");
}  finally  {
    if (null != conn)  {
        try  {
            conn.close();
        }  catch (Exception e)  {
            e.printStackTrace();
        }
        conn = null;
    }
}
 
try  {
    conn = ds.getConnection(user, pwd);
    out.println("getConnection(\"" + user + "\", \"" + pwd + "\") - DB 접속 성공");
    out.println("<br /><br />");
}  catch (SQLException e)  {
    e.printStackTrace();
    out.println("getConnection(\"" + user + "\", \"" + pwd + "\") - DB 접속 에러 : " + e.getMessage());
    out.println("<br /><br />");
}  finally  {
    if (null != conn)  {
        try  {
            conn.close();
        }  catch (Exception e)  {
            e.printStackTrace();
        }
        conn = null;
    }
}
%>