[ 재질문 ] altibase clob insert.. ㅜㅜ 죄송합니다. 급하다고 하셔서 자꾸 질문만하게되네요.
- 작성자 :
- 박*석
- 작성일 :
- 2011-06-17 14:32:01
- 조회수 :
- 3,084
- 구분 :
- 공통컴포넌트
- 진행상태 :
- 완료
Q
안녕하세요.
해당 공통 타입헨들러를 받아서
추가했습니다.
헌데도 문제가 발생하는데.
해당 타입 핸들러를 못가져온ㄴ것같습니다.
No LobHandler found for configuration - lobHandler property must be set on SqlMapClientFactoryBean
<result property="content" column="content" jdbcType="CLOB" typeHandler="egovframework.com.cmm.AltibaseClobStringTypeHandler"/>
package egovframework.com.cmm;
/*
* Copyright 2002-2005 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.support.lob.LobCreator;
import org.springframework.jdbc.support.lob.LobHandler;
import org.springframework.orm.ibatis.support.*;
import java.io.*;
/**
* iBATIS TypeHandler implementation for Strings that get mapped to CLOBs.
* Retrieves the LobHandler to use from SqlMapClientFactoryBean at config time.
*
* <p>Particularly useful for storing Strings with more than 4000 characters in an
* Oracle database (only possible via CLOBs), in combination with OracleLobHandler.
*
* <p>Can also be defined in generic iBATIS mappings, as DefaultLobCreator will
* work with most JDBC-compliant database drivers. In this case, the field type
* does not have to be BLOB: For databases like MySQL and MS SQL Server, any
* large enough binary type will work.
*
* @author Juergen Hoeller
* @since 1.1.5
* @see org.springframework.orm.ibatis.SqlMapClientFactoryBean#setLobHandler
*/
public class AltibaseClobStringTypeHandler extends AbstractLobTypeHandler {
추가하였으나 에러가 발생하여 로그 첨부합니다.
항상 신경써주셔서 감사합니다.
좋은 하루 되세요 [__
해당 공통 타입헨들러를 받아서
추가했습니다.
헌데도 문제가 발생하는데.
해당 타입 핸들러를 못가져온ㄴ것같습니다.
No LobHandler found for configuration - lobHandler property must be set on SqlMapClientFactoryBean
<result property="content" column="content" jdbcType="CLOB" typeHandler="egovframework.com.cmm.AltibaseClobStringTypeHandler"/>
package egovframework.com.cmm;
/*
* Copyright 2002-2005 the original author or authors.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.support.lob.LobCreator;
import org.springframework.jdbc.support.lob.LobHandler;
import org.springframework.orm.ibatis.support.*;
import java.io.*;
/**
* iBATIS TypeHandler implementation for Strings that get mapped to CLOBs.
* Retrieves the LobHandler to use from SqlMapClientFactoryBean at config time.
*
* <p>Particularly useful for storing Strings with more than 4000 characters in an
* Oracle database (only possible via CLOBs), in combination with OracleLobHandler.
*
* <p>Can also be defined in generic iBATIS mappings, as DefaultLobCreator will
* work with most JDBC-compliant database drivers. In this case, the field type
* does not have to be BLOB: For databases like MySQL and MS SQL Server, any
* large enough binary type will work.
*
* @author Juergen Hoeller
* @since 1.1.5
* @see org.springframework.orm.ibatis.SqlMapClientFactoryBean#setLobHandler
*/
public class AltibaseClobStringTypeHandler extends AbstractLobTypeHandler {
추가하였으나 에러가 발생하여 로그 첨부합니다.
항상 신경써주셔서 감사합니다.
좋은 하루 되세요 [__
A
안녕하세요.. 박준석님..
다음과 같이 lobHandler도 추가로 등록해 주시면 됩니다.
(context-sqlMap.xml 등 기존 sqlMapClient 부분)
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
<!-- SqlMap setup for iBATIS Database Layer -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocations">
<list>
<value>classpath:/egovframework/sqlmap/config/${Globals.DbType}/*.xml</value>
</list>
</property>
<property name="dataSource" ref="dataSource"/>
<property name="lobHandler" ref="lobHandler"/>
</bean>
그럼.. 즐거운 하루되십시오.
감사합니다.
다음과 같이 lobHandler도 추가로 등록해 주시면 됩니다.
(context-sqlMap.xml 등 기존 sqlMapClient 부분)
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true" />
<!-- SqlMap setup for iBATIS Database Layer -->
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocations">
<list>
<value>classpath:/egovframework/sqlmap/config/${Globals.DbType}/*.xml</value>
</list>
</property>
<property name="dataSource" ref="dataSource"/>
<property name="lobHandler" ref="lobHandler"/>
</bean>
그럼.. 즐거운 하루되십시오.
감사합니다.
