ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ahuja, Ruchi" <ruchi.ah...@fmr.com>
Subject How to map STRUCT into java bean
Date Thu, 13 Oct 2005 05:53:52 GMT
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


Mime
View raw message