Hi, I am using ibatis and spring in my application.I want to map result of query containing oracle's Cast(Multiset..) which returns array for each row as one column with key value pairs.But when i am mapping that with list or HashMap I am getting exceptions. Can any one help me how to solve this.Thanks in Advance.
The stack trace is: org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; --- The error occurred in sqlmaps/loans.xml. --- The error occurred while applying a result map. --- Check the getApprovalItems-AutoResultMap. --- Check the result mapping for the 'serialNumbers' property. --- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'serialNumbers' to the column 'serialNumbers'. 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 sqlmaps/loans.xml. --- The error occurred while applying a result map. --- Check the getApprovalItems-AutoResultMap. --- Check the result mapping for the 'serialNumbers' property. --- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'serialNumbers' to the column 'serialNumbers'. One or both of the types, or the combination of types is not supported. com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in sqlmaps/loans.xml. --- The error occurred while applying a result map. --- Check the getApprovalItems-AutoResultMap. --- Check the result mapping for the 'serialNumbers' property. --- Cause: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'serialNumbers' to the column 'serialNumbers'. One or both of the types, or the combination of types is not supported. Caused by: com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to map the property 'serialNumbers' to the column 'serialNumbers'. One or both of the types, or the combination of types is not supported. at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(Lcom/ibatis/sqlmap/engine/scope/RequestScope;Ljava/sql/Connection;Ljava/lang/Object;Ljava/lang/Object;Lcom/ibatis/sqlmap/client/event/RowHandler;II)V(GeneralStatement.java:184) at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(Lcom/ibatis/sqlmap/engine/scope/RequestScope;Lcom/ibatis/sqlmap/engine/transaction/Transaction;Ljava/lang/Object;II)Ljava/util/List;(GeneralStatement.java:119) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(Lcom/ibatis/sqlmap/engine/scope/SessionScope;Ljava/lang/String;Ljava/lang/Object;II)Ljava/util/List;(SqlMapExecutorDelegate.java:610) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(Lcom/ibatis/sqlmap/engine/scope/SessionScope;Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;(SqlMapExecutorDelegate.java:584) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;(SqlMapSessionImpl.java:105) at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(Lcom/ibatis/sqlmap/client/SqlMapExecutor;)Ljava/lang/Object;(SqlMapClientTemplate.java:228) at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(Lorg/springframework/orm/ibatis/SqlMapClientCallback;)Ljava/lang/Object;(SqlMapClientTemplate.java:165) at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(Lorg/springframework/orm/ibatis/SqlMapClientCallback;)Ljava/util/List;(SqlMapClientTemplate.java:187) at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(Ljava/lang/String;Ljava/lang/Object;)Ljava/util/List;(SqlMapClientTemplate.java:226) at net.juniper.sales.barracuda.loan.LoanServiceImpl.getApprovalItems(JLjava/lang/String;)Ljava/util/List;(LoanServiceImpl.java:431) at net.juniper.sales.barracuda.loan.LoanServiceImpl.loadApproval(JLjava/lang/String;)Lnet/juniper/sales/barracuda/loan/ApprovalBean;(LoanServiceImpl.java:134) at jrockit.reflect.NativeMethodInvoker.invoke0(Ljava/lang/Object;ILjava/lang/Object;[Ljava/lang/Object;)Ljava/lang/Object;(Unknown Source) Regards, G.Naresh. -- View this message in context: http://www.nabble.com/Mapping-Result-of-Oracle-Multiset-in-IBATIS-tf3778193.html#a10683720 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
