You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@camel.apache.org by "Willem Jiang (JIRA)" <ji...@apache.org> on 2012/09/10 16:58:07 UTC

[jira] [Resolved] (CAMEL-5551) String types not converted from CLOB

     [ https://issues.apache.org/jira/browse/CAMEL-5551?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Willem Jiang resolved CAMEL-5551.
---------------------------------

       Resolution: Fixed
    Fix Version/s: 2.10.2
                   2.11.0
                   2.9.4

Applied patch into trunk, camel 2.9.x and camel 2.10.x branch with thanks to Shaun.
                
> String types not converted from CLOB
> ------------------------------------
>
>                 Key: CAMEL-5551
>                 URL: https://issues.apache.org/jira/browse/CAMEL-5551
>             Project: Camel
>          Issue Type: Improvement
>          Components: camel-jdbc
>         Environment: Microsoft SQL Server, JTDS driver
>            Reporter: Shaun Elliott
>            Assignee: Willem Jiang
>             Fix For: 2.9.4, 2.11.0, 2.10.2
>
>         Attachments: CAMEL-5551-patch.txt
>
>
> Not all JBDC drivers support "getObject" on the resultset the same way. In particular, the jtds driver returns back a "ClobImpl" type Object when "getObject" is called on some text\varchar(MAX) columns.
> The simple solution is to check the column type and if it is a Clob\Blob or other known String type, call "getString" instead.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira