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 (週二)