I test a table with ony 2 records. This table's properties are: MyISAM, utf8 
character set, utf8_general_ci collation. the conents are html source with 
Chinese characters.  I doesn't specify any schema.xml but only setup 
db-data-config.xml as follows:
<dataConfig>
  <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" 
url="jdbc:mysql://localhost:3306/test" user="root" password="win32k" 
batchSize="1" />
  <document>
    <entity name="testdih" query="SELECT * FROM doctest">
      <field column="docid" name="aid" />
      <field column="docdate" name="adate" />
      <field column="doctitle" name="atitle" />
      <field column="docbody" name="acontents" />
    </entity>
  </document>
</dataConfig>

When I do DIH, the solr.log shows:

"Unable to execute SELECT * FROM ..." 
...
...
...
Caused by: java.sql.SQLException: Unknown character set index for field '224'.

What's does this error message mean?
 
scott.chu,scott....@udngroup.com
2016/5/24 (週二)

Reply via email to