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!

Oracle ADF Rest - overridden prepareForDML method is not called when there is no change in attribute

Joby-OracleMay 9 2022

In my EOImpl class , I have overridden prepareForDML method to call an external API and based on external API response I have to update an attributes value.
In case of PATCH API call with change in attribute value it works fine , but PATCH API call without any change in attribute's value prepareForDML method is not executed.
Is it possible to call prepareForDML method when there is no change in attribute's value.
Or is there any alternative approach to implement this ?

Comments

thatJeffSmith-Oracle

I don't see any issues in my setup.

Win7, connected to 12c database running on Oracle Linux

Version 17.2.0.188

dbms-output172.png

dz_r

I have the same problem when I'm connected to database 10g.

With database 12c it works.

1 person found this helpful
thatJeffSmith-Oracle

does v4.2 work with your 10g db? and exactly what version of 10g?

Andris Perkons-Oracle

Hi,

I can confirm that 4.2 works with 10g (unpatched 10.2.0.1 on Solaris x86), whereas 17.2 does not.

11g, 12c -> no problems.

Andris

dz_r 
thatJeffSmith-Oracle napisał(-a):
does v4.2 work with your 10g db? and exactly what version of 10g?

SQL Developer 4.2.0.17.089 works fine with database 10g.

New SQL Developer 17.2.0.188 works with:

- Oracle Database 12c Standard Edition Release 12.1.0.2.0

- Oracle Database 11g Enterprise Edition Release 11.2.0.1.0

and doesn't work with:

- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

andre_d

Using Oracle DB 10.2.0.5.0 Standard Edition on Linux x86 64-bit here.

SQL Developer Version 4.2.0.17.089 works

SQL Developer Version 17.2.0.188 does not

thatJeffSmith-Oracle

You'll need to log an SR with MOS on this. I'm assuming you have an extended support contract on 10g since it's about 7 years old.

andre_d

Unfortunately we don't have extended support for that database, so I can't log an SR. But the db will be updated soon, so I don't worry.

But just for my understanding: since the 10.2. database version is out of regular support, it is also not "officially" supported by SQL Developer anymore, only via Extended support?

Gary Graham-Oracle
Answer

As explained in http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf even extended support for 10g expired in July 2013, and any follow-on sustaining support does not include new patches for the database itself, but might get you a SQL Developer fix in a patch or upgrade.  I say "might" since one possible resolution status for a bug is "NOT FEASIBLE TO FIX".

You should also note, due to dependencies with other components in the Oracle stack, that a fix or workaround might not be found only in the database or the application.  Here is a case involving 10g and 17.2 where the workaround is to avoid using older versions of the JDBC driver:

So, in your case, it may possibly make a difference whether you use the default JDBC driver (12.2.0.1) shipped with 17.2, or a previous driver (potentially as old as 11.2.0.3).    

Marked as Answer by andre_d · Sep 27 2020
andre_d

Gary, thanks for the explanation.

I will give changing the JDBC driver a try if I have the time.

1 - 10

Post Details

Added on May 9 2022
#adf, #application-development-in-java, #jdeveloper-and-adf
2 comments
298 views