You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Dhananjay Patkar (JIRA)" <ib...@incubator.apache.org> on 2009/04/05 17:28:14 UTC

[jira] Created: (IBATIS-591) com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list
---------------------------------------------------------------------------------

                 Key: IBATIS-591
                 URL: https://issues.apache.org/jira/browse/IBATIS-591
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.1
            Reporter: Dhananjay Patkar


I am using Spring( 2.0.7) ,Ibatis ( 2.3.0)  with MySQL (5.1.30-community)
Trying to execute a MySQL procedure with several in parameters and 1 out parameter.
Procedure executes successfully ,Records gets inserted and updated in database when called from UI ,but it throws exception at the end... attached exception log with this post.
Trying hard to crack it...
Please help me to solve this issue.


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

[jira] Closed: (IBATIS-591) com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list

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

Dhananjay Patkar closed IBATIS-591.
-----------------------------------

    Resolution: Invalid

> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list
> ---------------------------------------------------------------------------------
>
>                 Key: IBATIS-591
>                 URL: https://issues.apache.org/jira/browse/IBATIS-591
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.1
>            Reporter: Dhananjay Patkar
>         Attachments: exceptionLog.txt
>
>
> I am using Spring( 2.0.7) ,Ibatis ( 2.3.0)  with MySQL (5.1.30-community)
> Trying to execute a MySQL procedure with several in parameters and 1 out parameter.
> Procedure executes successfully ,Records gets inserted and updated in database when called from UI ,but it throws exception at the end... attached exception log with this post.
> Trying hard to crack it...
> Please help me to solve this issue.

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

[jira] Commented: (IBATIS-591) com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list

Posted by "Dhananjay Patkar (JIRA)" <ib...@incubator.apache.org>.
    [ https://issues.apache.org/jira/browse/IBATIS-591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12698329#action_12698329 ] 

Dhananjay Patkar commented on IBATIS-591:
-----------------------------------------

Updated iBatis to 2.3.4 but same exception..
Then I modified procedure as to work around exception , and it worked.
I am concluding this is an issue with MySQL ,and not with the iBatis.
Closing this JIRA
Still If you wish to have a look at it,Will post my procedures for further investigation,Please let me know

> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list
> ---------------------------------------------------------------------------------
>
>                 Key: IBATIS-591
>                 URL: https://issues.apache.org/jira/browse/IBATIS-591
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.1
>            Reporter: Dhananjay Patkar
>         Attachments: exceptionLog.txt
>
>
> I am using Spring( 2.0.7) ,Ibatis ( 2.3.0)  with MySQL (5.1.30-community)
> Trying to execute a MySQL procedure with several in parameters and 1 out parameter.
> Procedure executes successfully ,Records gets inserted and updated in database when called from UI ,but it throws exception at the end... attached exception log with this post.
> Trying hard to crack it...
> Please help me to solve this issue.

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

[jira] Commented: (IBATIS-591) com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list

Posted by "Kai Grabfelder (JIRA)" <ib...@incubator.apache.org>.
    [ https://issues.apache.org/jira/browse/IBATIS-591?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12695869#action_12695869 ] 

Kai Grabfelder commented on IBATIS-591:
---------------------------------------

can you reproduce this with ibatis 2.3.4?

> com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column in field list
> ---------------------------------------------------------------------------------
>
>                 Key: IBATIS-591
>                 URL: https://issues.apache.org/jira/browse/IBATIS-591
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.1
>            Reporter: Dhananjay Patkar
>         Attachments: exceptionLog.txt
>
>
> I am using Spring( 2.0.7) ,Ibatis ( 2.3.0)  with MySQL (5.1.30-community)
> Trying to execute a MySQL procedure with several in parameters and 1 out parameter.
> Procedure executes successfully ,Records gets inserted and updated in database when called from UI ,but it throws exception at the end... attached exception log with this post.
> Trying hard to crack it...
> Please help me to solve this issue.

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