[jira] Closed: (IBATIS-235) Error in Innline parameter

["Larry Meadors (JIRA)" <ib...@incubator.apache.org>]

     [ http://issues.apache.org/jira/browse/IBATIS-235?page=all ]
     
Larry Meadors closed IBATIS-235:
--------------------------------


> 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 : pthulasiram@yahoo.com

-- 
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