Home > JDBC, JSP&Servlet, Oracle > Tomcat & Oracle DataSource 설정

Tomcat & Oracle DataSource 설정

July 11th, 2010 Kim Jong-sun

1. conf/server.xml파일을 열고 <GlobalNamingResources>엘리먼트 안에 다음 내용 추가.


<Resource name="jdbc/myoracle" auth="Container"
 type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
 url="jdbc:oracle:thin:@localhost:1521:데이터베이스이름"
 username="유저네임" password="패스워드" />

2. conf/context.xml에 추가


<ResourceLink global="jdbc/myoracle" name="jdbc/myoracle" type="javax.sql.DataSource"/>

3. 코드 안에서는


InitialContext ic = new InitialContext();
DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/myoracle");
Connection con = ds.getConnection();
  • Google Bookmarks
  • Google Reader
  • Twitter
  • Facebook
  • Google Buzz
  • WordPress
  • Share/Bookmark
Categories: JDBC, JSP&Servlet, Oracle Tags:
Comments are closed.