Hi,
as described in the manual here I declared a custom error message for a Unique Constraint exception.
It works fine with HSQL, but when I use Oracle in Production the Error-Id contains the DB-Schema name and thus my Exception-Message is not recognized/used.
Declared like this:
IDX_DEMO_PRODUCT_UNIQ_NAME = A product with this name already exists
With Oracle the Error-ID is this:
ORACLE_SCHEMA.IDX_DEMO_PRODUCT_UNIQ_NAME
Now it also works if I add the Schema-Name to the Key in the message file, but our problem is, the Schema changes per customer (and it would not work with HSQL).
What can be done to fix this problem?
Thank you