2013년 9월 3일 화요일

tmocat jndi 설정

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

댓글 없음:

댓글 쓰기