MySql CodeGen 의 CRUD 생성시 에러
- 작성자 :
- 유*훈
- 작성일 :
- 2014-01-16 14:46:44
- 조회수 :
- 822
- 구분 :
- 개발환경
- 진행상태 :
- 완료
Q
최초 CRUD로 자동 생성시 Mysql컬럼이 bigint(20)으로 선언되어있고 null이 허용 가능합니다.
CRUD로 VO가 private java.math.BigInteger mpSelectedLocal;로 자동 생성 되었구요
sqlmap의 resultMap값이 <result property="mpSelectedLocal" column="mp_selected_local" columnIndex="50"/>
위와 같이 생성되어있습니다.
리스트출력후 자동으로 생성된 수정창에 들어갈 경우
2014-01-16 14:36:14,270 DEBUG [org.springframework.web.servlet.handler.SimpleMappingExceptionResolver] Resolving exception from handler [egovframework.anselm.newbidin.member.web.BpMemberPublicNewController@84fdbc]: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in egovframework/sqlmap/member/BpMemberPublicNew_SQL.xml.
--- The error occurred while applying a result map.
--- Check the BpMemberPublicNew.bpMemberPublicNew.
--- Check the result mapping for the 'mpSelectedLocal' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'mpSelectedLocal' to the column 'mp_selected_local'. One or both of the types, or the combination of types is not supported.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/member/BpMemberPublicNew_SQL.xml.
--- The error occurred while applying a result map.
--- Check the BpMemberPublicNew.bpMemberPublicNew.
--- Check the result mapping for the 'mpSelectedLocal' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'mpSelectedLocal' to the column 'mp_selected_local'. One or both of the types, or the combination of types is not supported.
위와 같은 에러가 발생합니다.
이럴 경우 어떻게 설정을 변경해야하는건지 문의 드립니다.
CRUD로 VO가 private java.math.BigInteger mpSelectedLocal;로 자동 생성 되었구요
sqlmap의 resultMap값이 <result property="mpSelectedLocal" column="mp_selected_local" columnIndex="50"/>
위와 같이 생성되어있습니다.
리스트출력후 자동으로 생성된 수정창에 들어갈 경우
2014-01-16 14:36:14,270 DEBUG [org.springframework.web.servlet.handler.SimpleMappingExceptionResolver] Resolving exception from handler [egovframework.anselm.newbidin.member.web.BpMemberPublicNewController@84fdbc]: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];
--- The error occurred in egovframework/sqlmap/member/BpMemberPublicNew_SQL.xml.
--- The error occurred while applying a result map.
--- Check the BpMemberPublicNew.bpMemberPublicNew.
--- Check the result mapping for the 'mpSelectedLocal' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'mpSelectedLocal' to the column 'mp_selected_local'. One or both of the types, or the combination of types is not supported.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in egovframework/sqlmap/member/BpMemberPublicNew_SQL.xml.
--- The error occurred while applying a result map.
--- Check the BpMemberPublicNew.bpMemberPublicNew.
--- Check the result mapping for the 'mpSelectedLocal' property.
--- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'mpSelectedLocal' to the column 'mp_selected_local'. One or both of the types, or the combination of types is not supported.
위와 같은 에러가 발생합니다.
이럴 경우 어떻게 설정을 변경해야하는건지 문의 드립니다.
A
안녕하세요. 표준프레임워크센터입니다.
mp_selected_local 컬럼의 타입에 맞게 javaType을 지정해 보시기 바랍니다.
예)
<result property="mpSelectedLocal" column="mp_selected_local" columnIndex="50" javaType="java.lang.String"/>
감사합니다.
mp_selected_local 컬럼의 타입에 맞게 javaType을 지정해 보시기 바랍니다.
예)
<result property="mpSelectedLocal" column="mp_selected_local" columnIndex="50" javaType="java.lang.String"/>
감사합니다.
