Announcement Announcement Module
Collapse
No announcement yet.
Roo generated AspectJ, Hibernate to Oracle now point to Postgresql with problems Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Roo generated AspectJ, Hibernate to Oracle now point to Postgresql with problems

    Hi all,

    I am struggling to change a roo generated project from Oracle, but with loads of NamedNativeQuery, to Postgres. I am not sure these namedNativeQuery need to change or simply changed the Hibernate dialect to Postgresql is enough.
    Some suggested to update the Hibernate version, but not very helpful. Mainly the errors are operator not found for e.g. UPPER(bytea) or varying character = bytea. These seem to be data type not matching. So far I have been struggling to solve this problem for more than a week, still has no idea where the problem is.

    Some suggested to use Roo to re-generate the code but target to Postgres, however, as loads of classes are modified since they were generated. It would be lots of work to merge. I really hope some will help me.

    Thank you

    Duncan
Working...
X