Re: IBATIS support for postgres cursors

From: <Zeeshan(dot)Ghalib(at)globaldatapoint(dot)com>
To: <guyr-ml1(at)burntmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: IBATIS support for postgres cursors
Date: 2010-08-31 11:26:57
Message-ID: EB32C6744F73834AA2A3E17182E4292D167508@MS10.lsc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>
> How did you get OTHER to work? Did you define your own TypeHandler?

That's the only change we had to make. The Java code works as is. We only changed the jdbcType from "ORACLECURSOR" TO "OTHER"

<parameterMap id="getUsersParam" class="Map">
<parameter property="results" jdbcType="OTHER" javaType="java.sql.ResultSet" mode="OUT" resultMap="allUsersResult"/>
<parameter property="errors" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT"/>
</parameterMap>

Thanks,

Zeeshan
This e-mail is confidential and should not be used by anyone who is not the original intended recipient. Global DataPoint Limited does not accept liability for any statements made which are clearly the sender's own and not expressly made on behalf of Global DataPoint Limited. No contracts may be concluded on behalf of Global DataPoint Limited by means of e-mail communication. Global DataPoint Limited Registered in England and Wales with registered number 3739752 Registered Office Middlesex House, 34-42 Cleveland Street, London W1T 4LB

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stavroula Gasparotto 2010-08-31 12:14:52 GiN indexes
Previous Message yasin malli 2010-08-31 07:50:53 Re: pg_dump --compress error