IBatis Invalid Column message  for a select

Posted on 2007-08-10
Last Modified: 2013-11-13
Hi Experts,
I am facing a tricky problem, Please help me.
I am trying to select an oracle table column which is defined as  No      
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.

Question by:json123
    LVL 16

    Accepted Solution

    Try to change your select from
    "select nvl(user_release,0) from table"
    "select nvl(user_release,0) as user_release from table"


    Author Comment

    Thank you so much, that works perfect.

    LVL 16

    Expert Comment

    Glad I could help.


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Suggested Solutions

    This is about my first experience with programming Arduino.
    Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now