헤르메스 LIFE

[Exception] Spring + MS SQL Server 2008 본문

Exception

[Exception] Spring + MS SQL Server 2008

헤르메스의날개 2010. 10. 19. 17:04
728x90


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>

728x90