lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roy Liu <liuchua...@gmail.com>
Subject How to index MS SQL Server column with image type
Date Thu, 07 Apr 2011 09:01:56 GMT
Hi all,

When I index a column(image type) of a table  via *
http://localhost:8080/solr/dataimport?command=full-import*
*There is a error like this: String length must be a multiple of four.*

Any help?
Thank you very much.

PS. the attachment includes Chinese character.

------------------------------------------------------------
*1. data-config.xml*
<dataConfig>
 <dataSource type="JdbcDataSource"
             driver="net.sourceforge.jtds.jdbc.Driver"
             url="jdbc:jtds:sqlserver://host:1433/db"
             user="username"
             password="password"/>

 <document>
   <entity name="doc"
           query="select id,*attachment*,filename as title from attachment
where ext='doc' and id>10000">
*           <field column="attachment" name="bs_attachment"/>*
   </entity>
 </document>
</dataConfig>

*2. schema.xml*
<field name="bs_attachment" type="binary" indexed="true" stored="true"/>

*3. Database*
*attachment *is a column of table attachment. it's type is IMAGE.


Best Regards,
Roy Liu

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message