Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of Jack.Su@fmr.com designates
 192.223.198.27 as permitted sender)
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: How to pass Array as parameter?
Date: Wed, 3 Oct 2007 17:27:14 -0400
Message-ID: 
 <744CFC61CF0DFF49987C870D28304B6F024E08E6@MSGMMKCLQ2WIN.DMN1.FMR.COM>
Thread-Topic: How to pass Array as parameter?
Thread-Index: AcgF/TOtg1p8SVR2TPWiu17nAbt4+gABAN5sAAAIeYAAAKfLIA==
References: <C329605F.215D%clamey@localmatters.com>
 <744CFC61CF0DFF49987C870D28304B6F024E08E5@MSGMMKCLQ2WIN.DMN1.FMR.COM>
From: "Yu, Jack" <Jack.Su@fmr.com>
To: <user-java@ibatis.apache.org>

One minor change to the sample code, I have to use inner most delegate
connection. So it is:


 public void setParameter(ParameterSetter setter, Object parameter)
throws SQLException {
		if (parameter instanceof DBArray) {
			DBArray arr =3D (DBArray)parameter;
			Statement stmt =3D setter.getPreparedStatement();
			Connection conn =3D stmt.getConnection();
			if (conn instanceof DelegatingConnection) {
				DelegatingConnection dcon =3D
(DelegatingConnection) conn;
				conn =3D dcon.getInnermostDelegate();
			}
			ArrayDescriptor  desc =3D new ArrayDescriptor
(arr.getSqlType(), conn);
		=09
			/* arr.getData's type is SQLData[] */
			parameter =3D new ARRAY(desc, conn,
arr.getData());
			=20
		}
		setter.setObject(parameter);
	}

-----Original Message-----
From: Yu, Jack=20
Sent: Wednesday, October 03, 2007 5:11 PM
To: user-java@ibatis.apache.org
Subject: How to pass Array as parameter?

I would need to pass Array in the call, but I couldn't find out feasible
way to wrap around my objects to java.sql.Array.

In Oracle, it appears I could use "ARRAY" to create, but ARRAY object
need ArrayDescriptor which requires access to Connection object, which I
am not sure how to get in the ibatis environment.

I am trying to play around the setParameter in TypeHandlerCallback
interface, here is what I come out. It works in Oracle environment, but
I would like to get some feedback before I check in the code.

Thanks.

	public void setParameter(ParameterSetter setter, Object
parameter) throws SQLException {
		if (parameter instanceof DBArray) {
			DBArray arr =3D (DBArray)parameter;
			// convert SQLData[] to Array
			Statement stmt =3D setter.getPreparedStatement();
			Connection conn =3D stmt.getConnection();
			ArrayDescriptor  desc =3D new ArrayDescriptor
(arr.getSqlType(), conn);
		=09
			parameter =3D new ARRAY(desc, conn,
arr.getData());
			=20
		}
		setter.setObject(parameter);
	}