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.

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

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

- Update to 3.1.07.42
- while here standardize IGNORE, and drop pkg-message from SUB_FILES
and move to pkg-message as nothing is being substituted

PR:     ports/168163
Submitted by:   maintainer, jjuanino@gmail.com

- Update to 3.0.04.34
- Update pkg-message.in

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

- Get Rid MD5 support

- Update to 2.1.1.64.45

PR:             144744
Submitted by:   Kurt Jaeger <pi@opsec.eu>  (maintainer)

- Update to 2.1.0.63.73

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

- Update to 1.5.4

PR:             132632
Submitted by:   José García Juanino <jjuanino@gmail.com> (maintainer)

- Update to 1.5.3

PR:             129827
Submitted by:   José García Juanino <jjuanino@gmail.com> (maintainer)

Allow JDK versions >1.5.

PR:             127938
Submitted by:   sunghyuk <sunghyuk@gmail.com>
Approved by:    maintainer

- Update to 1.5.1.54.40
 
http://www.oracle.com/technology/products/database/sql_developer/files/relnotes_v151.html
- MySQL dependency is removed due to databases/mysql-connector-odbc is updated
  to 5.1 and this port only supports 5.0 (see pkg-message for details)

PR:             ports/125724
Submitted by:   José García Juanino <jjuanino at gmail.com> (maintainer)

Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)

- Update to 1.5.0.53.38

PR:             ports/123759
Submitted by:   Jose Garcia Juanino <jjuanino@gmail.com>

Oracle SQL Developer is a free graphical tool for database development. With
SQL Developer, you can browse database objects, run SQL statements and SQL
scripts, and edit and debug PL/SQL statements. You can also run any number of
provided reports, as well as create and save your own. SQL Developer enhances
productivity and simplifies your database development tasks.

SQL Developer can connect to any Oracle Database version >= 9.2.0.1 and MySQL
database version >= 3.0.

WWW: http://www.oracle.com/technology/software/products/sql/index.html

PR:             ports/119756
Submitted by:   José García Juanino <jjuanino at gmail.com>