| Port details |
- sqldeveloper Graphical tool for database development
- 24.3.0.284.2209 databases
 =2      23.1.1.345.2114_3Version of this port present on the latest quarterly branch.  IGNORE: due to Oracle license restrictions, you must fetch the source distribution manually. Please access https://www.oracle.com/tools/downloads/sqldev-downloads.html with a web browser and follow the link for the sqldeveloper-24.3.0.284.2209-no-jre.zip. You will be required to register and log in, but you can create an account on that page. After registration and accepting the Oracle License, download the distribution file, sqldeveloper-24.3.0.284.2209-no-jre.zip, into /usr/ports/distfiles/oracle/ and then restart this installation
- Maintainer: vvd@FreeBSD.org
- Port Added: 2008-04-05 20:26:52
- Last Update: 2024-10-20 10:21:21
- Commit Hash: 0ac9a2b
- People watching this port, also watch:: jdictionary, py311-Automat, py311-python-gdsii, py39-PyOpenGL, p5-Sane
- Also Listed In: java
- License: OTN
- WWW:
- https://www.oracle.com/database/technologies/appdev/sqldeveloper-landing.html
- Description:
- 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.
  ¦  ¦  ¦  ¦ 
- Manual pages:
- FreshPorts has no man page information for this port.
- pkg-plist: as obtained via:
make generate-plist - Dependency lines:
-
- sqldeveloper>0:databases/sqldeveloper
- To install the port:
- cd /usr/ports/databases/sqldeveloper/ && make install clean
- We doubt a package is available for this port because we see it marked as as:
- Ignore
- Package not available
Packages are normally not provided for ports that are marked as above.- To add the package, run one of these commands:
- pkg install databases/sqldeveloper
- pkg install sqldeveloper
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.- PKGNAME: there is no package for this port: _LICENSE_RESTRICTED = delete-package delete-distfiles
- Flavors: there is no flavor information for this port.
- distinfo:
- TIMESTAMP = 1729415847
SHA256 (oracle/sqldeveloper-24.3.0.284.2209-no-jre.zip) = fd931ea992a99f3330bd4dcaa6ae07d99366c7b07c7e4f6bba8ff131e9641dd2
SIZE (oracle/sqldeveloper-24.3.0.284.2209-no-jre.zip) = 583624745
No package information for this port in our database- Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link:
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Runtime dependencies:
-
- openjfx14>=0 : java/openjfx14
- bash : shells/bash
- java : java/openjdk17
- There are no ports dependent upon this port
Configuration Options:- No options to configure
- Options name:
- databases_sqldeveloper
- USES:
- gnome zip
- pkg-message:
- For install:
- 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
- Master Sites:
- There is no master site for this port.
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
24.3.0.284.2209
20 Oct 2024 10:21:21
 |
