ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rao, Satish" <satish....@fmr.com>
Subject RE: ArrayDescriptor issue
Date Tue, 16 Aug 2005 15:28:02 GMT
Ok.. Made some progress.... 

Now its going past the following code

			ArrayDescriptor descriptor =
ArrayDescriptor.createDescriptor("NUM_ARRAY", conn);
			ARRAY array = new ARRAY (descriptor, conn,
orderIdArr);
			arg0.setArray(array);

After that it throws a NullPointerException. I don't see the property
runDetailRS being set. I feel the way I have set the array is not
correct. I have a TypeHandler that reads the REF CURSOR and populates
the ResulSet. I know this piece of code works.
Here's the parameter map.
	<parameterMap id="test-detail-proc-param"
class="OrderTestFilter" >
		<parameter property="orderId" mode="IN" jdbcType="ARRAY"
javaType="java.util.ArrayList"/>
		<parameter property="runDetailRS"
jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT"/>
	</parameterMap>


-----Original Message-----
From: Koka [mailto:226057@gmail.com] 
Sent: Tuesday, August 16, 2005 11:00 AM
To: user-java@ibatis.apache.org
Subject: Re: ArrayDescriptor issue


The error you get usually indicates permission problems. 
So it seems that either you have not created ORD_ARRAY type on the
database side or the user you use to open connection does not see it.

It would be easier if you'd post JDBC code AND oracle TYPE/procedure

Good luck 
Koka

Mime
View raw message