<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>
<%
		/*
		//oci 드라이버를 로드할 수 있는지 체크
		try
		{
			System.loadLibrary("ocijdbc9"); 
		}
		catch(Exception e)
		{
			out.println("loadLibrary Error");
			out.println(e.getMessage());
			System.exit(-1);
		}
		*/
				
		try
		{
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		}
		catch(Exception e)
		{
			out.println("registerDriver error");
			out.println(e.getMessage());
		}
		
		try
		{
			//Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@210.33.33.33:1521:or","user","pwd");
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.33.33.33:1521:or","user","pwd");
		}            
		catch(Exception e)
		{
			out.println("getConnection Error");
			out.println(e.getMessage());
			
		}
		
		out.println("DB Connection(without DBCP) OK");
		
		/*
		//Loaded Driver 
		Enumeration enum = DriverManager.getDrivers();
		while(enum.hasMoreElements())
		{
			System.out.println(((Driver)enum.nextElement()).getMajorVersion() );
		}
		*/
		
		//Use JNDI DataSource
		DataSource ds = null;
		
		Context initContext = new InitialContext();

		Context envContext  = (Context)initContext.lookup("java:/comp/env");

		try{
			ds = (DataSource)envContext.lookup("jdbc/ds_name");
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}

		try
		{
			Connection conn = ds.getConnection();
		}
		catch(Exception e)
		{
			System.out.println(e.getMessage());
		}

		out.println("DB Connectino(with DBCP) OK");

%>