You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Clinton Begin <cl...@gmail.com> on 2010/04/07 15:52:41 UTC
Re: "JDBC requires that the JdbcType must be specified for all
nullable parameters"
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 <co...@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
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>
Re: "JDBC requires that the JdbcType must be specified for all nullable
parameters"
Posted by cowwoc <co...@bbs.darktech.org>.
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
> <ma...@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
> <ma...@ibatis.apache.org>
> For additional commands, e-mail: user-java-help@ibatis.apache.org
> <ma...@ibatis.apache.org>
>
>