ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sakke Wiik <sakke.w...@gmail.com>
Subject Re: SQLMaps IN-keyword support
Date Wed, 02 Mar 2005 11:37:02 GMT
I moved the CDATA to only wrap the "<"-sign. Still doesn't work. Error
log below.

cheers, Sakke

    public List getXXX(List xxxList, Date xxxDate) {
       Map parameters = new HashMap();
       parameters.put("xxxCodes", xxList);
       parameters.put("xxxDate", xxxDate);
       return queryForList("getXXX", parameters);

sqlmap xml:
   <select id="getXXX" resultMap="result"
           parameterClass="java.util.HashMap">
       SELECT *
       FROM TABLE
       WHERE XXX_DATE <![CDATA[<]]> #xxxDate#
       AND
       XXX_STATUS IN
       <iterate open="(" close=")" conjunction=",">
           #xxxCodes[]#
       </iterate>
   </select>

com.ibatis.dao.client.DaoException: Failed to queryForList - id
[getXXX], parameterObject [{xxxDate=Wed Mar 02 13:30:00 EET 2005,
xxxCodes=[1010, 1011]}].  Cause:
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in
com/basware/dao/persistence/sqlmapdao/sql/xxxLog.xml.
--- The error occurred while preparing the mapped statement for execution.  
--- Check the getXXX.  
--- Check the parameter map.  
--- Cause: com.ibatis.sqlmap.client.SqlMapException: ParameterObject
or property was not a Collection, Array or Iterator.
Caused by: com.ibatis.sqlmap.client.SqlMapException: ParameterObject
or property was not a Collection, Array or Iterator.
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in
com/basware/dao/persistence/sqlmapdao/sql/xxxLog.xml.
--- The error occurred while preparing the mapped statement for execution. 
...


> your issue is that you have the <iterate> tag wrapped in
> <![CDATA[...]]>. When you do that  any tags contained inside the CDATA
> will not be interpreted and will be treatted as a literal.
> 
> Brandon
> 
> 
> On Mon, 28 Feb 2005 09:29:24 +0200, Sakke Wiik <sakke.wiik@gmail.com> wrote:
> > Could you please tell me where to find the documentation for this,
> > because I cannot find it. Maybe I did not give enough details about
> > the problem.
> > The question is how I can give a List as a parameter to a SQLMap query
> > and at the same time other parameters. Here is my settings:
> >
> > dao implementation:
> >
> >     public List getXXX(List xxxList, Date xxxDate) {
> >         Map parameters = new HashMap();
> >         parameters.put("xxxCodes", xxList);
> >         parameters.put("xxxDate", xxxDate);
> >         return queryForList("getXXX", parameters);
> >
> > sqlmap xml:
> >     <select id="getXXX" resultMap="result"
> >             parameterClass="java.util.HashMap">
> >     <![CDATA[
> >         SELECT *
> >         FROM TABLE
> >         WHERE XXX_DATE < #xxxDate#
> >         AND
> >         XXX_STATUS IN
> >         <iterate open="(" close=")" conjunction=",">
> >             #xxxCodes[]#
> >         </iterate>
> >     ]]>
> >     </select>
> >
> > Exception:
> >
> > com.ibatis.dao.client.DaoException: Failed to queryForList - id
> > [getXXX], parameterObject [{maxDate=Mon Feb 28 09:16:40 EET 2005,
> > statusCodes=[1004, 1005]}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:205)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         ... 31 more
> > Caused by: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         ... 37 more
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         ... 37 more
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > com.ibatis.common.beans.ProbeException: Error getting ordinal list
> > from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> >
> > com.ibatis.dao.client.DaoException: Failed to queryForList - id
> > [getXXX], parameterObject [{maxDate=Mon Feb 28 09:16:40 EET 2005,
> > statusCodes=[1004, 1005]}].  Cause:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:205)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         ... 31 more
> > Caused by: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         ... 37 more
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > com.ibatis.common.jdbc.exception.NestedSQLException:
> > --- The error occurred in com/basware/dao/persistence/sqlmapdao/sql/xxx.xml.
> > --- The error occurred while preparing the mapped statement for execution.
> > --- Check the getXXX.
> > --- Check the parameter map.
> > --- Cause: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: For
> > 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.NumberFormatException: For
> > input string: ""
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:184)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: com.ibatis.common.beans.ProbeException: Error getting
> > ordinal list from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         ... 37 more
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > com.ibatis.common.beans.ProbeException: Error getting ordinal list
> > from JavaBean. Cause java.lang.NumberFormatException: 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:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.IdeaJUnitAgent.doRun(IdeaJUnitAgent.java:57)
> >         at com.intellij.rt.execution.junit.TextTestRunner2.startRunnerWithArgs(TextTestRunner2.java:23)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:97)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> > Caused by: java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         ... 43 more
> >
> > Caused by:
> > java.lang.NumberFormatException: For input string: ""
> >         at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
> >         at java.lang.Integer.parseInt(Integer.java:489)
> >         at java.lang.Integer.parseInt(Integer.java:518)
> >         at com.ibatis.common.beans.BaseProbe.getIndexedProperty(BaseProbe.java:51)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getProperty(ComplexBeanProbe.java:297)
> >         at com.ibatis.common.beans.ComplexBeanProbe.getObject(ComplexBeanProbe.java:197)
> >         at com.ibatis.common.beans.GenericProbe.getObject(GenericProbe.java:51)
> >         at com.ibatis.sqlmap.engine.exchange.ComplexDataExchange.getData(ComplexDataExchange.java:65)
> >         at com.ibatis.sqlmap.engine.mapping.parameter.BasicParameterMap.getParameterObjectValues(BasicParameterMap.java:132)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:161)
> >         at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:119)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:610)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:584)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:105)
> >         at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:77)
> >         at com.ibatis.dao.client.template.SqlMapDaoTemplate.queryForList(SqlMapDaoTemplate.java:203)
> >         at com.basware.dao.persistence.sqlmapdao.MessageLogSqlMapDao.getXXX(XXXDao.java:48)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.ibatis.dao.engine.impl.DaoProxy.invoke(DaoProxy.java:72)
> >         at $Proxy1.getXXX(Unknown Source)
> >         at com.basware.dao.persistence.sqlmapdao.TestXXXDao.testgetXXX(TestXXXDao.java:158)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.junit2.JUnitStarter.main(JUnitStarter.java:31)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> >         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> >         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> >         at com.intellij.rt.execution.application.AppMain.main(AppMain.java:68)
> >
> >
> > On Thu, 24 Feb 2005 07:51:44 -0700, Brandon Goodin
> > <brandon.goodin@gmail.com> wrote:
> > > I would suggest you read the manual... it is all in there.
> > >
> > > http://ibatis.com/common/download.html
> > >
> > > Brandon
> > >
> > > On Thu, 24 Feb 2005 09:42:00 +0200, Sakke Wiik <sakke.wiik@gmail.com>
wrote:
> > > > I understand there is a way to use the IN-keyword by giving a List of
> > > > parameters to a query as shown at
> > > > http://issues.apache.org/jira/browse/IBATIS-38, but what if I need to
> > > > give the query other parameters too? I would like to give the query a
> > > > Map where one value is the List for the IN-clause, and other
> > > > parameters too. Is this possible?
> > > >
> > > > cheers,
> > > > Sakke
> > > >
> > >
> >
> > On Thu, 24 Feb 2005 07:51:44 -0700, Brandon Goodin
> > <brandon.goodin@gmail.com> wrote:
> > > I would suggest you read the manual... it is all in there.
> > >
> > > http://ibatis.com/common/download.html
> > >
> > > Brandon
> > >
> > > On Thu, 24 Feb 2005 09:42:00 +0200, Sakke Wiik <sakke.wiik@gmail.com>
wrote:
> > > > I understand there is a way to use the IN-keyword by giving a List of
> > > > parameters to a query as shown at
> > > > http://issues.apache.org/jira/browse/IBATIS-38, but what if I need to
> > > > give the query other parameters too? I would like to give the query a
> > > > Map where one value is the List for the IN-clause, and other
> > > > parameters too. Is this possible?
> > > >
> > > > cheers,
> > > > Sakke
> > > >
> > >
> >
>

Mime
View raw message