Forum Stats

  • 3,814,524 Users
  • 2,258,880 Discussions
  • 7,892,765 Comments

Discussions

Problem with LOVs started couple of days ago

Robert Šajina
Robert Šajina Member Posts: 94
edited Jan 23, 2018 5:33AM in JDeveloper and ADF

Hi all,

a couple of days ago we started having problems with LOVs and view objects.

Problems such as:

     - LOV doesen't work in BC Tester

     - LOV is empty

     - when selecting from LOV it takes 10-20 seconds to populate the value ( in BC Tester and on JSF - same behavior)

I have tried to create new simple view objects that only contains one transient field and on that field is added LOV. LOV either doesn't work or is very slow when selecting the value.

Can this have something to do with windows updates? Is it possible that JDeveloper updated itself?
Is anyone experiencing this problem?

JDev; 12.2.1.2.0

Thanks

Robert

Tagged:
Zlatko Sirotic

Best Answer

  • Robert Šajina
    Robert Šajina Member Posts: 94
    edited Jan 23, 2018 5:28AM Answer ✓

    Hi Timo,

    thank you for your response.

    I was measuring the time by watch, where could i add the timing printouts?

    Update: I went to recreate the problem, and than the LOV worked fine.

    I than went to compare XML-s and saw that JDev didn't added ListRangeSize="10" attribute to ListBinding.

    When ListRangeSize is not set, default value is -1, which will retrieve all rows, which in my case was over 10,000 rows.

    It is working now, thank you for your help.

    Robert

    Zlatko Sirotic

Answers

  • Timo Hahn
    Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,243 Red Diamond
    edited Jan 23, 2018 4:27AM

    Can you provide a test case with some timing printouts from your system, based on the HR DB schema?

    We then can run the test case on our systems and compare the times.

    I personally do not see this effect. And JDev normally don't update itself.

    Timo

  • Robert Šajina
    Robert Šajina Member Posts: 94
    edited Jan 23, 2018 5:28AM Answer ✓

    Hi Timo,

    thank you for your response.

    I was measuring the time by watch, where could i add the timing printouts?

    Update: I went to recreate the problem, and than the LOV worked fine.

    I than went to compare XML-s and saw that JDev didn't added ListRangeSize="10" attribute to ListBinding.

    When ListRangeSize is not set, default value is -1, which will retrieve all rows, which in my case was over 10,000 rows.

    It is working now, thank you for your help.

    Robert

    Zlatko Sirotic
This discussion has been closed.