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!

how to use column auditing in adf with mysql db

Muhammad.RizwanApr 17 2014 — edited Jun 9 2014

Hi,

I am using JDev 11.1.2.4 with MySql as the database.

I want to use audit columns ie. created_by, created_date, modified_date with MySql DB.

when I set track Change History on the EO, it throws below error

(oracle.jbo.SQLStmtException) JBO-33020: Current time is not available from SQL statement "select sysdate from dual".

Any ideas how can I acheive this?

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 7 2014

Added on Apr 17 2014

#application-development-in-java, #jdeveloper-and-adf

5 comments

1,929 views