JNDI셋팅(tomcat,mysql) 중 발생한 에러 및 처리

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

tomcat - mysql - jndi 셋팅 중 에러 및 처리에 대한 기록입니다.

1. SqlSession Autowired 문제

sqlSession autowired가 안되 발생한 문제다.

에러 내용을 보면 datasource bean을 못찾는것.

실제로 소스를 확인해보면, sqlSessionFactory에 등록된 datasource가 찾을 bean이 없다.!

testDao.java

@Repository
public class testDao {

	@Autowired
	SqlSession sqlSession;
	
	@SuppressWarnings("unchecked")
	public List<HashMap<String,String>> getGospe() {
		HashMap<String,String> input = new HashMap<String, String>();
		input.put("type", "AD");
		return sqlSession.selectList("sqlBibleMapper.selectGospel",input);	
	}
	
}

root-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:context="http://www.springframework.org/schema/context"
	
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	https://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/context
    http://www.springframework.org/schema/context/spring-context-3.0.xsd">
        <context:component-scan base-package="com.wb.hb.bible.dao"></context:component-scan>	
	
	<!-- Root Context: defines shared resources visible to all other web components -->
	<bean id ="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="configLocation" value="classpath:/mybatis-config.xml"></property>
		<property name="mapperLocations" value="classpath:mappers/**/*_sql.xml"></property>
	</bean>
	
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate" destroy-method="clearCache">
         <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
    </bean>
</beans>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
  <environments default="jndi">
    <environment id="jndi">
      <transactionManager type="JDBC" />
      <dataSource type="JNDI">
        <property name="data_source" value="java:comp/env/jdbc/npwbDB" />
      </dataSource>
    </environment>
  </environments>
</configuration>
  <mappers>
  	<mapper resource="/mappers/Bible_sql.xml"/>
  </mappers>

에러메시지

해결책

1)web.xml에 root-context.xml 설정파일을 읽도록 추가하기

<!-- Processes application requests -->
	<servlet>
		<servlet-name>appServlet</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<init-param>
			<param-name>contextConfigLocation</param-name>
			<param-value>
			/WEB-INF/spring/appServlet/servlet-context.xml
			/WEB-INF/spring/root-context.xml
			</param-value>
			<!--2019.10.05 root-context.xml에 있는 sqlsession을 authwired를 못해서 설정파일을 추가해줌-->
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>

2)root-context.xml에 datasource bean등록

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

1-2. datasource의 getter,setter를 못찾는 문제

에러메시지는 다음과 같다.

Caused by: org.springframework.beans.factory.BeanCreationException: Could not autowire field: private com.wb.hb.bible.dao.testDao com.wb.hb.HomeController.dao; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'testDao': Injection of autowired dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: org.apache.ibatis.session.SqlSession com.wb.hb.bible.dao.testDao.sqlSession; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSession' defined in ServletContext resource [/WEB-INF/spring/root-context.xml]: Cannot resolve reference to bean 'sqlSessionFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in ServletContext resource [/WEB-INF/spring/root-context.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/spring/root-context.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property 'dataSource' of bean class [org.springframework.jndi.JndiObjectFactoryBean]: Bean property 'dataSource' is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:506)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:87)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:284)
	... 65 more

내가 설정한 dataSource의 getter,setter를 찾지 못해 autowired를 실패하는것.

해결책

이건 단순한 내 삽질덕이었다.

https://stackoverflow.com/questions/16466759/spring-jndi-datasource-setup

spring jndi datasource setup

Hi i am trying to use jndi data source. below is the code context.xml stackoverflow.com

스택오버플로우에 따르면, 아래와 같이 적혀있다.

Looking at the JndiObjectFactoryBean it looks like you want the setJndiName() method from JndiObjectLocator super class.

수정된 소스는 다음과 같다.. datasource propertydml name옵션을 다음과같이 바꾸는것.

	<bean id ="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="configLocation" value="classpath:/mybatis-config.xml"></property>
		<property name="mapperLocations" value="classpath:mappers/**/*_sql.xml"></property>
	</bean>

2. Mapped Statements collection already contains value.

에러메시지는 다음과 같다.

nested exception is java.lang.RuntimeException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for sqlBibleMapper.selectGospel

뭔가 메퍼 xml파일의 sql id가 중복된다는 에러메시지.

하지만 딱히 중복되어 쓰지 않았고, 설정파일 문제일것이라고 생각했다.

문제는 매퍼파일을 여러개의 설정파일에서 부르는것.

root-context.xml (mapperLocations)

	<!-- Root Context: defines shared resources visible to all other web components -->
	<bean id ="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"/>
		<property name="configLocation" value="classpath:/mybatis-config.xml"></property>
		<property name="mapperLocations" value="classpath:mappers/**/*_sql.xml"></property>
	</bean>

root-context.xml에서 호출한 mybatis-config.xml

  <mappers>
  	<mapper resource="/mappers/Bible_sql.xml"/>
  </mappers>

이런식으로 두번 호출하는게 문제가 됐음.

해결방법은뭐..

mybatis-config.xml에 해당 소스 주석처리.

3. expected at least 1 bean which qualifies as autowire candidate for this dependency.

이건 신규 Dao를 생성하고 발생한 문제인데, 클래스에 @Repository어노테이션이 없어 발생한 문제이다.

이후 정상적으로 쿼리가 작동했음.

저작자표시 (새창열림)

티스토리툴바