databases/sqldeveloper24.3.1.347.1826_3

databases/sqldeveloper: Upstream change license from OTN to FUTC

Old license:
 - Oracle Technology Network License Agreement for Business Operations
 - https://www.oracle.com/downloads/licenses/sqldev-license.html
New license:
 - Oracle Free Use Terms and Conditions (Oracle Free License)
 - https://www.oracle.com/downloads/licenses/oracle-free-license.html

PR:		296773
Sponsored by:	UNIS Labs
Co-authored-by:	Ronald Klop <ronald@FreeBSD.org>
MFH:		2026Q3

*/*: bump portrevision after java_default=25 update

Included all ports that have USES=java.

PR:	293559

*/*: bump portrevision after java_default=21 update

PR:	272855

databases/sqldeveloper: Update 24.3.0.284.2209 => 24.3.1.347.1826

Release Notes:
https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.1.html

databases/sqldeveloper: Return of mandatory requirement java 17

Fixes:	0835676e361b (Mk/**java.mk: Convert bsd.java.mk to USES)

Mk/**java.mk: Convert bsd.java.mk to USES

The following features have been added or changed:
- Instead of USE_JAVA use USES=java. This defaults to
  USES=java:build,run if NO_BUILD is undefined. Else it defaults to
  USES=java:run
- Instead of USE_ANT=yes use USES=java:ant which also implies
  USES=java:build
- Instead of JAVA_BUILD=yes use USES=java:build. Does not imply run or
  extract
- Instead of JAVA_EXTRACT=yes use USES=java:extract does not imply
  build or run
- Instead of JAVA_RUN=yes use USES=java:run does not imply extract or
  build
- Instead of USE_JAVA=<version> use USES=java and JAVA_VERSION=<version>

Approved by: mat (portmgr), glewis
Differential Revision:  https://reviews.freebsd.org/D48201

databases/sqldeveloper: Update 23.1.1.345.2114 → 24.3.0.284.2209

Release Notes:
https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.html

Remove SQLDEVELOPER_JAVA_VERSION option - upstream has increased the
minimum Java version to 17.

Remove description for removed option SQLDEVELOPER_JAVA_VERSION.

Fixes:	cd7d2f5169a5 (Update 23.1.1.345.2114 → 24.3.0.284.2209)

databases/sqldeveloper: Update 23.1.1.345.2114 → 24.3.0.284.2209

Release Notes:
https://www.oracle.com/tools/sqldev/sqldev-relnotes-24.3.html

Remove SQLDEVELOPER_JAVA_VERSION option - upstream has increased the
minimum Java version to 17.

databases/sqldeveloper: fix LICENSE, use PREFIX instead of /usr/local

databases/sqldeveloper: limit Java version to 11 and 17

The Java versions supported by this port are in range from 11 to 17. The default
is 11. Add DEFAULT_VERSIONS+=java=N to /etc/make.conf if you want to use Java
"N", but all Java ports will also be affected. Or add SQLDEVELOPER_JAVA_VERSION=N
to /etc/make.conf if you want to override the Java version for this port only.

(Add this message to pkg-message)

*/*: remove GNU_CONFIGURE_MANPREFIX and pet the portclippy

Approved by:	arrowd (mentor)

databases/sqldeveloper: make depends from java/openjfx14 mandatory

The SQLDeveloper distribution has built-in OpenJFX for other OSes,
and it can work with it on FreeBSD (by forcing the path to one of them),
but not all functions work.
We have very little reason to keep this option, then we have a fully
functional port java/openjfx14.

Approved by:	arrowd (mentor)

databases/sqldeveloper: add NO_ARCH=yes and remove JavaFX native libraries for other OSes

This is a Java application using JavaFX from port java/openjfx14.
Also reduce "Flat size" from 545MiB to 422MiB.

Approved by:		arrowd (mentor)
Differential Revision:	https://reviews.freebsd.org/D43410

databases/sqldeveloper: update to 23.1.1.345.2114

Release Notes:
https://www.oracle.com/tools/sqldev/sqldev-relnotes-23.1.1.html

Thanks to vidar from #bsdports @ EFNet.

Approved by:	arrowd (mentor, implicit)

*: Change MAINTAINER on my ports

Approved by: arrowd (mentor)
Differential Revision: https://reviews.freebsd.org/D39935

databases/sqldeveloper: updated to 23.1.0.097.1607

Date: April 2023
Issues Fixed in 23.1.0
There have over 40 issues fixed in this release, a selection of which is
shown below.
21863251 SYNCHRONIZE SPECIFICATION AND BODY WRONG WHEN NOT OPEN BODY
34732911 CVE-2022-42004 REMOTE DENIAL OF SERVICE VULNERABILITY - 2.13.4
30757320 FAILS WHEN CONNECTING TO ASM DATABASE
32507391 FREEZES WHEN RUNNING A LONG QUERY AND LEFT IDLE
33866040 PERFORMANCE OR FREEZING ISSUE ON WINDOWS WHEN INTERACTING WITH
FILE SYSTEM
30662830 MULTIBLOCK INSERTION
27896300 Q STRINGS ARE HAVING CONTENTS REPLACED, POSSIBLE DATA CORRUPTION
35137077 UNSIGNED DLLS SHIPPED WITH SQLDEVELOPER LAUNCHER.DLL
LAUNCHER64.DLL IDENATIVE.DLL
9016009 DISPLAY INCORRECT VALUE
35156951 "DATABASE COPY" TRUNCATING TABLES THAT WERE NOT SELECTED
34765240 TABLE COLUMN COMPLETION OF DICTIONARY SQL
34797866 INSIGHT COLUMN LIST ISN'T SORTED
https://www.oracle.com/tools/sqldev/sqldev-relnotes-23.1.0.html

Approved by: arrowd (mentor)
Differential Revision: D39891

audio/opus: bump consumers after update to 1.4

databases/sqldeveloper: Update to 22.2.1.234.1810

Version 22.2.1.234.1810 - September 12, 2022
Bugs Fixed
34375812 	EDIT TABLE DIALOG FAILS TO LOAD WITH JAVA STACK DUMP
https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.1.html

Version 22.2.0.173.2018 - June 28, 2022
Bugs Fixed
32445960 	SQL DEVELOPER SHOWS FAILED_OVER WHEN A NODE OF 2 NODE RAC FAILOVER
33659339 	SQL DEVELOPER SHOWS FAILED_OVER FOR TAC FAILOVER FOR RAC
34157706 	ORDS GET QUERY CAN BE RUN BUT CAN'T BE SAVED
33735358 	SQL PATROLLER RULE NOT WORKING
34116804 	VALID WHEN CLAUSE ON SYSTEM TRIGGER CAUSES ERROR IN SQL DEVELOPER
34116753 	FORMATTER CAN BREAK TRIGGER CODE
32955926 	EXPORT WIZARD TO EXPORT COLUMNS AND ROWS FROM A TABLE DOES NOT LIMIT THE COLUMNS
34026858 	ACCESSIBILITY: UNABLE TO NAVIGATE TO ADD/REMOVE CONNECTION DETAILS UNDER ADVANCED TAB
https://www.oracle.com/tools/sqldev/sqldev-relnotes-22.2.html

PR:		267044
MFH:		2022Q4

Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)

Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.

