ports/119756: New port: databases/sqldeveloper Graphical tool for database development

[thierry at FreeBSD.org]

Synopsis: New port: databases/sqldeveloper Graphical tool for database development

State-Changed-From-To: open->feedback
State-Changed-By: thierry
State-Changed-When: Ven 4 avr 2008 16:48:20 UTC
State-Changed-Why: 

Thanks for this PR, but I have two remarks:

1) we cannot install shell scripts with '/bin/bash' in the shebang; you
should either add a run-dependency on shells/bash and replace /bin/bash
by ${LOCALBASE}/bin/bash, or (better!) replace /bin/bash by /bin/sh and
remove bashisms - if any.

2) Run error:

Launching sqldeveloper opens a splash screen, and stops. The displayed
messages are:

Oracle SQL Developer
 Copyright (c) 2006, 2007, Oracle. All rights reserved.

Using oracle.home=/usr/local/share/java/sqldeveloper
Using ide.user.dir=/home/thierry/.sqldeveloper
java.io.FileNotFoundException:
/usr/local/share/java/classes/packages.txt (Permission denied)
        at java.io.FileOutputStream.open(Native Method)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:179)
        at java.io.FileOutputStream.<init>(FileOutputStream.java:131)
        at java.io.PrintWriter.<init>(PrintWriter.java:212)
        at
oracle.ide.boot.PCLMain.generatePackagesTxtIfMissing(PCLMain.java:318)
        at
oracle.ide.boot.PCLMain.createExtensionManagerLoader(PCLMain.java:94)
        at oracle.ide.boot.PCLMain.main(PCLMain.java:36)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at oracle.classloader.util.MainClass.invoke(MainClass.java:89)
        at
oracle.ide.boot.IdeLauncher.bootClassLoadersAndMain(IdeLauncher.java:218)
        at oracle.ide.boot.IdeLauncher.launchImpl(IdeLauncher.java:90)
        at oracle.ide.boot.IdeLauncher.launch(IdeLauncher.java:66)
        at oracle.ide.boot.IdeLauncher.main(IdeLauncher.java:55)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at oracle.ide.boot.Launcher.invokeMain(Launcher.java:508)
        at oracle.ide.boot.Launcher.launchImpl(Launcher.java:106)
        at oracle.ide.boot.Launcher.launch(Launcher.java:60)
        at oracle.ide.boot.Launcher.main(Launcher.java:49)

Running as root:
touch /usr/local/share/java/classes/packages.txt
makes it work:

Oracle SQL Developer
 Copyright (c) 2006, 2007, Oracle. All rights reserved.

Using oracle.home=/usr/local/share/java/sqldeveloper
Using ide.user.dir=/home/thierry/.sqldeveloper
Addin: Translator PlSql is trying to register a input type (.plsql)
which conflicts with translator PlSql who already using this input type
reloadBuffers(): 49 nodes checked in 3.95301E-4 second(s)

I don't know if this packages.txt should have been installed by the JRE,
but in order to install a running port, you should test on post-install
if it exists, else install a minimal ${JAVAJARDIR}/packages.txt.

Best regards,
-- 
Th. Thomas.


Responsible-Changed-From-To: freebsd-ports-bugs->thierry
Responsible-Changed-By: thierry
Responsible-Changed-When: Ven 4 avr 2008 16:48:20 UTC
Responsible-Changed-Why: 

Take it.


http://www.freebsd.org/cgi/query-pr.cgi?pr=119756