[BioSQL-l] [Biojava-l] Error loading ontology terms

[Yi-Feng Chang]

Thanks, your solution is right.
I solve this problem.
Many thanks.

ian

Andreas Dr輍er wrote:
> Hello,
>
> You can solve this problem just by renaming the column "synonym" in
> table "term_synonym" to "name". The reason for changing the name of
> this column is that in some database systems the term "synonym" is a
> reserved word. So the older version that you are using currently might
> cause problems with some databas systems. Once you renamed this
> column, BioJava will work fine.
>
> Andreas Dr輍er
>
>> java.sql.SQLException: Unknown column 'name' in 'field list'
>>
>>
>