servers 폴더의 context.xml에 추가한다.
<Resource name="jdbc/myDB"
auth="Container"
type="javax.sql.DataSource"
factory="org.objectweb.jotm.datasource.DataSourceFactory"
driverClassName="oracle.jdbc.driver.OracleDriver"
username="aaaaa" password="asdfgh"
url="jdbc:oracle:thin:@localhost:1521:sid" />
//jsp test
<%@ page contentType="text/html' charset=euc-kr"%>
<%@ page import="javax.sql.*"%>
<%@ page import="javax.naming.* , java.sql.*;"%>
<%
DataSource ds = null;
Connection con = null;
final String DATASOURCE = "jdbc/myDB";
try {
InitialContext ic = new InitialContext();
ds = (DataSource) ic.lookup(DATASOURCE);
con = ds.getConnection();
System.out.println("================================================================ ok");
} catch (Exception ex) {
System.out.println("================================================================ ex:"+ex);
ex.printStackTrace();
}
out.println(con);
%>
sdfsdfsdf
댓글 없음:
댓글 쓰기