Skip to Main Content
Forums

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!

DCIteratorBinding getAllRowsInRange is not getting all rows

DLopezFeb 21 2018 — edited Feb 22 2018

Hi,

Using Jdev 12.2.1.2.

I have a jsff fragment with a table with records of Documents:

- first time some one access it it will show the current day documents;

- after that the user can change the filters to look for a specific document

At the bottom of the page I will show the totals of the documents (counters and other values).

To calculate those totals I will access the Iterator of that table and loop for each record, for that I use DCIteratorBinding getAllRowsInRange to obtain all rows returned from my WebService (REST).

The problem I'm having is:

- that the first time, getAllRowsInRange method returns me 1 row that is empty, so I only see zeros (problem) - I have 3 rows on the original response and the table presents them

- if I change the date filter and execute the service again, getAllRowsInRange will return me the correct amount of rows and will calculate the total amounts (all good)

- if I change the filter back to today's date, it will also work as it should be (all good)

I'm currently out of ideas. Can any one help?

Thanks

Daniel

Comments

Bayanna Kuruba

Hi,

Can you try once like below ,

select * from hr.emp

in the above hr is the schema name and emp table Name. I guess it will useful for you.

Regards,

Bayanna K.

ShayG

Hi,

I will clarify.

I have two schemas lets say one is HR and the second one is  DICTIONARIES.

There's a table in the HR schema called employees, this table has field JOB_TITLE_ID.

There's another table in the DICTIONARIES schema which called JOB_TITLES_DICTIONARY.

So my VO would be based on the EMPLOYEES table in the db it would be HR.EMPLOYEES.

JobtitleId attribute in that VO needs to get it's value from JOB_TITLES_DICTIONARY table from the DICTIONARIES schema.

I have two separate AM each of which points to one of the schemas HrApplicationModule and DictionariesApplicationModule which defined as shared module with session cache level.

On the page there's a table with rows from the HR schema when editing the JobTitle field the supposed to be a List Of Values opened from JobTitlesDictionary  VO in the DictionariesApplicationModule.

Each of the AM's point to a separate data source on the weblogic server.

When I'm running the page I get table or view doesn't exists.

I i define a synonym in the HR schema on JOB_TITLES_DICTIONARY table from DICTIONARIES  schema it will work, meaning the application doesn't accessing the table through the correct data source.

Ajay Taneja

I am sorry, but it make me more sense to replicate the table in same schema.

Any benefit you find to create a new connection to call a lov, let say you run this page so in one time you are creating two connection and would increase by number of users.

ShayG

I our organisation we have multiple systems that refer same dictionaries it's crucial that all systems have updated dictionaries all time.

So there's a centralized schema for all dictionaries and there's people devoted to managing those dictionaries.

So this is a given situation.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 22 2018
Added on Feb 21 2018
#application-development-in-java, #jdeveloper-and-adf, #table
6 comments
1,110 views