Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

View Object transient attribute (Calculate sum) using groovy problem

793912Mar 9 2011 — edited Mar 9 2011

Hi

I have a read only view object named "ConnectionVVO". And it has database field name "points"(type is number).
Now I need to take the sum of points.

For this I did the following.

Self view object added to the same view object as a view accessor named "ConnectionVVO1".
Created a transient attribute named "TotalPoints".
Added following groovy as the value expression of the above transient attribute.

adf.object.ConnectionVVO1.getRowSet().sum("points")

after that when I run the application module and run the view object it was extremely slow. Actually nothing was appeared. There after I modified the sql statement and added a where clouse to select few rows.
Then it was appeared without slowness.

The table has around 11 million records.

Could you please provide a hint or any alternate way for doing this(getting the sum of points).

Please help.

Edited by: deshan on Mar 9, 2011 2:56 PM

This post has been answered by Timo Hahn on Mar 9 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2011

Added on Mar 9 2011

#application-development-in-java, #jdeveloper-and-adf

4 comments

2,476 views