Error in Innline parameter
--------------------------

         Key: IBATIS-235
         URL: http://issues.apache.org/jira/browse/IBATIS-235
     Project: iBatis for Java
        Type: Bug
  Components: SQL Maps  
 Environment: java, IAM web spare
    Reporter: thulasiram


My database when over im using the Number field i can't able to select/insert  
the values in my program using ibatis sql map.
If i remove the number field column in my Sqlmap query its working fine.

Example : My table name is : emp.
colums are : emp_id number(8), emp_name varchar2(100). emp_sataus varchar2(50) 
like that.

im using sql map for this insert/select query.

<mapped-statment  name="insertLocationType"
 parameterClass="geoLocation">
insert into emp 9emp_id,emp_name,emp_status) values ( #empid#, #empname#, 
#empstatus#)
</mapped-statment>
this xml file is mapped the  geoLocation.java bean file.

in the bean 
public void seEmpId (int empid )
 {
this.empid = empid;
 }

 public int getEmpId ()
 {
 return this.empid;
 }

in the control i passed the value like Interget oblect using bean set method.

like this :
after calling the reader, resources and XMLbuliders.

Interger intCheck = new Interger(100);
sqlmap.insertoblectlike that ("insertLocationType",interger object name);

seting the values in the bean.

after excuting the file i got following error.
[12/15/05 16:00:02:081 IST] 1d7d6502 SystemErr     R java.sql.SQLException: 
Error executing 'insertEmp' in 'EmpSql.xml'. Check the Parameter Map (or inline 
parameters).  Check the 'empID' property. Cause: 
com.ibatis.common.beans.BeansException: There is no READABLE property named 
'empID' in class 'com.kuwsdb.workflow.ibatisbean.EmpBean'

can u tell me wht is the solution for this.
my id : [EMAIL PROTECTED]


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to