This commit implements such a proposal and moves one of the WWW: entries
of each pkg-descr file into the respective port's Makefile. A heuristic
attempts to identify the most relevant URL in case there is more than
one WWW: entry in some pkg-descr file. URLs that are not moved into the
Makefile are prefixed with "See also:" instead of "WWW:" in the pkg-descr
files in order to preserve them.

There are 1256 ports that had no WWW: entries in pkg-descr files. These
ports will not be touched in this commit.

The portlint port has been adjusted to expect a WWW entry in each port
Makefile, and to flag any remaining "WWW:" lines in pkg-descr files as
deprecated.

Approved by:		portmgr (tcberner)

databases/sqldeveloper: Update to 21.4.3.063.0100

ChangeLog: https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.4.3.html

PR:	263527
Reported by:	vvd@unislabs.com (maintainer)

databases/sqldeveloper: Update to 21.4.1.349.1822

PR:		260695
Approved by:	VVD <vvd@unislabs.com> (maintainer)

INSTALLS_ICONS: retire the macro and rework the related dependencies

While here, make sure gtk-update-icon-cache is only on run dependency
where added as a dependency
Enforce gtk3 to depend on gtk-update-icon-cache (previously it was
inheriting the dependency)

databases/sqldeveloper: Update to 21.2.1.204.1703

Changelog:
	https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.2.html

PR:		258267

databases/sqldeveloper: Update to 20.4.1.407.0006

- Update to 20.4.1.407.006

And while here, also Reformat Makefile a bit.

PR:		256397
Approved by:	vvd@unislabs.com (maintainer)

all: Remove all other $FreeBSD keywords.

Remove # $FreeBSD$ from Makefiles.

databases/sqldeveloper: update dependency from java/openjfx8-devel to java/openjfx14 and make it optional

PR:		250704
Submitted by:	VVD <vvd@unislabs.com> (maintainer)

databases/sqldeveloper: Update to 20.2.0.175.1842

Pass maintainership to vvd (approved by Michael Zhilin)

