Skip to Main Content

Java User Groups

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!

New Java licensing

4111092Aug 21 2020 — edited Sep 17 2020

I am confused with the new Java Licensing. We were recently told the following below and talked to someone who said we will have to license java going forward. Is that true?

So if I purchase software from a vendor that requires java, I have to pay a license fee to use this software on my desktop?

  1. 1. January 2019 - Java 8 went End of Public Update (EOPU) in January 2019. The last publicly available update for Java 8 is update 201 & 202. No more public patches and updates will be released for this version. Oracle will be supporting, patching, and updating Java 8 through 2030 for subscription customers.

  Notable Security Patches

: Java 8 - Six non-public Critical Patch Updates have been released since Java 8 went End of Public Updates. Across these updates, 53 known security vulnerabilities have been remediated

  1. September 2018 - Oracle Java 11 released September 25th, 2018.

  1. Starting with Java 11, Oracle’s commercial Java SE binaries, the Oracle JDK/JRE, will follow standard Oracle licensing - free for development and evaluation, but requiring a commercial license for production use.

Comments

Mike Kutz

It looks like table TEST1 is being used as a temp table.
In Forms, this should probably have been a GTT.
GTTs don't work in APEX dye to Connection Pooling. You'd use a Collection instead.
But, I'm just guessing about the purpose of TEST1.
(PS - you should probably have just done an INSERT... SELECT instead of parsing a cursor in a loop)

SANPAT

Dear Mike Kutz
I want to delete all the old records from test1. then i want to update the table with the latest Query data from test table. can you suggest how to insert the records using the procedure in Oracle Apex .
Delete all Data from A Table
Query on Table B and get the data
Insert the Query data into A Table.
Sanjay

Mike Kutz
Answer

APEX is stateless. It automatically calls COMMIT as needed (or ROLLBACK ).
I'd keep it simple, Sanjay (K.I.S.S.)

BEGIN
  DELETE FROM TEST1;

  INSERT INTO TEST1 (empno,name)
    SELECT empno, name FROM EMPLOYEE;
END;
Marked as Answer by SANPAT · Oct 17 2021
SANPAT

Dear Mike Kutz
Thanks , your given Query is perfectly runing on Sql Command, but the same Query when i update in the Form at server side condition , it's not working . it truncate the data but not updating with fresh data from the called table.
image.png
image.pngKindly sugget .
Sanjay

AndyH

As you are running this from a Dynamic Action it will be running in a different database session to that of your page. If your page hasn't committed it's data, the session in your DA will not see that data.
Is there a particular reason you are doing this work through a DA and not through a process?

SANPAT

Dear AndyH
I am new to Oracle Apex and Learning , Can you please give me some tips , how to take such query from Process.
Its getting executed properly , but i don't know how to display the message once the Procedure Query will update the table . Can you please suggest.
Sanjay

1 - 6

Post Details

Added on Aug 21 2020
1 comment
430 views