ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From cowwoc <cow...@bbs.darktech.org>
Subject Re: "JDBC requires that the JdbcType must be specified for all nullable parameters"
Date Thu, 08 Apr 2010 02:16:10 GMT

     Done: https://issues.apache.org/jira/browse/IBATIS-771

Gili

On 07/04/2010 9:52 AM, Clinton Begin wrote:
> Yes, that can be reworded and more information is likely possible.
>
> Can you file a Jira ticket for this?
>
> Clinton
>
> On Tue, Apr 6, 2010 at 10:09 PM, cowwoc <cowwoc@bbs.darktech.org 
> <mailto:cowwoc@bbs.darktech.org>> wrote:
>
>     Hi,
>
>        I am getting an error message:
>
>        "JDBC requires that the JdbcType must be specified for all
>     nullable parameters [...] The error may involve <mapper
>     name>-Inline". Granted, telling me the mapper name is useful but I
>     believe we can improve this error message in two regards:
>
>     1. I mistakenly read "nullable parameters" as "nullable columns"
>     and wasted time looking for problems in my database schema. I
>     wonder if others have made a similar mistake...? Is it possible to
>     rephrase this as follows? "Mapper methods cannot accept null
>     arguments without a properly configured JdbcType. Either specify a
>     JdbcType or refrain from passing in null."
>
>     2. I noticed that when this exception is thrown iBatis has quite a
>     bit more information available to it. Is it possible to add the
>     following information to the error message?
>
>     Prepared statement: "SELECT * FROM animals WHERE name = ? AND age
>     > ?", parameter #2 was null
>
>        This would enable me to track down exactly which parameter was
>     equal to null.
>
>     Thank you,
>
>     Gili
>
>     ---------------------------------------------------------------------
>     To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>     <mailto:user-java-unsubscribe@ibatis.apache.org>
>     For additional commands, e-mail: user-java-help@ibatis.apache.org
>     <mailto:user-java-help@ibatis.apache.org>
>
>


Mime
View raw message