sqldeveloper-package

sqldeveloper-package for Debian and derivatives

sqldeveloper-package is a small script that will build a Debian package from Oracle‘s SQL Developer.

This utility makes it possible to build a Debian package of Oracle SQL Developer. The Oracle SQL Developer program is governed by the copyright holder (Oracle USA, Inc.), so you may be limited as to what you can do with the resulting package (i.e. no redistribution, etc). This utility will simply help you create the Debian package, it is your responsibility to use the resulting package acordingly with the OTN license, a copy of which is included in the created package, that you must agree on when downloading the source.

This utility will require you to download the architecture independent archive from <http://www.oracle.com/technetwork/developer-tools/sql-developer>, identified as “Oracle SQL Developer for other platforms”, “Oracle SQL Developer for Multiple Platforms” or “Oracle SQL Developer for Linux and Unix” (depending on which version you are building), to create the Debian package from.

The Debian Package sqldeveloper-package

In order to run Oracle SQL Developer you’ll need a full working JDK. The versions that are compatible with SQL Developer are any JDK 1.5.0_06 or above or JDK 1.6.0_03 or above for SQL Developer versions up to 1.5.5. SQL Developer versions from 2.1 to 3.1 are compatible with JDK 1.6.0_11 or above and SQL Developer version 3.2 is compatible with JDK 1.6.0_04 or above. SQL Developer version 4.0 is compatible with JDK 1.7 (JDK7.0) series and SQL Developer versions from 4.1 to 17.3 are compatible with JDK 1.8 (JDK8.0) series or newer.

Note that Oracle SQL Developer prior to version 4.0 is not compatible with JDK 1.7 (JDK7.0) or newer and prior to version 4.1 is not compatible with JDK 1.8 (JDK8.0) or newer.

There are several ways to obtain a compatible JDK:

• install default-jdk (java), making sure it depends on the required JDK version
• install one of the required openjdk-6-jdk, openjdk-7-jdk, openjdk-8-jdk or openjdk-9-jdk (java)
• install the meta-package java-sdk, making sure that it installs the required JDK version as dependency
• install one of the meta-packages java6-sdk, java7-sdk, java8-sdk, or java9-sdk, making sure that it installs the required JDK version as dependency
• download and run the installer for the version you wish to install from Oracle <http://www.oracle.com/technetwork/java/javase/downloads/>
• install java-package (contrib/misc) and generate a Debian package from the above installer

After installing a compatible JDK simply launch SQL Developer through the graphical interface or by invoking /usr/bin/sqldeveloper and supply the path where the JDK was installed when prompted.

Version History

Version 0.5.4:

• changelog:
  • Updated wrapper script copyright to include 2018
• downloads:
  • sqldeveloper-package_0.5.4_all.deb (binary package)
  • sqldeveloper-package_0.5.4.dsc (source description file)
  • sqldeveloper-package_0.5.4.tar.xz (source code archive)
  • v0.5.3_v0.5.4.debdiff (Debian diff from previous version)

Version 0.5.3:

• changelog:
  • Fixed LD_LIBRARY_PATH initialization, which was rendering the wrapper script unusable, thus breaking the package
  • Fixed QA “unsatisfiable Depends” alerts by disabling cross-building
  • Updated debhelper compat version to 11
  • Verified compliancy with Standards-Version: 4.1.3
• downloads:
  • (unpublished)

Version 0.5.2:

• changelog:
  • Fixed wrapper script command line options invocation
  • Added environment variables ORACLE_PATH and SQLPATH initialization to wrapper script
• downloads:
  • (unpublished)

Version 0.5.1:

• changelog:
  • Verified compliancy with Standards-Version: 4.1.2
  • Bumped version to reflect functionality
• downloads:
  • sqldeveloper-package_0.5.1_all.deb (binary package)
  • sqldeveloper-package_0.5.1.dsc (source description file)
  • sqldeveloper-package_0.5.1.tar.xz (source code archive)
  • v0.5.0_v0.5.1.debdiff (Debian diff from previous version)

Version 0.5.0:

