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>

5 files changed, 148 insertions, 0 deletions

diff --git a/databases/sqldeveloper/files/patch-ide_bin_launcher.sh b/databases/sqldeveloper/files/patch-ide_bin_launcher.sh
new file mode 100644
index 000000000000..a521dfeb8f57
--- /dev/null
+++ b/databases/sqldeveloper/files/patch-ide_bin_launcher.sh
@@ -0,0 +1,62 @@
+--- ide/bin/launcher.sh.orig	Tue Jan 15 21:35:22 2008
++++ ide/bin/launcher.sh	Tue Jan 15 21:43:52 2008
+@@ -191,12 +191,12 @@
+ #-----------------------------------------------------------------------------
+ AddVMOption()
+ {
+-  NEWOPD=`expr "$1" : '[^\=]*\=\(.*\)'`
++  NEWOPD=`expr -- "$1" : '[^\=]*\=\(.*\)'`
+   if [ "X$NEWOPD" != "X" ]
+   then
+-    if [ "X`expr "$NEWOPD" : '.*\( \).*'`" != "X" ]
++    if [ "X`expr -- "$NEWOPD" : '.*\( \).*'`" != "X" ]
+     then
+-      NEWARG=`expr "$1" : '\([^\=]*\)\=.*'`
++      NEWARG=`expr -- "$1" : '\([^\=]*\)\=.*'`
+       NEWARG="$NEWARG=\"$NEWOPD\""
+     else
+       NEWARG=$1
+@@ -329,15 +329,15 @@
+     while [ -h "$tmpvar" ]
+     do
+         tmpvar2=`ls -ls "$tmpvar"`
+-        tmpvar2=`expr "$tmpvar2" : '.*-> \(.*\)$'`
+-        if [ `expr "$tmpvar2" : "\.\/"` -gt 0 -o `expr "$tmpvar2" : "\.\.\/"` -gt 0 -o `expr "$tmpvar2" : ".*/.*"` -le 0 ]
++        tmpvar2=`expr -- "$tmpvar2" : '.*-> \(.*\)$'`
++        if [ `expr -- "$tmpvar2" : "\.\/"` -gt 0 -o `expr -- "$tmpvar2" : "\.\.\/"` -gt 0 -o `expr -- "$tmpvar2" : ".*/.*"` -le 0 ]
+         then
+           tmpvar="`dirname $tmpvar`/$tmpvar2"
+         else
+           tmpvar="$tmpvar2"
+         fi
+     done
+-    tmpvar=`expr "$tmpvar" : '\(.*\)\/bin\/[^\/]*$'`
++    tmpvar=`expr -- "$tmpvar" : '\(.*\)\/bin\/[^\/]*$'`
+     SetJavaHome "$tmpvar"
+   fi
+ }
+@@ -610,8 +610,8 @@
+         case $1 in 
+           --*)
+             NEWARG=`echo $1 | sed -e s/--//g`
+-            NEWOPD=`expr "$NEWARG" : '[^\=]*\=\(.*\)'`
+-            NEWARG=`expr "$NEWARG" : '\([^\=]*\)\=.*'`
++            NEWOPD=`expr -- "$NEWARG" : '[^\=]*\=\(.*\)'`
++            NEWARG=`expr -- "$NEWARG" : '\([^\=]*\)\=.*'`
+             NEWARG=`echo $NEWARG | tr "[:upper:]" "[:lower:]"`
+             case $NEWARG in
+               setjavahome)         NEWARG="SetJavaHome" ;;
+@@ -697,11 +697,11 @@
+     if [ $? -gt 0 ]
+     then
+             s=`${JAVA} -version 2>&1`
+-            if [ `expr "$s" : 'java version \"1\.[0-3]'` -gt 0 ]
++            if [ `expr -- "$s" : 'java version \"1\.[0-3]'` -gt 0 ]
+             then
+                     echo "Error: `GetShortProductName` doesn't run with JDK version prior to 1.4.x" 
+             fi
+-            if [ `expr "$s" : 'java version \"1\.[0-5].*\"'` -le 0 ]
++            if [ `expr -- "$s" : 'java version \"1\.[0-5].*\"'` -le 0 ]
+             then
+                     echo "Error: `GetShortProductName` can't recognize the JDK version"
+             fi
diff --git a/databases/sqldeveloper/files/patch-sqlcli b/databases/sqldeveloper/files/patch-sqlcli
new file mode 100644
index 000000000000..6396ee146908
--- /dev/null
+++ b/databases/sqldeveloper/files/patch-sqlcli
@@ -0,0 +1,30 @@
+--- sqlcli.orig	Wed Jan 16 09:44:47 2008
++++ sqlcli	Wed Jan 16 09:45:32 2008
+@@ -1,15 +1,15 @@
+ #!/bin/bash
+-CP=jdbc/lib/ojdbc14.jar
+-CP=${CP}:jlib/orai18n-collation.jar
+-CP=${CP}:jlib/orai18n-mapping.jar
+-CP=${CP}:jlib/orai18n-servlet.jar
+-CP=${CP}:jlib/orai18n-utility.jar
+-CP=${CP}:jlib/orai18n.jar
+-CP=${CP}:sqldeveloper/extensions/oracle.sqldeveloper.jar
+-CP=${CP}:sqldeveloper/lib/jline-0.9.9.jar
+-CP=${CP}:ide/lib/javatools.jar
+-CP=${CP}:ide/extensions/oracle.ide.jar
+-CP=${CP}:jlib/jdev-cm.jar
+-CP=${CP}:ide/lib/dbapi.jar
++CP=%DATADIR%/jdbc/lib/ojdbc14.jar
++CP=${CP}:%DATADIR%/jlib/orai18n-collation.jar
++CP=${CP}:%DATADIR%/jlib/orai18n-mapping.jar
++CP=${CP}:%DATADIR%/jlib/orai18n-servlet.jar
++CP=${CP}:%DATADIR%/jlib/orai18n-utility.jar
++CP=${CP}:%DATADIR%/jlib/orai18n.jar
++CP=${CP}:%DATADIR%/sqldeveloper/extensions/oracle.sqldeveloper.jar
++CP=${CP}:%DATADIR%/sqldeveloper/lib/jline-0.9.9.jar
++CP=${CP}:%DATADIR%/ide/lib/javatools.jar
++CP=${CP}:%DATADIR%/ide/extensions/oracle.ide.jar
++CP=${CP}:%DATADIR%/jlib/jdev-cm.jar
++CP=${CP}:%DATADIR%/ide/lib/dbapi.jar
+ 
+ java -cp ${CP} oracle.dbtools.raptor.scriptrunner.utils.SqlCli $*
diff --git a/databases/sqldeveloper/files/patch-sqldeveloper.sh b/databases/sqldeveloper/files/patch-sqldeveloper.sh
new file mode 100644
index 000000000000..c116da7aa044
--- /dev/null
+++ b/databases/sqldeveloper/files/patch-sqldeveloper.sh
@@ -0,0 +1,6 @@
+--- sqldeveloper.sh.orig	Tue Jan 15 22:18:13 2008
++++ sqldeveloper.sh	Tue Jan 15 22:18:30 2008
+@@ -1,2 +1,2 @@
+ #!/bin/bash
+-cd "`dirname $0`"/sqldeveloper/bin && bash sqldeveloper $*
++cd %DATADIR%/sqldeveloper/bin && sh sqldeveloper $*
diff --git a/databases/sqldeveloper/files/patch-sqldeveloper_bin_sqldeveloper b/databases/sqldeveloper/files/patch-sqldeveloper_bin_sqldeveloper
new file mode 100644
index 000000000000..6e19e562949e
--- /dev/null
+++ b/databases/sqldeveloper/files/patch-sqldeveloper_bin_sqldeveloper
@@ -0,0 +1,22 @@
+--- sqldeveloper/bin/sqldeveloper.orig	Tue Jan 15 21:35:20 2008
++++ sqldeveloper/bin/sqldeveloper	Tue Jan 15 21:44:22 2008
+@@ -19,7 +19,7 @@
+     local rawAbsPath
+ 
+     #  Test if $arg starts with '/'.
+-    if [ "X`expr \"${pathname}\" : '\(/\).*'`" = "X/" ]
++    if [ "X`expr -- \"${pathname}\" : '\(/\).*'`" = "X/" ]
+     then
+     rawAbsPath="${pathname}"
+     else
+@@ -49,8 +49,8 @@
+     local pathname="$1"
+     while [ -h "$pathname" ] ; do
+         local ls=`ls -ld "$pathname"`
+-        local link=`expr "$ls" : '.*-> \(.*\)$'`
+-        if expr "$link" : '.*/.*' > /dev/null
++        local link=`expr -- "$ls" : '.*-> \(.*\)$'`
++        if expr -- "$link" : '.*/.*' > /dev/null
+         then
+             pathname="$link"
+         else
diff --git a/databases/sqldeveloper/files/pkg-message.in b/databases/sqldeveloper/files/pkg-message.in
new file mode 100644
index 000000000000..30f2ec478b2e
--- /dev/null
+++ b/databases/sqldeveloper/files/pkg-message.in
@@ -0,0 +1,28 @@
+************************************************************************
+Note for ALL users:
+
+    The first time sqldeveloper is run, it shows a splash screen and a prompt
+    window behind, hidden. By mean of your window manager, grab the edge,
+    pull the window over (or move it), and answer the prompt as appropiate.
+
+
+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
+    $ORACLE_HOME/network/admin a valid tnsnames.ora services file. After that
+    choose "TNS" as "Connection Type" when you are going to add a new
+    connection database.
+
+
+Note for MySQL and SQL Server users:
+
+    In order to connect to MySQL and SQL Server databases, it is needed to point
+    out to SQL Developer where the MySQL and SQL Server JDBC classes are. Go to
+    Tools -> Preferences menu, select Database -> Third Party JDBC Drivers
+    and choose the file
+    %%DATADIR%%/sqldeveloper/extensions/oracle.dbtools.thirdparty.mysql.jar
+    and
+    %%DATADIR%%/sqldeveloper/extensions/oracle.dbtools.thirdparty.sqlserver.jar
+    in the browser.
+************************************************************************