Monday Apr 07, 2014

ADF and alternate unique keys revisited

Today I'd like to share a quick (and dirty) trick to handle one nuisance of well known pattern to achieve uniqueness of "non-primary key" ADFBC entity attributes. If you ever needed to enforce a particular attribute to contain globally unique values you may end up with two solutions:

1. Check it on the db site and then handle the unique constraint violation exception in DCExceptionHandler replacing dirty SQL message with a pretty one that you provide

2. Try to catch it before it even reaches DB and handle it in a nice way using entity validation messages

Obviously the second approach seems to be much better from both architectural and practical point of view (let alone the fact that it does not rule out using the former one at the same time!).

[Read More]
About

Oracle ECEMEA Partner Hubs Migration Center Team

We share our skills to maximize your revenue!
Rapidly and successfully assist you to adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
partner.imc
@
beehiveonline.oracle-DOT-com
Google+

Search

Archives
« March 2015
SunMonTueWedThuFriSat
1
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today