Vladimir Druzenko (vvd) |
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) |
24.3.0.284.2209
20 Oct 2024 10:13:35
|
Vladimir Druzenko (vvd) |
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. |
23.1.1.345.2114_3
01 Aug 2024 00:33:15
|
Vladimir Druzenko (vvd) |
databases/sqldeveloper: fix LICENSE, use PREFIX instead of /usr/local |
23.1.1.345.2114_3
29 Jun 2024 22:49:54
|
Vladimir Druzenko (vvd) |
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) |
23.1.1.345.2114_2
13 Apr 2024 14:39:12
|
Vladimir Druzenko (vvd) |
*/*: remove GNU_CONFIGURE_MANPREFIX and pet the portclippy
Approved by: arrowd (mentor) |
23.1.1.345.2114_2
12 Jan 2024 17:17:51
|
Vladimir Druzenko (vvd) |
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) |
23.1.1.345.2114_1
12 Jan 2024 09:38:08
|
Vladimir Druzenko (vvd) |
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 |
23.1.1.345.2114
09 Jan 2024 00:01:28
|
Vladimir Druzenko (vvd) |
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) |
23.1.0.097.1607
02 May 2023 16:52:38
|
Vladimir Druzenko (vvd) |
*: Change MAINTAINER on my ports
Approved by: arrowd (mentor)
Differential Revision: https://reviews.freebsd.org/D39935 |
23.1.0.097.1607
02 May 2023 11:30:03
|
Vladimir Druzenko (vvd) |
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 |
22.2.1.234.1810_1
25 Apr 2023 15:17:15
|
Christian Weisgerber (naddy) |
audio/opus: bump consumers after update to 1.4 |
22.2.1.234.1810
15 Oct 2022 18:26:34
|
Nuno Teixeira (eduardo)
Author: VVD |
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 |
07 Sep 2022 21:58:51
|
Stefan Eßer (se) |
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) |
21.4.3.063.0100
07 Sep 2022 21:10:59
|
Stefan Eßer (se) |
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  ) |
21.4.3.063.0100
29 Apr 2022 16:59:13
|
Fernando Apesteguía (fernape)
Author: Robert Clausecker |
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) |
21.4.1.349.1822
12 Jan 2022 19:10:48
|
Tobias C. Berner (tcberner)
Author: Chris Moerz |
databases/sqldeveloper: Update to 21.4.1.349.1822
PR: 260695
Approved by: VVD <vvd@unislabs.com> (maintainer) |
21.2.1.204.1703
10 Oct 2021 19:44:42
|
Baptiste Daroussin (bapt) |
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) |
21.2.1.204.1703
05 Sep 2021 06:40:21
|
Tobias C. Berner (tcberner)
Author: VVD |
databases/sqldeveloper: Update to 21.2.1.204.1703
Changelog:
https://www.oracle.com/tools/sqldev/sqldev-relnotes-21.2.html
PR: 258267 |
20.4.1.407.0006
04 Jun 2021 12:21:06
|
Juraj Lutter (otis)
Author: Chris Moerz |
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) |
20.2.0.175.1842_1
06 Apr 2021 14:31:13
|
Mathieu Arnold (mat) |
all: Remove all other $FreeBSD keywords. |
20.2.0.175.1842_1
06 Apr 2021 14:31:07
|
Mathieu Arnold (mat) |
Remove # $FreeBSD$ from Makefiles. |
20.2.0.175.1842_1
31 Oct 2020 17:33:04
 |
mikael |
databases/sqldeveloper: update dependency from java/openjfx8-devel to
java/openjfx14 and make it optional
PR: 250704
Submitted by: VVD <vvd@unislabs.com> (maintainer) |
20.2.0.175.1842
03 Oct 2020 08:11:28
|
mikael |
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 ) |
19.1.0.094.2042
19 Mar 2020 09:33:13
|
tobik |
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. |
19.1.0.094.2042
13 Aug 2019 16:01:59
 |
mat |
Convert to UCL & cleanup pkg-message (categories d) |
19.1.0.094.2042
26 May 2019 18:25:03
|
swills |
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) |
18.4.0.376.1900
19 Apr 2019 14:26:25
|
swills |
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) |
18.1.0.095.1630
12 May 2018 17:13:52
|
pi |
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 |
17.4.0.355.2349
05 Jan 2018 15:20:00
|
pizzamig |
databases/sqldeveloper: Update to 17.4.0.355.2349
PR: 224912
Submitted by: jjuanino@gmail.com
Approved by: mizhka@gmail.com (maintainer) |
4.2.0.17.089.1709
23 May 2017 21:59:15
|
joneum |
- 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 |
4.1.1.19.59
01 Apr 2016 14:00:57
|
mat |
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.
With hat: portmgr
Sponsored by: Absolight |
4.1.1.19.59
14 Jul 2015 02:56:47
|
pi |
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) |
4.1.0.19.07
04 Jun 2015 15:54:42
|
pi |
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) |
4.0.3.16.84
21 Feb 2015 22:18:23
|
rm |
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 |
4.0.1.14.48
20 Oct 2014 10:41:13
|
bapt |
Cleanup plist |
4.0.1.14.48
04 Aug 2014 03:40:15
|
adamw |
In some straightforward cases, protect documentation behind
PORTDOCS, adding a DOCS option where needed, and a couple
PORTEXAMPLES for good measure. |
4.0.1.14.48
26 May 2014 02:33:39
|
eadler |
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) |
4.0.1.14.48
28 Apr 2014 21:43:18
|
bar |
Update to 4.0.1.14.48
Submitted by: bar (myself)
Approved by: jjuanino@gmail.com (maintainer) |
4.0.0.13.80
27 Apr 2014 14:38:19
|
antoine |
Mark a few unfetchable ports BROKEN
With hat: portmgr |
07 Mar 2014 16:49:10
|
bapt |
Convert d* to USES=zip |
4.0.0.13.80
09 Feb 2014 20:20:07
|
rm |
- update to 4.0.0.13.80
- add stage support
PR: 186568
Submitted by: Jose Garcia Juanino <jjuanino@gmail.com> (maintainer) |
3.2.20.09.87
21 Jan 2014 23:18:05
|
bapt |
Fix properties on pkg-plist |
3.2.20.09.87
20 Sep 2013 16:13:49
|
bapt |
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases) |
3.2.20.09.87
06 Dec 2012 01:45:57
|
bar |
- 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 |
3.1.07.42
24 May 2012 18:52:57
|
jgh |
- 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 |
3.0.04.34
04 May 2011 18:37:50
|
decke |
- Update to 3.0.04.34
- Update pkg-message.in
PR: ports/156316
Submitted by: Jose Garcia Juanino <jjuanino@gmail.com> (maintainer) |
2.1.1.64.45
20 Mar 2011 12:54:45
|
miwi |
- Get Rid MD5 support |
2.1.1.64.45
08 May 2010 09:15:51
|
miwi |
- Update to 2.1.1.64.45
PR: 144744
Submitted by: Kurt Jaeger <pi@opsec.eu> (maintainer) |
2.1.0.63.73
12 Feb 2010 10:16:58
|
pav |
- Update to 2.1.0.63.73
PR: ports/142343
Submitted by: Jose Garcia Juanino <jjuanino@gmail.com> (maintainer) |
1.5.4.59.40
15 Mar 2009 19:44:36
|
miwi |
- Update to 1.5.4
PR: 132632
Submitted by: José García Juanino <jjuanino@gmail.com> (maintainer) |
1.5.3.57.83_1
24 Dec 2008 19:40:58
|
miwi |
- Update to 1.5.3
PR: 129827
Submitted by: José García Juanino <jjuanino@gmail.com> (maintainer) |
1.5.1.54.40_1
11 Oct 2008 16:59:19
|
stefan |
Allow JDK versions >1.5.
PR: 127938
Submitted by: sunghyuk <sunghyuk@gmail.com>
Approved by: maintainer |
1.5.1.54.40
19 Jul 2008 14:10:37
|
rafan |
- 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) |
1.5.0.53.38_1
06 Jun 2008 13:17:10
|
edwin |
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) |
1.5.0.53.38
04 Jun 2008 12:53:48
|
pav |
- Update to 1.5.0.53.38
PR: ports/123759
Submitted by: Jose Garcia Juanino <jjuanino@gmail.com> |
1.2.1.3213
05 Apr 2008 20:26:22
|
thierry |
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> |
As an Amazon Associate I earn from qualifying purchases.