ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brandon Goodin <brandon.goo...@gmail.com>
Subject Re: ibatis says "no results" but query does return results
Date Thu, 07 Apr 2005 14:10:25 GMT
It would help if you posted the sqlmap, the sqlmap config, associated
property files and the full code that calls the sqlmap.

Brandon

On Apr 6, 2005 12:50 PM, Dan Tenenbaum <dandante@dandante.com> wrote:
> I am running  a query from ibatis and I get this error:
> 
> java.lang.reflect.UndeclaredThrowableException
>         at $Proxy9.getVisibleSelectedIds(Unknown Source)
>         at
> (...)
>         ... 18 more
> Caused by: com.ibatis.dao.client.DaoException: Error executing query for
> list.  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred while applying a parameter map.
> --- Check the getVisibleSelectedTopicIds-InlineParameterMap.
> --- Check the results (failed to retrieve results).
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:
> --- The error occurred while applying a parameter map.
> --- Check the getVisibleSelectedTopicIds-InlineParameterMap.
> --- Check the results (failed to retrieve results).
> --- Cause: java.lang.NullPointerException
> Caused by: java.lang.NullPointerException
> (...)
> 
> However, the logger output of the query in question is as follows:
> 
> 11:41:56,523 DEBUG PreparedStatement:28 - {pstm-100138}
> PreparedStatement:       select id from topics where id in
> (                ?     ,       ?             )    and id not in (
> select topic_key from topic_eligibility where is_visible = false
> and sponsor_key in
> (                   ?      ,        ?                  )     )     order
> by patient_title
> 11:41:56,524 DEBUG PreparedStatement:29 - {pstm-100138} Parameters:
> [125, 126, 1, 2]
> 11:41:56,525 DEBUG PreparedStatement:30 - {pstm-100138} Types:
> [java.lang.Integer, java.lang.Integer, java.lang.Integer,
> java.lang.Integer]
> 11:41:56,530 DEBUG ResultSet:24 - {rset-100139} ResultSet
> 
> (The funny spacing in the SQL query is due to it being in an xml file,
> and some of it comes from the <iterate> tag.)
> Anyway, if I take that query (from the logger output) and paste it into
> a database client, and replace the question marks with the parameters
> output by the logger above, the query runs and returns data, just as I
> expect it to. (The database is in exactly the same state). So why is it
> that I can run this query manually, but when run from IBATIS it doesn't
> return data?
> 
> I have actually run into a couple of cases where iBATIS threw an error
> that turned out to be about something other than what it claimed. But in
> this case, it really does seem to be this query, because I have isolated
> it from everything else to verify that.
> 
> Thanks....
> 
>

Mime
View raw message