Infra Structure/WAS

[Tomcat] JNDI 설정

하 선생 2020. 6. 4. 11:36

1) server.xml

<GlobalNamingResources>
    ...
    
    <Resource name="jdbc/sbbmsdb"
              global="jdbc/sbbmsdb"
              auth="Container"
              type="javax.sql.DataSource"
              driverClassName="com.mysql.jdbc.Driver"
              url="jdbc:mysql://IP주소:3306/watch?characterEncoding=UTF-8"
              username="아이디"
              password="패스워드"
              maxActive="20"
              maxIdle="20"
              minIdle="5"
              maxWait="3000"
              validationQuery="SELECT 1"
              validationInterval="30000"
              />
               
</GlobalNamingResources>

 

2) context.xml

<Context>
   ...
    <ResourceLink name="jdbc/sbbmsdb"
                  global="jdbc/sbbmsdb"
                  auth="Container"
                  type="javax.sql.DataSource" />

</Context>

3) 소스 context-datasource.xml

<beans>
    ...    
	<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">
		<property name="jndiName" value="java:/comp/env/jdbc/sbbmsdb" />
	</bean>

</beans>