IBatis Invalid Column message for a select
Posted on 2007-08-10
I am facing a tricky problem, Please help me.
I am trying to select an oracle table column which is defined as No
USER_RELEASE NUMBER(2, 0)
and this is a nullable column. my select is like select nvl(user_release,0) from table.
Trying to select using a result map to a java bean. In the bean the attribute userRelease is defined as int.
I tried double and BigDecimal also. For some reason it is giving me invalid column name. It appears like it is not able to assign the value to the java bean attribute. Can any one point me in the right direction ? I am kind of lost here. Here is my result map entry looks like
<result property="userRelease" column="user_release"/>
Really appreciate all your help.