[jira] Created: (IBATIS-371) static checking of the inline parameters

["Cesare Zecca (JIRA)" <ib...@incubator.apache.org>]

static checking of the inline parameters
----------------------------------------

                 Key: IBATIS-371
                 URL: http://issues.apache.org/jira/browse/IBATIS-371
             Project: iBatis for Java
          Issue Type: Improvement
          Components: SQL Maps
    Affects Versions: 2.1.7
         Environment: MS Windows 2000, SP4, SUN java 1.5.0_05, Eclipse 3.1.1, iBatis 2.1.7
            Reporter: Cesare Zecca
            Priority: Minor


> causes the following diagnostic
> 

> --- The error occurred in it/finmatica/gpj/aa/frontebd/TipoRiga.xml.  
> --- The error occurred while executing update procedure.   
> --- Check the {? = call tipo_dato_riga.exists_id( ? ) }.  
> --- Check the output parameters (register output parameters failed).  
> --- Cause: java.sql.SQLException : Invalid column type
> Caused by: java.sql.SQLException : Invalid column type
> at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate(
> GeneralStatement.java:91)

[...]

Well, I would spend a few words on the reason of the problem.
I have a micro unit tester class whose purpose is only to load the sql-map-config.xml and the other "resource" SQL map XML files to check their correctness.
If there is some error, iBatis raises its exception and the test fails. Success of the test means that the SQL maps are correct and can be loaded.
That test worked fine with jdbcType=NUMBER.
So, I guessed (wrongly) that the problem was elsewhere.

To cut short: the diagnostic does not help.
Which column has invalid type?
What about a static type checking of the type conversion constants defined by java.sql.Types class and used in the inline parameters?
It would be a good enhancement!


Regards.

See also:

(both thread partially lost)

Re: static checking of the inline parameters
http://www.mail-archive.com/user-java@ibatis.apache.org/msg06993.html

Re: stored function: NUMBER result, NUMBER IN parameter
http://www.mail-archive.com/user-java@ibatis.apache.org/msg06976.html

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira