You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Sudhakar Kanagarajan <s....@gmail.com> on 2009/01/12 17:49:40 UTC
Re: How to map STRUCT into java bean
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.