You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Rikki Bindra (JIRA)" <ib...@incubator.apache.org> on 2008/02/27 11:53:51 UTC

[jira] Created: (IBATIS-490) When using implicit resultmap, the code fails throwing exception "Undefined Column Name"

When using implicit resultmap, the code fails throwing exception "Undefined Column Name"
----------------------------------------------------------------------------------------

                 Key: IBATIS-490
                 URL: https://issues.apache.org/jira/browse/IBATIS-490
             Project: iBatis for Java
          Issue Type: Bug
    Affects Versions: 2.3.0
         Environment: Windows XP, JDK 1.6, IBatis 2.3, DB2 database on AS400
            Reporter: Rikki Bindra


Hi,

I am using the jt400.jar as the JDBC Driver for accessing data from DB2 database on AS400. The problem is that I want to use implicit resultmap like 

<select id="getProductCount" resultClass="java.util.HashMap">
select * from PRODUCT
</select>

However, the problem is that while populating the HashMap, I have noticed that the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" uses method getColumnLabel() on ResultSetMetaData
My JDBC driver returns the label of the column (containing spaces and which is different than the column name in database). Now the code fails reporting the exception that "Invalid Column Name" has been specified. The problem is in the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" as it should be calling getColumnName() instead of getColumnLabel() on ResultSetMetaData to get the names of the columns.

Please look this ASAP. Looking for a solution at the earliest.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (IBATIS-490) When using implicit resultmap, the code fails throwing exception "Undefined Column Name"

Posted by "Clinton Begin (JIRA)" <ib...@incubator.apache.org>.
     [ https://issues.apache.org/jira/browse/IBATIS-490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Clinton Begin closed IBATIS-490.
--------------------------------

    Resolution: Fixed
      Assignee: Clinton Begin  (was: Jeff Butler)

> When using implicit resultmap, the code fails throwing exception "Undefined Column Name"
> ----------------------------------------------------------------------------------------
>
>                 Key: IBATIS-490
>                 URL: https://issues.apache.org/jira/browse/IBATIS-490
>             Project: iBatis for Java
>          Issue Type: Bug
>    Affects Versions: 2.3.0
>         Environment: Windows XP, JDK 1.6, IBatis 2.3, DB2 database on AS400
>            Reporter: Rikki Bindra
>            Assignee: Clinton Begin
>             Fix For: 2.3.1
>
>
> Hi,
> I am using the jt400.jar as the JDBC Driver for accessing data from DB2 database on AS400. The problem is that I want to use implicit resultmap like 
> <select id="getProductCount" resultClass="java.util.HashMap">
> select * from PRODUCT
> </select>
> However, the problem is that while populating the HashMap, I have noticed that the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" uses method getColumnLabel() on ResultSetMetaData
> My JDBC driver returns the label of the column (containing spaces and which is different than the column name in database). Now the code fails reporting the exception that "Invalid Column Name" has been specified. The problem is in the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" as it should be calling getColumnName() instead of getColumnLabel() on ResultSetMetaData to get the names of the columns.
> Please look this ASAP. Looking for a solution at the earliest.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (IBATIS-490) When using implicit resultmap, the code fails throwing exception "Undefined Column Name"

Posted by "Jeff Butler (JIRA)" <ib...@incubator.apache.org>.
     [ https://issues.apache.org/jira/browse/IBATIS-490?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jeff Butler closed IBATIS-490.
------------------------------

       Resolution: Fixed
    Fix Version/s: 2.3.1

Fixed in SVN.

Thanks for the good diagnosis of this issue!


> When using implicit resultmap, the code fails throwing exception "Undefined Column Name"
> ----------------------------------------------------------------------------------------
>
>                 Key: IBATIS-490
>                 URL: https://issues.apache.org/jira/browse/IBATIS-490
>             Project: iBatis for Java
>          Issue Type: Bug
>    Affects Versions: 2.3.0
>         Environment: Windows XP, JDK 1.6, IBatis 2.3, DB2 database on AS400
>            Reporter: Rikki Bindra
>            Assignee: Jeff Butler
>             Fix For: 2.3.1
>
>
> Hi,
> I am using the jt400.jar as the JDBC Driver for accessing data from DB2 database on AS400. The problem is that I want to use implicit resultmap like 
> <select id="getProductCount" resultClass="java.util.HashMap">
> select * from PRODUCT
> </select>
> However, the problem is that while populating the HashMap, I have noticed that the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" uses method getColumnLabel() on ResultSetMetaData
> My JDBC driver returns the label of the column (containing spaces and which is different than the column name in database). Now the code fails reporting the exception that "Invalid Column Name" has been specified. The problem is in the class "com.ibatis.sqlmap.engine.mapping.result.AutoResultMap" as it should be calling getColumnName() instead of getColumnLabel() on ResultSetMetaData to get the names of the columns.
> Please look this ASAP. Looking for a solution at the earliest.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.