File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Invalid column name while calling store procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Invalid column name while calling store procedure" Watch "Invalid column name while calling store procedure" New topic

Invalid column name while calling store procedure

pankaj semwal
Ranch Hand

Joined: Oct 07, 2008
Posts: 303
Hi List[],
I am calling store procedure as i am using oracle database .But i am getting the following exception:

My Hbm file
<class name="" table="REMPIM_TB" >
<composite-id >
<key-property name="MPIM_CMPN_NO" type="java.lang.String" ></key-property>
<key-property name="MPIM_CORP_NO" type="java.lang.String" ></key-property>
<key-property name="MPIM_PART_NO_FRM" type="java.lang.String" ></key-property>
<key-property name="MPIM_PART_NO_TO" type="java.lang.String" ></key-property>
<key-property name="MPIM_EMP_NO" type="java.lang.String" ></key-property>
<property name="MPIM_VALID" column="MPIM_VALID" type="java.lang.String" />
<property name="MPIM_VALID_FROM" column="MPIM_VALID_FROM" type="java.sql.Date" />
<property name="MPIM_VALID_TO" column="MPIM_VALID_TO" type="java.sql.Date" />
<property name="MPIM_CRTE_DTIME" column="MPIM_CRTE_DTIME" type="java.sql.Timestamp" />
<property name="MPIM_CRTE_EMP_NO" column="MPIM_CRTE_EMP_NO" type="java.lang.String" />
<property name="MPIM_UPT_DTIME" column="MPIM_UPT_DTIME" type="java.sql.Timestamp" />
<property name="MPIM_UPT_EMP_NO" column="MPIM_UPT_EMP_NO" type="java.lang.String" />
<property name="MPIM_EMP_NAME" formula="FNC_GET_EMPLYEE('H','A10AA','A10AA',MPIM_EMP_NO)"/>


<sql-query name="checkPart" callable="true">
<return class="">
<return-property name="partFrom" column="MPIM_PART_NO_FRM"/>
<return-property name="partTo" column="MPIM_PART_NO_TO" />
{ CALL PROC_PARTCHECK(?,:partFrom,:partTo) }

And my store procedure is

and i am calling like this

Please tell me where i am wrong.

Wouter Oet
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

Does the procedure run correctly as you invoke it directly?
By the way: who is List[]?

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
I agree. Here's the link:
subject: Invalid column name while calling store procedure
It's not a secret anymore!