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