ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Butler" <jeffgbut...@gmail.com>
Subject Re: Can You Map Column Indexes to Properties?
Date Wed, 11 Apr 2007 15:03:35 GMT
You can do it with a result map like this:

<resultMap id="fredResult" class="somepackage.Fred">
  <result property="id" columnIndex="1"/>
  <result property="name" columnIndex="2"/>

Jeff Butler

On 4/11/07, Paul Sanders <tendancer@gmail.com> wrote:
> I have stored procedures that return Oracle REFCURSORs that I want to use
> from iBATIS in Java. I've seen instructions on how to do this but I need
> to
> be able to map column indexes to my bean properties rather than column
> names.
> The reason for this is that our dba's, in their infinite wisdom, just
> renamed all the columns in the latest version of our database to "meet
> standards", but the changes are not being applied to the previous versions
> that the application must still support. An "easy" fix is to have
> different
> SQLMaps for each version but this is yucky. Better still would be to use
> column indexes since the order has not changed, only the names.
> So far I haven't seen any way to do this, but I am brand new to iBATIS -
> anyone got any ideas?
> Thanks
> Paul
> --
> View this message in context:
> http://www.nabble.com/Can-You-Map-Column-Indexes-to-Properties--tf3559865.html#a9941267
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message