Eclipse를 기준으로 작성 나머지는 구독자가 알아서...
워낙 블로그로 취미로...
[준비물]
1. MYSQL 드라이버 (mysql-connector-java-5.1.6-bin.jar)
WebRoot/WEB-INF/lib 폴더 복사
2. Eclipse에 Tomcat Server > server.xml 설정
[Tomcat 4.X 버전대의 예제]
[code xml]
<Resource auth="Container" name="jdbc/mysql" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/mysql">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:mysql://localhost:3306/cranix</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.mysql.jdbc.Driver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
<parameter>
<name>minEvictableIdleTimeMillis</name>
<value>600000</value>
</parameter>
<parameter>
<name>username</name>
<value>ID</value>
</parameter>
<parameter>
<name>password</name>
<value>PASS</value>
</parameter>
</ResourceParams>
[/code]
[Tomcat 5.X 버전]
Mysql용
[code xml]
<Resource
name="jdbc/사용할alias"
auth="Container"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/데이터베이스명"
username="계정"
password="비밀번호"
/>
[/code]
오라클용
[code xml]
<Resource
name="jdbc/bell"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory"
driverClassName="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:오라클SID"
username="계정"
password="비밀번호"
maxActive="15"
maxIdle="5"
maxWait="-1"
removeAbandoned="true"
removeAbandonedTimeout="60"
[/code]
3. web.xml 작성
[code xml]
<resource-ref>
<description>Use for valuation systems DataSource</description>
<res-ref-name>jdbc/사용할alias</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
[/code]
4. 컨넥션 확인
나머지는 즐~ 코딩 시작~~ 야호~
Prev
Rss Feed