Nutch2.1 + Hsql2.2.9 java.sql.BatchUpdateException: data exception: string data, right truncation

[高睿]

Hi,

I can't run Nutch 2.1 with Mysql, then I tried Hsql, failed again. So, which 
database are you using for nutch 2.1. I spent too much time on this and can not 
make it work.

2013-01-03 16:12:06,812 WARN  mapred.FileOutputCommitter - Output path is null 
in cleanup
2013-01-03 16:12:06,835 WARN  mapred.LocalJobRunner - job_local_0008
java.io.IOException: java.sql.BatchUpdateException: data exception: string 
data, right truncation
        at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:340)
        at org.apache.gora.sql.store.SqlStore.close(SqlStore.java:185)
        at 
org.apache.gora.mapreduce.GoraRecordWriter.close(GoraRecordWriter.java:55)
        at 
org.apache.hadoop.mapred.MapTask$NewDirectOutputCollector.close(MapTask.java:651)
        at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:766)
        at org.apache.hadoop.mapred.MapTask.run(MapTask.java:370)
        at 
org.apache.hadoop.mapred.LocalJobRunner$Job.run(LocalJobRunner.java:212)
Caused by: java.sql.BatchUpdateException: data exception: string data, right 
truncation
        at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
        at org.apache.gora.sql.store.SqlStore.flush(SqlStore.java:328)
        ... 6 more

Regards,
Rui