Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Launching Squirrel SQL client on Mac OS

I am Launching SQuirrel SQL on Mac OS X(El Capitan) that has JDK1.8 on it produces an error message saying the JDK-version should be at least 1.6. It then quits. SQL client version is 3.7. How do I resolve this?

like image 539
mmraj Avatar asked Sep 22 '17 17:09

mmraj


People also ask

How do I install SQuirreL client?

The SQuirreL SQL Client can be installed by the IzPack installer. Download the file squirrel-sql-<version>-install. jar and execute it using the following command: java -jar squirrel-sql-<version>-install.

Is SQuirreL SQL Client free?

SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment.


2 Answers

I ran into similar issue and the following change fixed the issue. Open the Application Folder in finder and open the App Package Contents and navigate to Contents/MacOS/. Open the squirrel-sql.sh file and update the value of "SQUIRREL_SQL_HOME" around line 56.

Out of box, the value would be

SQUIRREL_SQL_HOME=`dirname "$0"`/Contents/Resources/Java

Update this to

SQUIRREL_SQL_HOME='/Applications/SQuirreLSQL.app/Contents/Resources/Java'

Thanks to https://sourceforge.net/p/squirrel-sql/bugs/1232/#6bc6

like image 69
Vijay Avatar answered Sep 28 '22 09:09

Vijay


  1. Open the squirrel-sql.sh file (/Applications/SQuirreLSQL.app/Contents/MacOS/squirrel-sql.sh)
  2. Follow the suggests at line 62 to choose the right 'SQUIRREL_SQL_HOME=...' line by commenting the wrong one and uncommenting the right one. Just like this:
##################################################################################################
# CHANGE_HERE
# Mac users are not able which of the three lines below works correctly, see bugs 1287, 1321, 1310.
# Thus if you have problems running SQuirreL on IOS please try out the alternative lines
##################################################################################################    
#    SQUIRREL_SQL_HOME=`dirname "$0"`/Contents/Resources/Java
     SQUIRREL_SQL_HOME=$(echo $ABSPATH | grep -o '^/.*/Contents/')Resources/Java
#    SQUIRREL_SQL_HOME=`dirname "$0"`/../Resources/Java
like image 30
Song Avatar answered Sep 28 '22 09:09

Song