• changelog:
  • Since SQL Developer v4.1, Oracle has started to include i386 and amd64 shared libraries in NetBeans Platform modules. Due to this, converted make-sqldeveloper-package to both generate multiple packages and to be Multi-Arch compatible:
    • Added Multi-Arch dependencies
    • Added cross-packaging functionality
    • Rewrote a large portion of make-sqldeveloper-package to deal with the additional logic
    • Rearranged the debian/* files to support multiple packages
    • Generated packages recommend each other (libraries and SQL Developer)
    • Added a new command line option -s|--skip-libraries to skip building the shared libraries package(s)
  • Multiple versions can now coexist, sqldeveloper.[upstream version] will invoke a specific version of Oracle SQL Developer while sqldeveloper takes advantage of Debian’s alternatives system and, when left in auto mode, will always invoke the highest version installed
  • Exposed Oracle CLI for SQL Developer, a non-gui interface for scripting or headless control of Oracle SQL Developer. Following the multiple versions coexistence concept, sdcli.[upstream version] and sdcli will behave as described above
  • Since SQL Developer v4.2, Oracle started to bundle Oracle SQL Developer Command-Line (SQLcl) with Oracle SQL Developer. When available, and as an alternative to the standalone package (see sqlcl-package), make-sqldeveloper-package will expose it. Since there is a name conflict with content of package parallel, the upstream binary sql will be renamed, and following the above multiple versions coexistence concept, sql.[upstream version].bundled will invoke a specific SQLcl version while sqlcl.bundled takes advantage of Debian’s alternatives system and, when left in auto mode, will always invoke the highest bundled version installed, and sqlcl will invoke the highest version installed (either standalone or bundled, in this order)
  • Added a new command line option -x|--extract-only to prepare a build tree without building package(s) (this option implies -k|--keep-dir)
  • Added descriptive header, detailed progress output and stdout/stderr selection according to the type of message
  • Added a new command line option -q|--quiet to suppress normal output
  • Fixed the long time broken command line option -i|--install which was not finding the correct package name
  • Synchronized code between sqldeveloper-package and sqlcl-package
  • Updated sqldeveloper package description to reflect Oracle’s site
  • Fixed some small typos in the machine readable copyright file License: section creation
  • Fixed lintian warnings and errors:
    • possible-documentation-but-no-doc-base-registration
    • desktop-entry-lacks-keywords-entry
  • Silenced all lintian warnings and errors that are upstream originated and impossible to fix
  • Tested against v4.x and v17.x release families of SQL Developer
  • Bumped version to reflect functionality
• downloads:
  • sqldeveloper-package_0.5.0_all.deb (binary package)
  • sqldeveloper-package_0.5.0.dsc (source description file)
  • sqldeveloper-package_0.5.0.tar.xz (source code archive)
  • v0.4.4_v0.5.0.debdiff (Debian diff from previous version)

Version 0.4.4:

• changelog:
  • Removed debian/watch script, it doesn’t belong in a native package
• downloads:
  • sqldeveloper-package_0.4.4_all.deb (binary package)
  • sqldeveloper-package_0.4.4.dsc (source description file)
  • sqldeveloper-package_0.4.4.tar.xz (source code archive)
  • v0.4.2_v0.4.4.debdiff (Debian diff from previous version)

Version 0.4.3:

• changelog:
  • Changed author/maintainer email address
  • Generated new GPG key
  • Added debian/watch script
• downloads:
  • (unpublished)

Version 0.4.2:

• changelog:
  • Fixed lintian warning no-dep5-copyright
  • Clarified the JDK requirements for all SQL Developer version families
• downloads:
  • sqldeveloper-package_0.4.2_all.deb (binary package)
  • sqldeveloper-package_0.4.2.dsc (source description file)
  • sqldeveloper-package_0.4.2.tar.xz (source code archive)
  • v0.4.1_v0.4.2.debdiff (Debian diff from previous version)

Version 0.4.1:

• changelog:
  • Fixed a flaw in the added logic to remove a stale JVM path from configuration, the way the path is stored has changed from v4.x onward (Closes: #693798) (Reported by Steven Post)
  • Several small fixes and improvements:
    • Fixed the JDK requirements for SQL Developer v4.0
    • Added image thumbnails databases to the list of cruft to remove
  • Fixed lintian warning windows-thumbnail-database-in-package
  • (Re-)Tested against v3.x release family of SQL Developer
• downloads:
  • sqldeveloper-package_0.4.1_all.deb (binary package)
  • sqldeveloper-package_0.4.1.dsc (source description file)
  • sqldeveloper-package_0.4.1.tar.xz (source code archive)
  • v0.3.0_v0.4.1.debdiff (Debian diff from previous version)

Version 0.4.0:

• changelog:
  • Addressed all correctable issues and bugs:
    • Separated target from options and disabled check for original file in package build (Closes: #868673) (Reported and patch by Phil Morrell)
    • Added logic to wrapper script to remove a stale JVM path from configuration (Reported by Steven Post)
  • Fixed lintian warnings:
    • ancient-standards-version
    • package-uses-deprecated-debhelper-compat-version
    • spelling-error-in-description
  • Modified make-sqldeveloper-package to fix lintian warnings and errors:
    • command-in-menu-file-and-desktop-file
    • desktop-mime-but-no-exec-code
    • extra-license-file
    • new-package-should-close-itp-bug
    • priority-extra-is-replaced-by-priority-optional
  • Several small fixes and improvements:
    • Simplified debian/rules since dh_strip_nondeterminism was heavilly impacting build time by make-sqldeveloper-package
    • Added 64-bit foreign DLLs to the list of cruft to remove
    • Moved demo files to documentation structure
    • Introduced lintian overrides for warnings out of our control:
      • classpath-contains-relative-path
      • codeless-jar
  • New homepage for the package
  • Updated documentation regarding compatible JDKs
  • Tested against v4.x and v17.x release families of SQL Developer
  • Verified compliancy with Standards-Version: 4.1.1
  • Bumped version to reflect functionality
• downloads:
  • (unpublished)

Version 0.3.0:

• changelog:
  • Addressed all reported issues and bugs:
    • Included debhelper on the build dependency list (LP: #588458) (Reported by Seth Rosenblum)
    • Replaced dh options with overrides (LP: #998258) (Reported by Christian Loos)
  • Several small fixes and improvements:
    • Fixed an unknown parameter passed to trap when in debug mode
    • Strengthened trap exit handling
    • (Re-)Corrected an unescaped ‘$’ in OTN license text introduced in the previous version
  • New homepage for the package
  • Updated documentation regarding compatible JDKs
  • Solved Debian QA warnings:
    • Converted source format to 3.0 (native)
    • Added Homepage to debian/control
  • Changed the source compression format to xz
  • Verified compliancy with Standards-Version: 3.9.3
  • Bumped version to reflect functionality
• downloads:
  • sqldeveloper-package_0.3.0_all.deb (binary package)
  • sqldeveloper-package_0.3.0.dsc (source description file)
  • sqldeveloper-package_0.3.0.tar.xz (source code archive)
  • v0.2.4_v0.3.0.debdiff (Debian diff from previous version)

Version 0.2.4:

• changelog:
  • Addressed bugs for inclusion in Wheezy’s freeze:
    • Replaced dos2unix with tofrodos (LP: #560803,#626272) (Closes: #568982) (Reported by Seth Rosenblum)
    • Split grep for shell script (LP: #985810,#998610) (Closes: #692534) (Reported by Bruno Medeiros and patch by Brad Powell)
    • Download links updated (Closes: #618650) (Reported by Sergio Fernandez)
  • Fixed JDK dependencies for pre and post SQL Developer v2
  • Updated documentation regarding above changes
  • Updated OTN license information to current version
  • Tested against v2.x and v3.x release families of SQL Developer
  • Bumped version to reflect functionality
• downloads:
  • sqldeveloper-package_0.2.4_all.deb (binary package)
  • sqldeveloper-package_0.2.4.dsc (source description file)
  • sqldeveloper-package_0.2.4.tar.gz (source code archive)
  • v0.2.3_v0.2.4.debdiff (Debian diff from previous version)

Version 0.2.3+nmu1:

• changelog:
  • Non-maintainer upload.
  • Use fromdos in place of gone dos2unix for CRLF conversion management. Remove no longer needed alternative dep on sysutils, which is gone too. Patch from Michael Musenbrock. (Closes: #568982)
• downloads:
  • sqldeveloper-package_0.2.3+nmu1_all.deb (binary package)
  • sqldeveloper-package_0.2.3+nmu1.dsc (source description file)
  • sqldeveloper-package_0.2.3+nmu1.tar.gz (source code archive)

Version 0.2.3:

• changelog:
  • Fixed the command line options -m|--maintainer option which was not getting the current login
• downloads:
  • sqldeveloper-package_0.2.3_all.deb (binary package)
  • sqldeveloper-package_0.2.3.dsc (source description file)
  • sqldeveloper-package_0.2.3.tar.gz (source code archive)

Version 0.2.2:

• changelog:
  • Modified make-sqldeveloper-package to not default to the author name and email for the Maintainer: field of the Debian package as follows: if command line options -m|--maintainer and/or -e|--email are set then use these, else if DEBFULLNAME and/or DEBEMAIL environment variables are set then use these, else default the Maintainer name to an empty string and/or generate the Maintainer email from the current login and hostname
• downloads:
  • (unpublished)

Version 0.2.1:

• changelog:
  • Rearranged make-sqldeveloper-package help output to fit without wrapping in 80 columns
  • Rewrote the sqldeveloper wrapper script fixing all issues reported by checkbashisms
  • Modified the versioning of the resulting Debian package to include the version of make-sqldeveloper-package used to build it
  • Changed the Priority: from optional to extra for the resulting Debian package
  • Modified the make-sqldeveloper-package to honor the DEBFULLNAME and DEBEMAIL environment variables for the Maintainer: field of the Debian package as follows: if command line options -m|--maintainer and/or -e|--email are set then use these, else if DEBFULLNAME and/or DEBEMAIL environment variables are set then use these, else default to the author name and email
  • Changed all negative exit and return values to positive integers
• downloads:
  • (unpublished)

Version 0.2.0:

• changelog:
  • Rewrote the make-sqldeveloper-package fixing all issues reported by checkbashisms (thanks to Nelson A. de Oliveira who reported this)
  • Added support for long options to make-sqldeveloper-package
  • Tested against latest release of SQL Developer
  • Verified compliancy with Standards-Version: 3.8.1
  • Bumped version to reflect functionality
• downloads:
  • (unpublished)

Version 0.1.6:

• changelog:
  • Modified make-sqldeveloper-package to generate a cleaner package, fixing the following lintian info warning:
    • desktop-entry-contains-encoding-key
  • Fixed lintian pedantic:
    • copyright-refers-to-symlink-license
• downloads:
  • (unpublished)

Version 0.1.5:

• changelog:
  • Modified make-sqldeveloper-package to generate a clean package, fixing the following lintian warning:
    • copyright-refers-to-versionless-license-file
  • Fixed lintian warning:
    • debhelper-but-no-misc-depends
  • Corrected an unescaped ‘$’ in Oracle license text
  • Silenced the build process of make-sqldeveloper-package
• downloads:
  • (unpublished)

Version 0.1.4:

• changelog:
  • Modified make-sqldeveloper-package to generate a clean package, fixing the following lintian warnings and errors:
    • binary-without-manpage
    • extra-license-file
    • package-contains-empty-directory
    • menu-icon-not-in-xpm-format
    • debian-revision-should-not-be-zero
    • virtual-package-depends-without-real-package-depends
    • new-package-should-close-itp-bug (Closes: #515233)
  • Modified the sqldeveloper wrapper script to pass command line parameters to the application
  • Added -help and -version switches to the sqldeveloper wrapper script
• downloads:
  • (unpublished)

Version 0.1.3:

• changelog:
  • Fixed a bug introduced with the replacement of dh_* scripts by dh calls where the wrapper script stopped being renamed
• downloads:
  • (unpublished)

Version 0.1.2:

• changelog:
  • Added the Debian Developer’s Reference recommendation to auto close the ITP filled against WNPP (Closes: #514124)
• downloads:
  • (unpublished)

Version 0.1.1:

• changelog:
  • Modified the install path from /opt to /usr/share
• downloads:
  • (unpublished)

Version 0.1.0:

• changelog:
  • Tested against every release of SQL Developer published to date
  • Bumped version to reflect functionality
• downloads:
  • (unpublished)

Version 0.0.5:

• changelog:
  • Modified make-sqldeveloper-package to support version 1.0.0 of SQL Developer
  • Changed documentation to include instructions for earlier SQL Developer releases
• downloads:
  • (unpublished)

Version 0.0.4:

• changelog:
  • Fixed the make-sqldeveloper-package script to remove unused targets from the .PHONY line in the temporary debian/rules file.
• downloads:
  • (unpublished)

Version 0.0.3:

• changelog:
  • Filled ITP against WNPP (#514124)
  • Moved make-sqldeveloper-package.1 and README to the top level directory
  • Fixed lintian warnings:
    • dh-clean-k-is-deprecated
    • copyright-with-old-dh-make-debian-copyright
  • Replaced dh_* scripts with dh calls
  • Modified make-sqldeveloper-package to apply the above packaging changes when generating the sqldeveloper package
• downloads:
  • (unpublished)

Version 0.0.2:

• changelog:
  • Replaced xterm dependency to x-terminal-emulator on the sqldeveloper wrapper script.
• downloads:
  • (unpublished)

Version 0.0.1:

• changelog:
  • Initial Release.
• downloads:
  • (unpublished)