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.
Note for Oracle users:
In order to connect in a simple way to an Oracle database, it is needed to
set ORACLE_HOME environment variable and then locate in a
$ORACLE_HOME/network/admin/ directory a valid tnsnames.ora services file.
Alternatively, you can set TNS_ADMIN to point out directly to that
tnsnames.ora file.
After that choose "TNS" as "Connection Type" when you are going to add a
new connection database.
Note for MySQL users:
If you have enabled mysql support, it is needed to point out to SQL
Developer where the MySQL JDBC classes are. Go to Tools -> Preferences
menu, select Database -> Third Party JDBC Drivers and add the proper jar.
Do not install 5.1 version of mysql jdbc connector; see
https://docs.oracle.com/en/database/oracle/sql-developer/18.4/rptig/installing-sql-developer.html#GUID-3F68CF20-D03D-431C-A9A2-0EB971F06448
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: 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)
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: 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
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.
(Only the first 15 lines of the commit message are shown above )
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 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)
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
(Only the first 15 lines of the commit message are shown above )
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.
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)
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 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
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)
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>
