SQLeo Visual Query Builder / Discussion / Technical questions: Cannot open on Mac OSX Sierra

Big E - 2017-02-03

Sorry for being a noob when it comes to Java but im trying to run sqleo for the first time by renaming sqleo-start-MacOS.txt to sqleo-start-MacOS.command and when I run it, the command line opens and I get the following errors.

MacBook-Pro:~ eric$ /Users/eric/Desktop/SQLeoVQB.2016.12.rc1_unlimited/sqleo-start-MacOS.command ; exit;
Error: Could not find or load main class com.sqleo.environment.SQLeoMacApp
press any key to continue
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.

[Process completed]

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-03

Stange, could you show us what is in
sqleo-start-MacOS.command ?

it should be
java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

and what is the content of directory
/Users/eric/Desktop/SQLeoVQB.2016.12.rc1_unlimited?

file SQLeoVQB.jar should be found there

Last edit: PAscal 2017-02-04

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Comment has been marked as spam.
Undo

View and moderate all "Technical questions" comments posted by this user

Mark all as spam, and block user from posting to "Discussion"

Anonymous - 2017-02-06

Hi Pascal,

Thanks for responding This is what is in the sqleo-start-MacOS.command:

java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

As far as the content of the directory. Below is a snapshot and yes SQLeoVQB.jar is in the folder you mentioned.

Thanks for your help

Hi Pascal, Thanks for responding This is what is in the sqleo-start-MacOS.command: ***java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp read -p "press any key to continue"*** As far as the content of the directory. Below is a snapshot and yes** SQLeoVQB.jar** is in the folder you mentioned. Thanks for your help

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

Screen Shot 2017-02-06 at 12.24.33 PM.jpg

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-06

Hi Eric,

When I launch
java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
in that directory on my windows Desktop (using java 1.7), I have an other error ...

could you try with a full path description ?
java -classpath /Users/eric/Desktop/SQLeoVQB.2016.12.rc1_unlimited/SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp

or a relative one:
java -classpath ./SQLeoVQB.2016.12.rc1_unlimited/SQLeoVQB.jar

what is your java version ?
java -version

Regards

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-07

Hi PAscal,

On my Mac I have Java 8 update 121. See snap.

Im guessing you want me to run that in the terminal window. Ran it and it loaded it. So does that mean everytime I want to run it, I have to do it with that long line in the terminal window?

Screen-Shot-2017-02-07-at-12.49.19-AM.jpg

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-07

it means there is something wrong in the command file.
could you replace its line with the line that works ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Comment has been marked as spam.
Undo

View and moderate all "Technical questions" comments posted by this user

Mark all as spam, and block user from posting to "Discussion"

Anonymous - 2017-02-08

Hi Pascal. Didnt work either. So after digging a little further. I took the contents of the sqleo-start-MacOS.command file which was:

java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

I opened terminal and CD'ed to the directory where it everything was located and ran the above command from the terminal window and had no issues. It only fails when im running it from the sqleo-start-MacOS.command file itself. So the Perhaps the extension is wrong?

Hi Pascal. Didnt work either. So after digging a little further. I took the contents of the sqleo-start-MacOS.command file which was: ***java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp read -p "press any key to continue"*** I opened terminal and CD'ed to the directory where it everything was located and ran the above command from the terminal window and had no issues. It only fails when im running it from the sqleo-start-MacOS.command file itself. So the Perhaps the extension is wrong?

Add attachments
Cancel
You seem to have CSS turned off. Please don't fill out this field.

You seem to have CSS turned off. Please don't fill out this field.

New Attachment:

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-08

could you add the same CD command in the script ?

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-08

I added the cd /Users/eric/Desktop/SQLEO/SQLeoVQB.2016.12.rc1_unlimited to the top of the file. So it looks like this:

cd /Users/eric/Desktop/SQLEO/SQLeoVQB.2016.12.rc1unlimited
java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

When It double clicked it It actually loaded up and gave me the same message I got when I ran it straight from the terminal. Dont know what that illegal argument means.

**Last login: Wed Feb 8 12:56:34 on ttys001
You have mail.
/Users/eric/Desktop/SQLEO/SQLeoVQB.2016.12.rc1unlimited/sqleo-start-MacOS.command ; exit;
ericImac:~ eric$ /Users/eric/Desktop/SQLEO/SQLeoVQB.2016.12.rc1unlimited/sqleo-start-MacOS.command ; exit;
java.lang.IllegalArgumentException: URI is not hierarchical
at java.io.File.<init>(File.java:418)
at com.sqleo.environment.SQLeoMacApp.main(SQLeoMacApp.java:86)
SystemLookAndFeel: com.apple.laf.AquaLookAndFeel
SQLeoUsingLookAndFeel: [Aqua Look and Feel for Mac OS X - com.apple.laf.AquaLookAndFeel]
version: 2016.12.rc1+
Loading resources...
Loading window...
HTTP status: 200
Server version:2016.12.rc1+

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-08

When you said running "in the terminal window. Ran it and it loaded it"
was the application working ?

