Hi everyone,
I'm having an issue with Oracle SQL Developer Data Modeler (version 24.3.1.351.0831) where I cannot generate Journal Tables scripts. The DDL output for these transformations always comes out blank.
Here is what I have already tried/verified:
-
Script Content: I verified the dr_custom_scripts.xml file is on the directory TYPES. The "After Create" section for "Journal tables" contains the correct JavaScript code (with the CREATE TABLE ..._JN logic).
-
DDL Selection: In the DDL Generation Options, I have selected the "Journal tables" set in the "Include Table DDL Scripts" but never generates any ddl code for Journal.
-
Transformation Test: When I go to Tools -> Design Rules and Transformations -> Table DDL Transformations, select "Journal tables" I only have script for the option "After Create" and if I click "Test", I get an error. It says: "There is no script to be tested/debugged".
And the Error:
And If I choose After Create I get no code for JN, just a simple CREATE
-
JDK Version: I suspected a Nashorn engine issue. I was originally on JDK 21, but I have since installed JDK 11 and pointed to it in my product.conf file using SetJavaHome C:\Program Files\Java\jdk-11.
What am I missing?
Thanks in advance for any help!