ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Volker_Reichel@t-online.de" <volker_reic...@t-online.de>
Subject AW: ProbeException: Error getting ordinal list from JavaBean
Date Fri, 23 Sep 2005 16:07:50 GMT
Hi Prashanth,

any text within <![CDATA[......]]> is literal text. An XML parser won't
parse any elements the CDATA section might contain.

  -----Urspr√ľngliche Nachricht-----
  Von: Prashanth Sukumaran [mailto:prashanthsukumaran@yahoo.com]
  Gesendet: Freitag, 23. September 2005 17:56
  An: user-java@ibatis.apache.org
  Betreff: Re: ProbeException: Error getting ordinal list from JavaBean


  Hi Team,

  I had this problem as the Query i wrote was within CDATA.   When i removed
the CDATA it works fine.

  Why is this a problem?  What kind of logic is there in IBatis to convert a
String to Integer when it is in CDATA?

  Thanks
  Prashanth.

  Prashanth Sukumaran <prashanthsukumaran@yahoo.com> wrote:
    Hi,
    I am getting a ProbeException when using an iterate tag in sql maps over
a list of string objects.

    Why does this throw an error when the data is a String.  Also why is
IBatis trying to convert it to an Integer.

    I have another query working the same when the List of String is in a
Bean.  The only difference i see is here the list is in a Map.

    Please note that i am just testing the functionality to work for the
List.  Later i will pass a List of invoiceNum to this method.

     public InvoiceDetailBean getInvoiceDetail(String invoiceNum) throws
SystemException {
      Map map = new HashMap();
      List invoiceNumList = new ArrayList();
      invoiceNumList.add(invoiceNum);
      map.put("invoiceNum", invoiceNumList);
      List list = null;
      try {
          list = queryForList("getInvoiceDetail", map);
      } catch (DaoException de) {
       //  throw the exception about transaction failed
       throw new SystemException(de,
         "Unable to retrieve Invoice Detail for "+invoiceNum);
      }
      return list;
     }

    <iterate open="(" close=")" conjunction="OR" property="invoiceNum">

    SLS_HDR.BILL_DOC_NUM = #invoiceNum[]#

    </iterate>



    BILL_DOC_NUM in the bean is defined as String and in the SLS_HDR is a
VARCHAR2


    I am using IBatis version 2.1.5 build 582 against Oracle database.

    Thanks
    Prashanth.



    2005-09-15 17:45:25,210   DEBUG   java.sql.Connection - {conn-100006}
Connection
    2005-09-15 17:45:25,240   ERROR
com.wirelessmob.onlineinvoice.action.InvoiceDetailAction - Search Failed
    com.wirelessmob.onlineinvoice.businesslogic.services.InvoiceException:
Unable to retrieve Invoice Detail for [0092404226]: Unabl
    e to retrieve Invoice Detail for [0092404226]: Failed to queryForList -
id [getInvoiceDetail], parameterObject [{invoice
    NumList=[0092404226]}].  Cause:
com.ibatis.common.jdbc.exception.NestedSQLException:
    --- The error occurred in
com/wirelessmob/onlineinvoice/dataaccess/persistence/sqlmapdao/sql/detailInv
oice.xml.
    --- The error occurred while preparing the mapped statement for
execution.
    --- Check the getInvoiceDetail.
    --- Check the parameter map.
    --- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberForma
    tException: Fo r input string: ""
    Caused by: java.lang.NumberFormatException: For input string: ""
    Caused by: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberForma
    tException: For input string: ""
    Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
    --- The error occurred in
com/wirelessmob/onlineinvoice/dataaccess/persistence/sqlmapdao/sql/detailInv
oice.xml.
    --- The error occurred while preparing the mapped statement for
execution.
    --- Check the getInvoiceDetail.
    --- Check the parameter map.
    --- Cause: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberForma
    tException: For input string: ""
    Caused by: java.lang.NumberFormatException: For input string: ""
            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:18
    8)
            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForL
ist(GeneralStatement.java:123)
            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:610)
            at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExec
utorDelegate.java:584)
            at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionIm
pl.java:101)
            at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl
.java:78)
            at
com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTempl
ate.java:203)
            ... 49 more
    Caused by: com.ibatis.common.beans.ProbeException: Error getting ordinal
list from JavaBean. Cause java.lang.NumberForma
    tException: For input string: ""
    Caused by: java.lang.NumberFormatException: For input string: ""
            at
com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:80)
            at
com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:2
97)
            at
com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197
)
            at
com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:57)
            at
com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExc
hange.java:65)
            at
com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObj
ectValues(BasicParameterMap.java:
    132)
            at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWith
Callback(GeneralStatement.java:16
    5)
            ... 55 more
    Caused by: java.lang.NumberFormatException: For input string: ""
            at
java.lang.NumberFormatException.forInputString(NumberFormatException.java:48
)
            at java.lang.Integer.parseInt(Integer.java:468)
            at java.lang.Integer.parseInt(Integer.java:497)
            at
com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
            ... 61 more




----------------------------------------------------------------------------
    Yahoo! for Good
    Click here to donate to the Hurricane Katrina relief effort.
  __________________________________________________
  Do You Yahoo!?
  Tired of spam? Yahoo! Mail has the best spam protection around
  http://mail.yahoo.com

Mime
View raw message