Announcement Announcement Module
No announcement yet.
Spring roo 1.5 Hibernate + Derby Problems Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    You may want to follow this up in the Derby forums. A quick Google search shows the same issue, for example one with Liferay -
    This does not appear to be a Roo issue, as it works as you have found with hsqldb