Last edit: PAscal 2017-02-08

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-08

Yea it worked. But with the error that I mentioned above:

**java.lang.IllegalArgumentException: URI is not hierarchical
at java.io.File.<init>(File.java:418)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-08

ok, this error that comes from source code

macApplication.setDockIconImage(ImageIO.read(new File(SQLeoMacApp.class.getResource("/images/sqleo.png").toURI())));

is just for getting the SQLeo icon

What I don't understand is why
java -classpath
doesn't find Jar file in the current directory any more ...

what is the result for
java -jar SQLeoVQB.jar
?

Last edit: PAscal 2017-02-08
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-08

Result of java -jar SQLeoVQB.jar:

SystemLookAndFeel: com.apple.laf.AquaLookAndFeel
SQLeoUsingLookAndFeel: [The Java(tm) Look and Feel - javax.swing.plaf.metal.MetalLookAndFeel]
version: 2016.12.rc1+
Loading resources...
Loading window...
HTTP status: 200
Server version:2016.12.rc1+

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-08

I also cant copy and paste

* NEVERMIND

I have to hit CTRL instead of the COMMAND KEY

Last edit: Big E 2017-02-08

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-09

so ...
java -jar SQLeoVQB.jar
is working without error

the specific version for Mac Os
(the one with error)
gives some extra integration in Mac Os like copy and past ...
as described here

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-09

last try

PATH=.:$PATH
export PATH
java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-10

When I put the above in the command file i got the following and it did not load up:

*Last login: Thu Feb 9 20:54:38 on console
You have mail.
MacBook-Pro:~ eric$ /Users/eric/Desktop/SQLeoVQB.2016.12.rc1unlimited/sqleo-start-MacOS.command ; exit;
Error: Could not find or load main class com.sqleo.environment.SQLeoMacApp
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.
Deleting expired sessions...42 completed.

[Process completed]*

If I run it straight from the terminal window I get this:

java.lang.IllegalArgumentException: URI is not hierarchical
at java.io.File.<init>(File.java:418)
at com.sqleo.environment.SQLeoMacApp.main(SQLeoMacApp.java:86)
SystemLookAndFeel: com.apple.laf.AquaLookAndFeel
SQLeoUsingLookAndFeel: [Aqua Look and Feel for Mac OS X - com.apple.laf.AquaLookAndFeel]
version: 2016.12.rc1+
Loading resources...
Loading window...
HTTP status: 200
Server version:2016.12.rc1+

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-10

see bugs
#400 java.lang.IllegalArgumentException: URI is not hierarchical
#399 Error: Could not find or load main class com.sqleo.environment.SQLeoMacApp

Last edit: PAscal 2017-02-10

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Big E - 2017-02-11

Hey Pascal. Thanks for your help. I give up. I just wanted a simple solution to access my mysql databases rather than having to open my windows vm and using ms acccess. I will stick to ms access.

You been a great help

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2017-02-11

Eric,
- SQLeoVQB standard edition works fine on Mac OS,
- SQLeoVQB Mac OS edition just don't display its Icon
and you go back to ms access ;o(

How do you want me to become rich and famous ?
thanks for your time ;o)

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Anonymous - 2018-04-04

Hi - I am also having trouble running SQLeo on osx 10.12.6 with Java 8 - Build 161. I have attempted to run the command using both with and wihout the path to the file.

Attempt #1:
java -classpath SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

Attempt #2:
java -classpath /Users/cain/Desktop/SQLeo/SQLeoVQB.jar com.sqleo.environment.SQLeoMacApp
read -p "press any key to continue"

All the files are on the Desktop in a folder: SQLeo

The error message I get with both of the above commands.

Exception in thread "main" java.lang.UnsupportedClassVersionError: com/sqleo/environment/SQLeoMacApp : Unsupported major.minor version 51.0
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClassCond(ClassLoader.java:637)
at java.lang.ClassLoader.defineClass(ClassLoader.java:621)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:141)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:283)
at java.net.URLClassLoader.access$000(URLClassLoader.java:58)
at java.net.URLClassLoader$1.run(URLClassLoader.java:197)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
press any key to continue
logout
Saving session...
...copying shared history...
...saving history...truncating history files...
...completed.

I am wondering if this suggestion regarding fixing Unsupported major.minor version 51.0 errors is applicable:
http://www.dev2qa.com/how-to-fix-java-unsupported-major-minor-version-51-0-exception/

Your other suggestions are most welcome

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

PAscal - 2018-04-04

Hi,
you are probably right ...

maybe you are using a version that was build with java 1.7
could you test with attached version ?

Regards
PAscal

Last edit: PAscal 2018-04-04

SQLeoVQB-2018.04.rc1+_jdk1.8.jar

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Cannot open on Mac OSX Sierra

Helping users to quickly understand SQL queries

Forums

Help

Cannot open on Mac OSX Sierra

Cannot open on Mac OSX Sierra

Helping users to quickly understand SQL queries

Forums

Help

Cannot open on Mac OSX Sierra document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

Cannot open on Mac OSX Sierra