ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sudhakar Kanagarajan <s.kanagara...@gmail.com>
Subject Re: How to map STRUCT into java bean
Date Mon, 12 Jan 2009 16:49:40 GMT

Do anyone have answer for this?

Ahuja, Ruchi wrote:
> 
> Hi,
> 
> I am invoking a oracle FUNCTION returning Oracle OBJECT TYPE. I am able
> to retrieve a STRUCT from that. Can anyone tell me how do I map the
> fields in struct to a Java bean in sql map configuration.
> 
> My SQLMap configuration is as follows -
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
> "sql-map-2.dtd">
> <sqlMap>
> <parameterMap id="GetClientInfo-param-map" class="java.util.Map">
>     <parameter property="result" jdbcType="STRUCT"
> typeName="XT_CLIENTINFOVALUEOBJECT" mode="OUT"
> typeHandler="com.ibatis.sqlmap.engine.type.ObjectTypeHandler"/>
>     <parameter property="clientId" jdbcType="DECIMAL"
> javaType="java.math.BigDecimal" mode="IN" />
>     <parameter property="serviceName" jdbcType="VARCHAR"
> javaType="java.lang.String" mode="IN" />
>     <parameter property="isNewService" jdbcType="CHAR"
> javaType="java.lang.String" mode="IN" />
> </parameterMap>
> <procedure id="GetClientInfo" parameterMap="GetClientInfo-param-map">	
> 	{? = call PKG_CLIENTINFO.getClientInfo(?, ?, ?) }
> </procedure>
> </sqlMap>
> 
> Thanks,
> Ruchi
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/How-to-map-STRUCT-into-java-bean-tp1106513p21418360.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


Mime
View raw message