Discussions
Categories
- 196.8K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 544 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.5K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 439 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Update operation/API is allowed only when Order status=DRAFT

Hi,
I have enabled update operation in rest resource file but I want to first check order status of an order and if it is DRAFT then only update is allowed.
where I can add this condition? currently update is working for all the order status
Answers
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,457 Red Diamond
User, tell us your exact JDev version, please!
-
@Timo Hahn Jdev 12C
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,457 Red Diamond
You should not use JDev 12.1.0, it's outdated.
I ask for the exact version because there are about 6-10 different versions out.
Timo
-
Oracle JDeveloper 12c 12.2.1.5.0
-
Timo Hahn Senior Principal Technical Consultant - Oracle ACE Director Member, Moderator Posts: 38,457 Red Diamond
OK, you are using an Oracle internal version that is not available to the public. There might have been some changes in the REST area we don't know about. So to get a definite answer you should use an internal channel.
I can think of two solutions.
1) you create another endpoint (a different view) that only handles rows with DRAFT status. To this endpoint, you allow update operation and remove the update from the other endpoint. This way nobody can update other rows.
2) you implement this business logic directly in the EO by overwriting the prepareForDML() or doDML() methods. Do the check there and throw an exception if your criteria are not matched.
There might be some more elegant way to set some kind of validation to the REST operation, but I don't know about it.
Timo