Hi I have a typehandler for the enum in the second result map which is referenced from the CounterpartyHedgeVOResult result map.
Do you mean that I should try having the second result map just return strings, and change the line in the first result map to this? : <result resultMap="CDS_HEDGE.CreditEventEnumResult" property="creditEvents" typeHandler="hedge.dao.CreditEventEnumReadOnlyTypeHandler"/> I'll give it a go tomorrow when I'm at work. Thanks, micke 2009/5/18 DelGurth <delgu...@gmail.com> > On Mon, May 18, 2009 at 7:40 PM, Mikael Andersson <mail.mi...@gmail.com> > wrote: > > Hi > > > > I'm having problems mapping to a property which is a Set of java5 enums. > > > > I have a class CounterpartyHedgeVO which has the property creditEvents > which > > is a Set<CreditEventEnum>. > > > > Not sure what the problem is but I'm guessing that iBATIS tries to treat > the > > Enum like a POJO and fails to create it since there isn't a public > > constructor. Or? > > > > Any help would be really appreciated. > > > > My current sqlmap (omitted the typeAlias definitions): > > > > <resultMap class="CounterpartyHedgeVO" id="CounterpartyHedgeVOResult" > > groupBy="refNo"> > > <result column="POS_RefNoADB" jdbcType="VARCHAR" property="refNo"/> > > <result column="PRT_Code" jdbcType="VARCHAR" property="prtCode"/> > > <result column="RBE_CodeCpty" jdbcType="VARCHAR" > > property="counterpartyCode"/> > > <result column="POS_Tradebook" jdbcType="VARCHAR" > > property="tradeBook"/> > > > > <result resultMap="CDS_HEDGE.CreditEventEnumResult" > > property="creditEvents"/> > > </resultMap> > > > > <resultMap class="CreditEventEnum" id="CreditEventEnumResult"> > > <result column="CRE_EventType" property="value" jdbcType="VARCHAR" > > typeHandler="hedge.dao.CreditEventEnumReadOnlyTypeHandler"/> > > </resultMap> > > > > Stack trace: > > --- The error occurred in ibatis/sqlmap-map-cds-hedge.xml. > > --- The error occurred while applying a result map. > > --- Check the CDS_HEDGE.CreditEventEnumResult. > > --- The error occured while instantiating the result object > > --- Cause: java.lang.RuntimeException: JavaBeansDataExchange could not > > instantiate result class. Cause: java.lang.InstantiationException: > > hedge.interfaces.CreditEventEnum > > at > > > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:188) > > at > > > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123) > > at > > > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615) > > at > > > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589) > > at > > > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) > > at > > > org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:298) > > at > > > org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:209) > > ... 40 more > > Caused by: java.lang.RuntimeException: JavaBeansDataExchange could not > > instantiate result class. Cause: java.lang.InstantiationException: > > hedge.interfaces.CreditEventEnum > > at > > > com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:108) > > at > > > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:373) > > at > > > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setNestedResultMappingValue(BasicResultMap.java:449) > > at > > > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.applyNestedResultMap(BasicResultMap.java:396) > > at > > > com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:382) > > at > > > com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:64) > > at > > > com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:382) > > at > > > com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301) > > at > > > com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQueryProcedure(SqlExecutor.java:283) > > at > > > com.ibatis.sqlmap.engine.mapping.statement.ProcedureStatement.sqlExecuteQuery(ProcedureStatement.java:34) > > at > > > com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173) > > ... 46 more > > Caused by: java.lang.InstantiationException: > > hedge.interfaces.CreditEventEnum > > at java.lang.Class.newInstance0(Class.java:340) > > at java.lang.Class.newInstance(Class.java:308) > > at com.ibatis.common.resources.Resources.instantiate(Resources.java:294) > > at > > > com.ibatis.sqlmap.engine.mapping.result.ResultObjectFactoryUtil.createObjectInternally(ResultObjectFactoryUtil.java:127) > > at > > > com.ibatis.sqlmap.engine.mapping.result.ResultObjectFactoryUtil.createObjectThroughFactory(ResultObjectFactoryUtil.java:95) > > at > > > com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:106) > > ... 56 more > > > > Cheers, > > Micke > > I think you will need to create a typehandler so iBATIS can work with your > Enum. > > See: > http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+complex+property+or+Type+Safe+Enumeration > > Regards, > Wessel >
