You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Enrico (JIRA)" <ib...@incubator.apache.org> on 2007/07/04 16:23:05 UTC

[jira] Created: (IBATIS-445) SqlText setText function and tab (\t) character in text definition

SqlText    setText function  and tab (\t)   character in text definition
------------------------------------------------------------------------

                 Key: IBATIS-445
                 URL: https://issues.apache.org/jira/browse/IBATIS-445
             Project: iBatis for Java
          Issue Type: Bug
          Components: SQL Maps
    Affects Versions: 2.3.0
         Environment: Z/OS (host platform), IBM DB2 version 7
            Reporter: Enrico
            Priority: Minor


When we have a '\t' character in a query string (reading from configuration file)  the db2 was unabled to cached the preparedStatement Query.
We have resolved this issue rewriting the method setText in class SqlText 

  public void setText(String text) {
    this.text = text.replace('\r', ' ').replace('\n', ' ');
    this.isWhiteSpace = text.trim().length() == 0;
  }

in 

  public void setText(String text) {
    this.text = text.replace('\r', ' ').replace('\n', ' ').replace('\t','');
    this.isWhiteSpace = text.trim().length() == 0;
  }


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


[jira] Closed: (IBATIS-445) SqlText setText function and tab (\t) character in text definition

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

Clinton Begin closed IBATIS-445.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 2.3.1

> SqlText    setText function  and tab (\t)   character in text definition
> ------------------------------------------------------------------------
>
>                 Key: IBATIS-445
>                 URL: https://issues.apache.org/jira/browse/IBATIS-445
>             Project: iBatis for Java
>          Issue Type: Bug
>          Components: SQL Maps
>    Affects Versions: 2.3.0
>         Environment: Z/OS (host platform), IBM DB2 version 7
>            Reporter: Enrico
>            Priority: Minor
>             Fix For: 2.3.1
>
>
> When we have a '\t' character in a query string (reading from configuration file)  the db2 was unabled to cached the preparedStatement Query.
> We have resolved this issue rewriting the method setText in class SqlText 
>   public void setText(String text) {
>     this.text = text.replace('\r', ' ').replace('\n', ' ');
>     this.isWhiteSpace = text.trim().length() == 0;
>   }
> in 
>   public void setText(String text) {
>     this.text = text.replace('\r', ' ').replace('\n', ' ').replace('\t','');
>     this.isWhiteSpace = text.trim().length() == 0;
>   }

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