ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: SQLMaps IN-keyword support
Date Wed, 02 Mar 2005 13:22:44 GMT
Why not just use &lt; instead of <![CDATA[<]]>?

Seems like a much simpler and more readable solution...

Larry


On Wed, 2 Mar 2005 13:37:02 +0200, Sakke Wiik <sakke.wiik@gmail.com> wrote:
> 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