Skip to main content

Using Database Sequence in ADF BC.

You can use database sequence in ADF BC in different ways and I will explain some of these ways.

1 - Override Create() method in the entity object : this solution depends on create operation, mean when you create new row then the database sequence generate new value, in the entity object select java, then click on edit iconand check Create Method.





Now inside the EntityObjectImpl go to the create() method and add the following code, make sure your key attribute data type is compatible with sequence return value.


2 - Using Groovy Expression : in this way we need to set the key attribute with default value and this value will be expression, this expression will get the sequence value from database sequence, make sure to pick Expression choice.


The expression value will be like 


Also you can write your own method that call database sequence inside the EntityObjectImpl and call it using groovy expression, but you make sure your method return type compatible with key attribute type and pick Expression choice.


3 - Using Database Trigger : I prefer this solution, it's depend on database trigger, so when you create new row the value of key attribute will be generated randomly till you commit your transaction, to activate this way you need to change key attribute data type to DBSequence .



Comments

Anonymous said…
Shooting Craps | Blueprint Casino
You won't find many video games. You can play them at Blueprint 제왕카지노 casino. Learn more. 카지노 Free Online Slots Games. Video Slots. Blueprint Casino. 메리트카지노 Video Slots. Blueprint Casino. Blueprint
How to get to Mohegan Sun Pocono in Wilkes Barre in
Directions to Mohegan Sun Pocono (Things 익산 출장안마 to 서귀포 출장마사지 Know) with public transportation. The following 영주 출장안마 transit 제천 출장안마 lines 안성 출장마사지 have routes that pass near Mohegan Sun

Popular posts from this blog

Oracle ADF Flashing Login Page Issue

Your login page may not have the anonymous-role  inside the *.jazn file.  

Show Page Loader (Progress) when Page Busy, Delay (Long Execution Time).

As we know some actions can take long time to return back the response, in this case the user may do not know what happens at this time, so we need to show or display some indicators that reflect these delays or executions to the user. To get start we need to know some  JavaScript . Inside the target page add popup component and design your own style as you need, I prefer use animated image to reflect the real functionality of loader. Now you need to add the following script inside your page using  <af:resources>  tag, this script will open the popup by id, the yellow color in the images show that. Inside the page add command button to execute your action, this button contains  <af:clientListener>  component  to invoke function in the JavaScript when start executing the action. Button will be execute run method and open popup by invoking JavaScript function. To show the loader we need to make page delay, for test I ...