[CAMEL-5551] String types not converted from CLOB

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.9.4, 2.10.2, 2.11.0
• Component/s: camel-jdbc

Environment

Microsoft SQL Server, JTDS driver

• Patch Info: Patch Available
• Estimated Complexity: Unknown
• Assignee: Willem Jiang
• Reporter: Shaun Elliott
• Created: 29/Aug/12 18:12
• Updated: 10/Sep/12 14:57
• Resolved: 10/Sep/12 14:57

Description

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.