Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 234 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.2K SQL Developer
- 295.3K Development
- 17 Developer Projects
- 138 Programming Languages
- 292K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 27 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 157 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 389 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1K Español
- 1.9K Japanese
- 230 Portuguese
Problem with LOVs started couple of days ago

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
Best 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
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,243 Red Diamond
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
-
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