Aug 1st, 2011, 12:07 AM
Spring roo 1.5 Hibernate + Derby Problems
I found error when change db from hypersonic_in_memory to derby.
Error Show :
org.springframework.orm.jpa.JpaSystemException: org.hibernate.exception.SQLGrammarException: could not load an entity: ....
Caused by: ERROR 42818: Comparisons between 'VARCHAR (UCS_BASIC)' and 'BIGINT' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')
What's wrong about Derby ?
My script attach below
Aug 1st, 2011, 09:41 PM
You may want to follow this up in the Derby forums. A quick Google search shows the same issue, for example one with Liferay - http://issues.liferay.com/browse/LPS-11978.
This does not appear to be a Roo issue, as it works as you have found with hsqldb
Tags for this Thread