[
https://issues.apache.org/jira/browse/SOLR-1348?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12741050#action_12741050
]
Avlesh Singh commented on SOLR-1348:
------------------------------------
I have used "cast()" function in MySQL to convert my blob columns in the result
set to strings.
> JdbcDataSource does not import Blob values correctly by default
> ---------------------------------------------------------------
>
> Key: SOLR-1348
> URL: https://issues.apache.org/jira/browse/SOLR-1348
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 1.4
> Reporter: Jay Clelland
> Assignee: Noble Paul
> Priority: Minor
>
> When blob values are returned through a java ResultSet Object they have the
> type byte[].
> As byte[] doesn't have a useful toString method we end up with a reference
> type value added to the solr document (i.e. [...@1f23c5).
> The problem is easy to remedy by adding the attribute 'convertType="true"' to
> the dataSource tag within data-config.xml.
> However this attribute does not appear to be documented anywhere and I was
> only able to find it after a few hours digging through the source code.
> A simple fix for this would be to change the default value of convertType to
> true within the JdbcDataSource class.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
