Apache Tomcat 7 JNDI ¼³Á¤
<<¼³¸í>>
¼Ò½º¿¡ DB ¼³Á¤ ºÎºÐÀ» Apache Tomcat¿¡ ¼³Á¤À¸·Î º¯°æÇØÁÖ´Â ¹æ¹ý
<<¼³Á¤ ¼ø¼>>
1. Tomcat ¼³Ä¡ Æú´õ/lib·Î À̵¿ÇÏ¿© tomcat-jdbc.jar ÆÄÀÏÀ» È®ÀÎÇÑ´Ù.
2. tomcat-jdbc.jar ÆÄÀÏÀÌ ¾øÀ¸¸é ¾Æ·¡ »çÀÌÆ®·Î À̵¿ÇÏ¿© ÃֽŠ¹öÀüÀ¸·Î ´Ù¿î·ÎµåÇÑ´Ù.
»çÀÌÆ® : http://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html
3. Tomcat ¼³Ä¡Æú´õ/lib Æú´õ·Î À̵¿ÇÏ¿© tomcat-jdbc.jar, ojdbc6-11.2.0.3.0.jar¸¦ º¹»çÇÑ´Ù.
4. Tomcat ¼³Ä¡ Æú´õ/conf·Î À̵¿ÇÏ¿© server.xml ÆÄÀÏÀ» ¿°í ¾Æ·¡ ³»¿ëÀ»
< GlobalNamingResources></GlobalNamingResources> »çÀÌ¿¡ Ãß°¡ÇÑ´Ù.
[Ãß°¡³»¿ë: °¢ ¼³Á¤Àº °³º°·Î ¿ëµµ¿¡ ¸Â°Ô ¼³Á¤ÇÑ´Ù.]
<Resource name="jdbc/myoracle"
auth="Container"
type="javax.sql.DataSource"
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
driverClassName="oracle.jdbc.OracleDriver"
defaultAutoCommit="false"
url="jdbc:oracle:thin:@¾ÆÀÌÇÇ:Æ÷Æ®:½ºÅ°¸¶"
username="¾ÆÀ̵ð"
password="¾ÏÈ£"
maxActive="20"
maxIdle="10"
maxWait="-1"/>
5. Tomcat ¼³Ä¡ Æú´õ/conf·Î À̵¿ÇÏ¿© context.xml ÆÄÀÏÀ» ¿°í ¾Æ·¡ ³»¿ëÀ»
<Context></Context> »çÀÌ¿¡ Ãß°¡ÇÑ´Ù
[Ãß°¡³»¿ë]
<ResourceLink type="javax.sql.DataSource"
name="jdbc/myoracle"
global="jdbc/myoracle"/>
6. Tomcat ¼³Ä¡ Æú´õ/conf·Î À̵¿ÇÏ¿© web.xml ÆÄÀÏÀ» ¿°í ¾Æ·¡ ³»¿ëÀ»
<Web-app></Web-app> »çÀÌ¿¡ Ãß°¡ÇÑ´Ù
[Ãß°¡³»¿ë]
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/myoracle</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
7. Project¿¡ WEB-INF/spring/infrastructure-context.xml Æú´õ·Î À̵¿ÇÏ¿© infrastructure-context.xml¿¡ ¾Æ·¡ ³»¿ëÀ» Ãß°¡ÇÏ°í Àü datasourceÀ» ÁÖ¼®À̳ª »èÁ¦ ó¸®ÇÑ´Ù.
[Ãß°¡ÇÒ dataSource]
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
<property name="jndiName" value="java:/comp/env/jdbc/myoracle" />
</bean>
[»èÁ¦³ª ÁÖ¼®Ã³¸® ÇÒ dataSource]
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
<property name="url" value=""/>
<property name="username" value=""/>
<property name="password" value=""/>
</bean>