ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Naresh <mailnare...@yahoo.co.in>
Subject Mapping Result of Oracle Multiset in IBATIS
Date Fri, 18 May 2007 14:47:36 GMT

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.


Mime
View raw message