egovframe tomcat WAS jndi 설정

egovframe  tomcat  WAS jndi 설정

 

egovframe 2.5

tomcat 7.0

mysql 기준

 

 

1. Tomcat Context.xml 설정

 

<Context>

  .....

  <Resource name="jdbc/test01"

                  auth="Container"

                  type="javax.sql.DataSource"

                  driverClassName="com.mysql.jdbc.Driver"

                 

                  loginTimeout="10"

                  maxWait="5000"

                  username="test01"

                  password="test01"

                  testOnBorrow="true"

                  url="jdbc:mysql://192.168.0.71:3306/test01"

        />

  .....

</Context>

 

 

2. spring/com/context-datasource.xml 설정

 

...

<bean id="dataSource-mysql" class="org.springframework.jndi.JndiObjectFactoryBean">

<property name="jndiName">

<value>java:comp/env/jdbc/test01</value>

</property>

</bean>

...

 

3. lib추가

 어디  blog보니 추가하라고 되어있는데.......

 apache-tomcat-7.0.52 의 경우  apache-tomcat-7.0.52\lib에 기본으로 포함되어 있음..

tomcat-dbcp.jar 

<dependency>

<groupId>org.apache.tomcat</groupId>

<artifactId>tomcat-dbcp</artifactId>

<version>8.0.3</version>

</dependency>