'Connection Pool'에 해당되는 글 1건
- 2008/09/11 Tomcat - Connection Pool 사용법
Tomcat/conf/context.xml
데이터베이스 접속이 필요한 경우에는 다음과 같은 코드를 사용하면 된다.
출처 : http://micropilot.tistory.com/category/Tomcat
<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"
username="scott" password="tiger"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:ORCL"
maxActive="5"/>
</Context>
<Context>
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource"
username="scott" password="tiger"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@localhost:1521:ORCL"
maxActive="5"/>
</Context>
데이터베이스 접속이 필요한 경우에는 다음과 같은 코드를 사용하면 된다.
private Connection getConnection() {
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
return conn;
}catch(Exception e){
e.printStackTrace();
}
return null;
}
try{
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource) envCtx.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
return conn;
}catch(Exception e){
e.printStackTrace();
}
return null;
}
출처 : http://micropilot.tistory.com/category/Tomcat
Prev
Rss Feed