Spring roo 1.5 Hibernate + Derby Problems

[nancom.roo]

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

[Alan Stewart]

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