iBatis SQL Maps

Mr.Squirrel | 1 Jun 2010 16:14

Mapping an Array of String


hello,

i am calling an oracle stored procedure which return the type "TABLE OF
VARCHAR2" (as output parameter)
How can i map this type to the java type "String []"  ?

SqlMap.xml :
<parameterMap id="calculDroits" class="CalculDroits">
    	<parameter property="seqFormation" jdbcType="ARRAY"
javaType="java.lang.String[]" mode="OUT" />
</parameterMap>	    	

<procedure id="pCalculDroits" parameterMap="calculDroits">
	    { call pbw_calculDroitsReins.Du(?) }
</procedure>

JavaBean CalculDroits.java :
public class CalculDroits implements Serializable{

	private static final long serialVersionUID = 9014779368033647012L;
	
	private String[] codesDroit;

	public String[] getCodesDroit() {
		return codesDroit;
	}
	public void setCodesDroit(String[] codesDroit) {
		this.codesDroit = codesDroit;
	}

(Continue reading)

headers

Larry Meadors | 1 Jun 2010 16:52

Re: Mapping an Array of String

FYI: The ibatis project has moved and been renamed.

It is no longer being maintained as an Apache project, but has moved
(along with the development team) here:

http://www.mybatis.org/

Please join us at the new location by joining the mailing list here:

http://groups.google.com/group/mybatis-user

Larry

On Tue, Jun 1, 2010 at 8:14 AM, Mr.Squirrel
<francois.albert <at> univ-nantes.fr> wrote:
>
> hello,
>
> i am calling an oracle stored procedure which return the type "TABLE OF
> VARCHAR2" (as output parameter)
> How can i map this type to the java type "String []"  ?
>
> SqlMap.xml :
> <parameterMap id="calculDroits" class="CalculDroits">
>        <parameter property="seqFormation" jdbcType="ARRAY"
> javaType="java.lang.String[]" mode="OUT" />
> </parameterMap>
>
> <procedure id="pCalculDroits" parameterMap="calculDroits">
>            { call pbw_calculDroitsReins.Du(?) }

(Continue reading)