You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "thulasiram (JIRA)" <ib...@incubator.apache.org> on 2005/12/15 12:41:45 UTC

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

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


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

Posted by "Larry Meadors (JIRA)" <ib...@incubator.apache.org>.
     [ http://issues.apache.org/jira/browse/IBATIS-235?page=all ]
     
Larry Meadors resolved IBATIS-235:
----------------------------------

    Resolution: Invalid

Please post support issues to the mailing lists.

http://ibatis.apache.org/mailinglists.html

Larry


> 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


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

Posted by "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