no problem, pleased to see that the tool is still used :0) Regards
there is also a port to PrestoDB https://github.com/passionbytes/ZigmaPresto
Dark theme using flatlaf
Hi Anudeep, Thank you for giving SQLeo more visibility ! not sure if needed to clone whole project history ... but storing in github last release package may help :0) see https://github.com/legrandlegrand/SQLeo/releases/tag/2019.01.rc1 Regards PAscal
Hi Anudeep, Thank you for giving SQLeo more visibility ! not sure if needed to clone whole project history ... but storing in github last release package may help :0) Regards PAscal
There are many repositories of SQLeo in many places, and mainly in GITHUB: - ojwanganto/SQLeo : the oldest one 2017 September (but not up to date anymore) - anudeepg/SQLeo: copy of sourceforge project (as of 2020 September) - odys-z/SQLeo-pro: new projet created in 2021 October ! Long live to SQLeo ;o)
A Python 3 compatible version of REVJ is available at https://github.com/legrandlegrand/revj2 It includes a Pyparsing upgrade, works fine with new versions of Cherrypy and Graphviz, and may include its own bugs !
Hello, there is a save query button that may answer your question. To be honest I'm not able to say how to do that programatically ;o( Regards PAscal
as a workaround here is the online equivalent tool https://pivottable.js.org/examples/local.html
PivotTable.js with charts: An error occurred rendering the PivotTable results
hummm strange ... on my virtual 18.04.1-Ubuntu x86_64 machine: installing java: sudo apt install openjdk-11-jre-headless ... checking java version: java -version openjdk version "11.0.8" 2020-07-14 OpenJDK Runtime Environment (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1) OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1, mixed mode, sharing) unziping package from sourceforge and launching same command: ub64@ub64-Virtual-Machine:~/Downloads/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar:lib/*"...
hummm strange ... on my virtual 18.04.1-Ubuntu x86_64 machine: installing java: sudo apt install openjdk-11-jre-headless ... checking java version: java -version openjdk version "11.0.8" 2020-07-14 OpenJDK Runtime Environment (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1) OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1, mixed mode, sharing) unziping package from sourceforge and launching same command: ub64@ub64-Virtual-Machine:~/Downloads/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar:lib/*"...
hummm strange ... on my virtual 18.04.1-Ubuntu x86_64 machine: installing java: sudo apt install openjdk-11-jre-headless ... checking java version: java -version openjdk version "11.0.8" 2020-07-14 OpenJDK Runtime Environment (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1) OpenJDK 64-Bit Server VM (build 11.0.8+10-post-Ubuntu-0ubuntu118.04.1, mixed mode, sharing) unziping package from sourceforge and launching same command: ub64@ub64-Virtual-Machine:~/Downloads/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar:lib/*"...
Hello, when using java 11, there is a specific command line for startup: see https://sourceforge.net/p/sqleo/code/HEAD/tree/trunk/sqleo-start-Metal-Default-Java11.txt that is: java -cp "SQLeoVQB.jar;lib/*" com.sqleo.environment.Application could you try it please and tell us ? Regards PAscal
Just in case people want to share their videos on the subject
this is for web admin
taken from https://sourceforge.net/p/sqleo/discussion/general/thread/622c79e069/ I just set up SQLeo on my Ubuntu 18.04 LTS with SQLeoVQB.2019.01.rc1 version, and got this error message: org.postgresql.util.PSQLException: An error occurred while setting up the GSS Encoded connection. The only web-search hit on that leads to an IBM support article
taken from https://sourceforge.net/p/sqleo/discussion/general/thread/622c79e069/ I just set up SQLeo on my Ubuntu 18.04 LTS with SQLeoVQB.2019.01.rc1 version), and got this error message: org.postgresql.util.PSQLException: An error occurred while setting up the GSS Encoded connection. The only web-search hit on that leads to an IBM support article
Hello David, this seems to be related to (new) postgres configuration. did you try specifying gssEncMode=disable in the connect string (that is supported in SQleo) ? something like jdbc:postgresql://myhost/mydb?gssEncMode=disable Here is Postgres JDBC driver reference guide for this https://jdbc.postgresql.org/documentation/head/connect.html Regards PAscal
taken from https://sourceforge.net/p/sqleo/discussion/general/thread/622c79e069/ Using SQLeoVQB.2019.01.rc1 I just set up SQLeo on my Ubuntu 18.04 LTS with SQLeoVQB.2019.01.rc1 version), and got this error message: org.postgresql.util.PSQLException: An error occurred while setting up the GSS Encoded connection. The only web-search hit on that leads to an IBM support article
Hi David, thank you for your interest in SQLeo that has not been updated for months (I apologize). Regarding your first question, to be honest, SSH support hasn't implemented. So to get a chance to use it in SQLeo (I'm not an expert), you have to : - use a JDBC Driver that supports it (You didn't told us which database you are using), if any - implement SSH tunneling toward your remote serveur, and then use a connection url refering to this tunnel. maybe thoses other threads may help https://sourceforge.net/p/sqleo/discussion/general/thread/7cc61b96/...
with java > 8, application scaling is X2 on windows per default
support for java 9,10 and 11
webswing: java.lang.ClassCastException: class org.webswing.common.GraphicsWrapper cannot be cast to class sun.java2d.SunGraphics2D
using menu option Undo or Redo woks fine ...
webswing: App not responding after CTRL-Z (undo) in query or command
Hello, Revj v0.49 works fine with Python 2.7 and Graphviz 2.38, that ar both outdated versions. Is there somebody here with Python and Graphviz knowledge interested in upgrading this project ? I'm available for testing ;o) Regards PAscal
webswing: java.lang.ClassCastException: class org.webswing.common.GraphicsWrapper cannot be cast to class sun.java2d.SunGraphics2D
Hello, It seems that the souce code is not compatible any more with latest python versions ( 3.8 in my case). Is there somebody here with python skill interested in that work ? I'm available for testing ;o) Regards PAscal
websing: java.lang.ClassCastException: class org.webswing.common.GraphicsWrapper cannot be cast to class sun.java2d.SunGraphics2D
Hello, thank your for using SQLeo. I'm not sure your problem is related to this thread "sqleo webswing deployment on azure", If not please post in an other one (more related), or simply create a new one. We won't be able to help you, if you don't provide any information about the context: the way you start this application, setup, and error message (text or screen shot, ...) Regards PAscal
hello, it seems to work for me. the no connection error seems to be because you didn´t create / open a datasource connection. Regards PAscal
Hello, Could you try the embbeded "MySQL (MariaDB Jdbc Driver)" driver, that sould fix your problem ? If it doesn't, I'll provide a SQLeo.jar without any custom driver included to come back to a metadata explorer tree per database. Regards PAscal
Hello, This project is not developped anymore, but it is still supported ... SQLeo contains a custom "MariaDB connector/J" that permits to see all objects of all MySQL databases in the same "meta data explorer" tree. It is called "MySQL (MariaDB Jdbc Driver)", is that the one you are using ? Could you give us more details on how "you try to create a query": are you using "auto completion" in command editor or are you using "query designer" ? If you could also provide your SQLeo version ;o) Regards...
check latest download https://sourceforge.net/projects/sqleo/files/SQLeoVQB/
release 2019 01 is now compatible with newest versions of java
with java > 8, application scaling is X2 on windows per default
Version 2019.01.rc1 - Readme and version update
support for java 9,10 and 11
Thank you Herbert, Anudeep developper of SQLeo has found some time to start the migration. We have a Beta verion in tests Regards PAscal
You are welcome I understand I tryed with MariaDB 10.2.20 (64bit) and it works, are you using a 32 or 64 bit windows 10 ? Regards PAscal
Hi here is a jar file without the MySQL jdbc driver embeded. Please try with it (following documentation) Regards PAscal
Thank you for your answer but that won't help. For information, MariaDB jdbc driver embeded inside SQLeo is MariaDB connector/J version 1.4.6 On my Windows 7, with java 8, I'm able to connect to a 5.5.40 Maria DB database with URL: jdbc:mysql://localhost:3306 Are you using an Oracle MySQL db or a MariaDB one ? Which version ? Maybe that SQLeo's jdbc driver (that is quite old) is not compatible with your version of (MariaDB/Oracle) MySQL ... I would suggest to download the latest jdbc driver from...
Hello, Sorry for the typo My question was: "What is your version of Java?" I'm using version 8 update 131, and I know SQLeo doesn't work with version >= 9. To get more informations, could you provide the output of the command: open a command window cd in your SQLeo directory, then java -jar SQLeoVQB.jar Regards PAscal
Hello, Sorry for the tupo My question was: "What is your version of Java?" I'm using version 8 update 131, and I know SQLeo doesn't work with version >= 9. To get more informations, could you provide the output of the command: open a command window cd in your SQLeo directory, then java -jar SQLeoVQB.jar Regards PAscal
What is tour version of java ? Sqleo doesn't work with version >= 9 De : Alan Baker alanwbaker@users.sourceforge.net Envoyé : lundi 24 décembre 2018 18:28:48 À : [sqleo:discussion] Objet : [sqleo:discussion] java.lang.NullPointerException Hello, When I click All Object Types, SQLeo returns a java.lang.NullPointerException--see the attached screenshot. SQLeo appears to be connected to the database. I am using the same credentials that I use on MySQL Workbench. I'm running the latest SQLeo and JRE....
Hello, SQLeo can not be compiled any more with java version >=9 This is mainly because package javax.xml.bind.annotation is deprecated If a java Developper was available to fix that it would be very helpfull for all users ! Thanks in advance, Regards PAscal
with postgres driver, downloaded from https://jdbc.postgresql.org/download/postgresql-42.2.5.jar driver: org.postgresql.Driver is available and works
Hello, check Connection String Attributes Separator as described in https://s3.amazonaws.com/athena-downloads/drivers/JDBC/SimbaAthenaJDBC_2.0.6/docs/Simba+Athena+JDBC+Driver+Migration+Guide.pdf you can append those properties at the url end using & and ? or ; depending of the version used. Regards PAscal
Hello, your url seems correct which jdbc driver version are you using ? what is the error message ? Regards PAscal
Hi, thank you ;o) Generating a diagram from a SQL query is possible, from query builder copy your SQL in "syntax" tab, then choose "designer" tab you should something like http://sqleo.sourceforge.net/guide/English_SQLeo_Help_fichiers/image036.jpg Regards PAscal
Could you try option use schema name in syntax definition In menu tools -- preferences -- query builder ?
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
Hi, you are probably rigth ... I compile SQLeo java projet on windows. But I need some specific classes for Mac that are not included in win jdk, so I use https://developer.apple.com/legacy/library/samplecode/AppleJavaExtensions/AppleJavaExtensions.zip that seems to be java 1.6 ... I'll check if I can find thoses classes build with Java 1.8 An other solution is to compil SQLeo directly on a MAC having a 1.8 JDK installed, are you ready to try ;o) Regards PAscal
Hi, you are probably rigth ... I compile SQLeo java projet on windows. But I need some specific classes for Mac that are not included in win jdk, so I use https://developer.apple.com/legacy/library/samplecode/AppleJavaExtensions/AppleJavaExtensions.zip that seems to be java 1.6 ... I'll check if I can find thoses classes build with Java 1.8 An other solution is to compil SQLeo directly on a MAC having a 1.8 JDK installed, are you ready to try ;o) Regards PAscal
Hi, thank you for using SQLeo for so long. SQLeo is a full java spring application: I think that only a java developer will be able to diagnose and fix this (and unfortunelly I'm not this one ;o( Regards PAscal
Hi, thank you for using SQLeo for so long. SQLeo is a full java spring application: I think that only a java developer will be able to diagnose and fix this (and unfortunelly I'm not, and won't be able to help you ;o( Regards PAscal
Hi, thank you for using SQLeo. SQLeo is a full java spring application: I think that only a java developer will be able to diagnose and fix this (and unfortunelly I'm not this one, and won't be able to help you ;o( Regards PAscal
SQLeo is not packaged for linux, but zip from sourceforge works fine. It seems SQLeo has some similar problems as you on ubuntu and openjdk 9 ...
Sorry I'm not able to reproduce, I don't have win10. May be somebody else can help ? Could you give us your version of java?
Hi, this seems as if your configuration file is corrupted could you: stop SQLeo cd %HOMEPATH% rename .sqleo.config .sqleo.config.corrupted start SQLeo You will have to recreate your connection settings :o(
Thank you for the donation
This script is for starting as a portable app https://sourceforge.net/p/sqleo/code/HEAD/tree/trunk/sqleo-start-PortableApp.txt Sqleo 2016 10 and upper need java version 1.7 mini
Hi, If you want to build from source, you'll need ant if it is just to use it, Double click on the jar file should work
command editor: support EXPLAIN syntax with postgres
command editor: support EXPLAIN syntax with postgres
Ticket #406 support explain in command editor for postgres
command editor: support for explain syntax in postgres
metadata explorer: add datasource filter
table position is wrong on ubuntu with com.sun.java.swing.plaf.gtk.GTKLookAndFeel
Add query parameters
Content Window: quick filter
Designer: save all diagrams as image ( in one operation)
Designer: save all diagrams as image ( in one operation)
Designer: move conditions ON joins to WHERE is wrong with OUTER JOINS
should test Mac OS with version SQLeoVQB.2016.10.rc1.zip before java 1.7 version update
table position is wrong on ubuntu with com.sun.java.swing.plaf.gtk.GTKLookAndFeel
table position is wrong on ubunto with com.sun.java.swing.plaf.gtk.GTKLookAndFeel
DiagramAbstractEntity
I haven't found any screen shot, but using javax.swing.plaf.metal.MetalLookAndFeel will fix your problem as described here If any java developer was able to fix that for other look and feels that would be great ;o)
Could you provide us more informations - SQL server server version - OS type and version of your desktop - Java version - SQLeo version - JDBC name and version - URL used to connect - Full error message
Could you provide us more informations - SQL server server version - OS type and version of your desktop - SQLeo version - JDBC name and version - URL used to connect - Full error message
OK, I miss understood your question. This is possible using the command line (not the GUI) See chapter "Command line features" in http://sqleo.sourceforge.net/guide/English_SQLeo_Help.htm An exemple is available at https://sourceforge.net/p/sqleo/discussion/tips/thread/384495ba/ More Command line actions are described typing "help" in Command editor
choose the auto-connect on startup option http://sqleo.sourceforge.net/images/background%20color.PNG
Version 2017.09.rc1 - Readme and version update
Update pivottable.js to version 2.14.0
update to pivottable.js version 2.14.0
Update csvjdbc driver to 1.0.32
could you try this https://sourceforge.net/p/sqleo/discussion/tips/thread/fee546c5/
from Colin: I am having a problem with the program which has just started. I have a system set up where I run a lap top with 2 screens off to the right. When I move the SQLeo from my laptop screen to the larger screen the program freezes. Not sure if others are having this issue. I am on Java 8 build 144.
still available http://deletionpedia.org/en/SQLeo
this works for me with: jdbc:firebirdsql://localhost:3050/C:\Program Files\Firebird\Firebird_2_5\examples\empbuild\employee.fdb be carrefull to use the driver corresponding to your java version.
could you try the Always Quote Identifiers as described here http://sqleo.source...
are you using quotes for table name ? select * from "ReferenceOuvrage" or select...
Not soon.. Because Dev isfrozen