Skip to Main Content

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!

New query result overwrites old row in Detail VO

I am facing a weird issue with my code.

The Data Model relationship is like this:
VO1 -> VO2 -> VO3.

All these VO's are based on EO's

Using the API createViewLinkAccessorRS, I push and set the bind parameters for VO2 from VO1 and for VO3 from VO2.

So that when VO1 executequery fires, the bind parameters get set for VO2 and from its VOImpl, get set for VO3 as well.

The code is working fine.
When I traverse down to the attributes in VO3, they are correct.

I execute the query, save its result into a List type variable based on VO1.
When I navigate to the the attribute values for VO3 inside the result variable, they are also correct.

Now if I execute VO1, with bind params like a1, a2 and a3.
Where a1 applies to VO1, a2 applies to VO2 and a3 applies to VO3.

The result when I navigate in the result variable till VO3, will show the row for condition a3.

If I execute for b1, b2 and b3.
I still see the correct result.
That is the result when I navigate in the result variable till VO3, will show the row for condition b3.

Problem is when I execute for a1, a2 and x. After I executed a1, a2 and a3.

As soon as this is executed.
When I see the result variable and navigate it.
I will see 2 rows.
The VO3 will have rows pertaining to condition x.
The earlier fetched row, that pertained to condition a3, is lost.

Please help.

Thanks,
Imran
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2011
Added on Jun 30 2011
0 comments
120 views