biojava/biojava-legacy — pull request #8 by rylarson (2013-07-27 20:46:50+00:00)
Title: Changing note value to "text" type because hsqldb 2.3.0 tries to store i...

I was storing some data from NCBI that was parsed by RichSequence.IOTools.readGenbankDNA() and got the following exception:

Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation; table: SEQFEATURE_QUALIFIER_VALUE column: VALUE

because Hibernate auto-create will map the String value to var-char by default. By setting the hibernate type as text, we avoid the bug by giving the database a large enough store to hold the whole "value" string.