일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
- 설정
- PostgreSQL
- Spring Boot
- error
- myBatis
- MSSQL
- oracle
- git
- Docker
- SpringBoot
- IntelliJ
- MySQL
- Thymeleaf
- STS
- Eclipse
- Exception
- ubuntu
- jpa
- AJAX
- Core Java
- JavaScript
- spring
- maven
- Tomcat
- Source
- 오픈소스
- JDBC
- Python
- Open Source
- 문서
- Today
- Total
헤르메스 LIFE
[Exception] Spring + MS SQL Server 2008 본문
org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'urlMapping' defined in ServletContext resource [/WEB-INF/classes/tims2-common.xml]:
Cannot resolve reference to bean 'topFrameController' while setting bean property 'urlMap' with key [TypedStringValue: value [/topFrame.do], target type [null]];
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'topFrameController': Autowiring of fields failed;
nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private tims2.common.navi.service.MenuNaviService tims2.common.init.controller.TopFrameController.menuNaviService;
nested exception is org.springframework.beans.factory.BeanCreationException:
Error creating bean with name 'menuNaviService': Autowiring of fields failed;
nested exception is org.springframework.beans.factory.BeanCreationException: Could not autowire field: private tims2.common.navi.dao.MenuNaviDAO tims2.common.navi.service.MenuNaviServiceImpl.menuNaviDAO;
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'menuNaviDAO' defined in ServletContext resource [/WEB-INF/classes/tims2-common.xml]: Cannot resolve reference to bean 'sqlMapClient' while setting bean property 'sqlMapClient';
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlMapClient' defined in ServletContext resource [/WEB-INF/classes/tims2-ibatis.xml]: Invocation of init method failed;
nested exception is org.springframework.core.NestedIOException: Failed to parse config resource: ServletContext resource [/WEB-INF/classes/sql-map-config.xml];
nested exception is com.ibatis.common.xml.NodeletException: Error parsing XML. Cause: java.lang.RuntimeException: Error parsing XPath '/sqlMapConfig/typeHandler'.
Cause: java.lang.IllegalStateException: No LobHandler found for configuration - lobHandler property must be set on SqlMapClientFactoryBean
======================================================================================
LOB type의 데이터 Handler 때문에 발생한 Exception입니다.
해결방법
---------------------------------------------------------------------
오라클과 비교해보면 간단합니다.
<!--
<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">
<property name="nativeJdbcExtractor"><ref local="nativeJdbcExtractor"/></property>
</bean>
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="/WEB-INF/classes/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
<property name="lobHandler" ref="oracleLobHandler" />
</bean>
-->
<bean id="defaultLobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="/WEB-INF/classes/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
<property name="lobHandler" ref="defaultLobHandler" />
</bean>