Changelog:
Feature Enhancements
    Debugger - option to use DBMS_DEBUG for database debugging
    Load options include SET LOADFORMAT and SET LOADMETHOD for more flexibility on loading table data
    ORDS installer supports:
        REST SQL and SQL Developer Web configuration
        Custom JDBC urls and TNS
        Allows non-SYSDBA user to install/upgrade, repair and uninstall ORDS
    SQLcl Liquibase new commands: ROLLBACKSQL, DIFF, DBDOC, VERSION
    Liquibase changeSet IDs are now generated as a hash of the content
    Explain Plan/Autotrace Search
    Include Orakafka ZIP in all distributions
    Java Home updated to 8u221
    Oracle NoSQL plugin updated to version 19.3.12
    Database Copy added 'Ignore Storage' to avoid tablespace dependencies
    SQL Editor Code template options panel moved to code editor page
    Code formatter new setting for number of commas to allow before a linebreak on PL/SQL call
    Added SET CODESCAN to look for SQL Injection vulnerabilities
    TABLE IMPORT enhanced to ignore virtual columns

PR:		249866
Submitted by:	VVD <vvd@unislabs.com>

Deprecate java/openjfx8-devel consumers

Chase r527795 and put a deprecation notice on all openjfx8-devel
dependent ports too.

Also deprecate devel/gradle4 which is only needed to build igv and
openjfx8-devel.

Convert to UCL & cleanup pkg-message (categories d)

databases/sqldeveloper: Update to 19.1.0.094.2042

While here, clean up a bit

PR:		237417
Submitted by:	VVD <vvd@unislabs.com)
Reported by:	pi
Approved by:	Michael Zhilin <mizhka@gmail.com> (maintainer)

databases/sqldeveloper: update to 18.4.0.376.1900

PR:		235216
Submitted by:	jjuanino@gmail.com
Approved by:	maintainer timeout (mizhka@gmail.com, >11 weeks)

databases/sqldeveloper: update 17.4.0.355.2349 -> 18.1.0.095.1630

PR:		228196
Submitted by:	jjuanino@gmail.com
Approved by:	Michael Zhilin <mizhka@gmail.com> (maintainer)
Relnotes:	http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-relnotes-181-4423629.html

databases/sqldeveloper: Update to 17.4.0.355.2349

PR:		224912
Submitted by:	jjuanino@gmail.com
Approved by:	mizhka@gmail.com (maintainer)

- Update to 4.2.0.17.089.1709

PR:	219200
Submitted by:	vvd@unislabs.com
Approved by:	rene (mentor)
Differential Revision:	https://reviews.freebsd.org/D10871

Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight

databases/sqldeveloper: 4.1.0.19.07 -> 4.1.1.19.59

Changes:
http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-relnotes-41-2372786.html

PR:		201217
Submitted by:	mizhka@gmail.com (maintainer)

databases/sqldeveloper: 4.0.3.16.84 -> 4.1.0.19.07

Release-Notes:
http://www.oracle.com/technetwork/developer-tools/sql-developer/sqldev-relnotes-41-2372786.html

PR:		200054
Submitted by:	Michael Zhilin <mizhka@gmail.com> (maintainer)

databases/sqldeveloper: version update

- update to 4.0.3.16.84
- pass maintainership to submitter
- unmute installation commands

PR:		196352
Submitted by:	mizhka@gmail.com

Cleanup plist

In some straightforward cases, protect documentation behind PORTDOCS, adding a DOCS option where needed, and a couple PORTEXAMPLES for good measure.

Multiple ports: reset maintainers 	Maintainers for these ports have been notified on 5 separate occasions 	over the course of several months about pending actions required.

We really appreciate the time and effort you put in to maintain
	these ports.

	If you are still interested in helping to maintain these ports just
	reply to me or file a PR and I will happily assign the port to you
	again.

Approved by:	portmgr (implicit)

Update to 4.0.1.14.48

Submitted by:	bar (myself)
Approved by:	jjuanino@gmail.com (maintainer)

Mark a few unfetchable ports BROKEN

With hat:	portmgr

Convert d* to USES=zip

- update to 4.0.0.13.80 - add stage support

PR:		186568
Submitted by:	Jose Garcia Juanino <jjuanino@gmail.com> (maintainer)

Fix properties on pkg-plist

Add NO_STAGE all over the place in preparation for the staging support (cat: databases)

- Update to version 3.2.20.09.87 - Trim Makefile headers - Change NOPORTDOCS check to OptionsNG equivalent

PR:	ports/174066
Submitted by:	bar
Approved by:	jjuanino@gmail.com (maintainer), flo (mentor)
Feature safe:	yes