Any comments on this?
Thanks,
Giovanni
On Nov 14, 2007 3:12 PM, Giovanni Cuccu <[EMAIL PROTECTED]> wrote:
> Hi all,
> I'm currently using ibatis 2.3 with Oracle and I'm trying to
> mapping some oracle datatypes. For now I'm focusing on VARRAY and with
> the current version of IBatis I'm able to map a String[] to a VARRAY
> type (where the basic type is varchar2) as an input param to a stored
> procedure.
> What I'm not able to do is to create a mapping for an output parameter.
> The case I'm currently investigating is a pl\SQL function that returns a
> varray.
> the plain jdbc code is the following (take it a first experiment)
> public class TestOracleArray {
>
> /**
> * @param args
> */
> public static void main(String[] args) throws Exception {
> OracleDataSource ods = new OracleDataSource();
> String url = "jdbc:oracle:thin:@localhost:1521:orcl";
> ods.setURL(url);
> ods.setUser("test");
> ods.setPassword("test");
> Connection conn = ods.getConnection();
> ArrayDescriptor desc =
> ArrayDescriptor.createDescriptor("VARRAY_TEST", conn);
> CallableStatement csOut= conn.prepareCall("{? = call
> test_ibatis_varray_fuc}");
> String[] elementsOUT=new String[20];
> ARRAY arrayParamOut = new ARRAY (desc, conn, elementsOUT);
> OracleCallableStatement ocs = (OracleCallableStatement)csOut;
> ocs.registerOutParameter(1,
> java.sql.Types.ARRAY,"VARRAY_TEST");
> csOut.execute();
> arrayParamOut=(ARRAY)csOut.getArray(1);
> elementsOUT=(String[])arrayParamOut.getArray();
> for (int i=0;i<elementsOUT.length;i++) {
> System.out.println(elementsOUT[i]);
> }
> conn.commit();
>
> }
>
> the previous code works, my guess is that iBatis does not support this
> kind of mapping mainly because of this line:
> ocs.registerOutParameter(1, java.sql.Types.ARRAY,"VARRAY_TEST");
>
> there is not callback function in typehandler able to support the
> registration of a parameter.
> My proposal is to create a new interface tht extends TypeHandler and
> allows for custom parameter registration; and modify the code of
> SqlExecutor namley the method
> private void registerOutputParameters(CallableStatement cs,
> ParameterMapping[] mappings) throws SQLException {
> in order to accomodate the new feature.
> the new interface should preserve the current typeandler
> implementations and it will allow a new feature which is not bounded
> to a specific database (since custom parameter registration can be
> viewed as a generic JDBC concept).
> does anyone agree with my proposal?
> If yes can i open a Jira issue and try to submit some code?
> Thanks in advance,
> Giovanni
>
>
> --
> --------------------------------------------------------------------
> "You don't know the power of dark side" - Darth Vader
>
--
--------------------------------------------------------------------
"You don't know the power of dark side" - Darth Vader
