SQLeo Visual Query Builder Activity
Helping users to quickly understand SQL queries
Brought to you by:
legrand_legrand
Activity for SQLeo Visual Query Builder
-
Totya posted a comment on discussion Tips / How to
Nice, I read manuals and I try it. I'm about beginner in sql. Query designer its a good idea, but slightly compicated to use it, because my simple query (SELECT-FROM-WHERE(AND, OR)) from the syntax page, in the designer page changed to many INNER JOIN, and its hard to hard to grasp for me. But I think its my problem. Thanks for this tool! :)
-
PAscal posted a comment on discussion Tips / How to
no problem, pleased to see that the tool is still used :0) Regards
-
Okay, Its done via http://kenfallon.com/adding-sqlite-as-a-datasource-to-sqleo/ pls. delete this topik.
-
Okay, Its done via https://sqleo.sourceforge.io/guide/English_SQLeo_Help.htm#_Toc467091854 pls. delete this topik.
-
Okay, Its done via [docs]https://sqleo.sourceforge.io/guide/English_SQLeo_Help.htm#_Toc467091854) pls. delete this topik.
-
Hi! How can I use this software with sqlite databese to build query? Hogy can I open sqlite database? Thanks!
-
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
-
Anonymous posted a comment on discussion News
hello Pascal I used github to sync the files from sourceforge - it synced all files and commit history into anudeepg/SQLeo. No idea jf we can sync also tickets, support, daicussion into github as well. Regards Anudeep ( sqleo dev )
-
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)
-
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
-
Hagai Stavi posted a comment on discussion Technical questions
Hello everybody, Is there a way to export the "Syntax" file to a text file? Or maybe there is a way to get into the "Syntax" object from CLI? Hagai
-
Anonymous posted a comment on discussion Technical questions
I'm having the same problem with Oracle thin connection. Windows 10, ojdbc8.jar driver.
-
Anonymous posted a comment on discussion Technical questions
这个牛逼，真的解决了。
-
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
-
Anonymous posted a comment on discussion Technical questions
Old and presumably wrong configuration file causing the strange evil, finally solved. rm -rf ~/.sqleo.config save may the day, month and year... Thank you so much for your help. SQLeo is great, as you are guys! ps. take it easy, I'm a little exaggerated ;)
-
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/*"...
-
emezeta posted a comment on discussion Technical questions
Thanks PAscal, The output is: ~/setups/apps/SQLeoVQB.2019.01.rc1$ java -cp "SQLeoVQB.jar;lib/*" com.sqleo.environment.Application Error: Could not find or load main class com.sqleo.environment.Application Caused by: java.lang.ClassNotFoundException: com.sqleo.environment.Application The ./lib folder contents: ~/setups/apps/SQLeoVQB.2019.01.rc1$ ls -l lib/ 173707 set 17 2017 csvjdbc-1.0-32.jar 78030 ene 23 2019 javax.activation-JAF1.2.0.jar 125632 ene 13 2019 jaxb-api-2.3.0.jar 255502 ene 23 2019...
-
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
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 also...
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 also...
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 also...
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 also...
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, it failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 (also...
-
Hello, SQLeo seems ok to get a db connection by setting up driver, etc. When we try to achieve, either schema o data information from database, failure with some exception error messages, usually 'java.lang.NullPointerException' on scrren pop-up. SQLeo don't brake down, you can continue normal execution. system ref.: SQLeoVQB.2019.01.rc1 on Ubuntu 18.04 LTS PostgreSql: pg_ctl (PostgreSQL) 9.6.19 Db Diver: PostgreSQL JDBC Driver, org.postgresql.jdbc, 42.2.14 Java: openjdk "11.0.8" 2020-07-14 (also...
-
Robin modified a comment on discussion Technical questions
Hi guys, It has been resolved. Solution url: jdbc:db2://"IP address":"Port no"/"Databasename" Type without "" Without put your DB NAME wont work. Thanks
-
Hi guys, It has been resolved. Solution url: jdbc:db2://<ip address="">:<port no="">/<databasename></databasename></port></ip> Type without <> Without put your DB NAME wont work. Thanks
-
Hi guys, It has been resolved. Solution: jdbc:db2://<ip address="">:<port no="">/<db name=""></db></port></ip> Type without <> Without put your DB NAME wont work. Thanks
-
Hi guys, It has been resolved. Solution: jdbc:db2://<ip address="">:<port no="">/<have name="" db="" here="" ur="" to="" put=""></have></port></ip> Type without <> Without put your DB NAME wont work. Thanks
-
Hi guys, I need some help and has been troubleshooting for 1 day and half. My Db2 is using V10.5 Version Java 8 update 261 The driver that i download from IBM is compatible with my database version Db2 V10.5 https://www.ibm.com/support/fixcentral/swg/downloadFixes?parent=ibm%2FInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=10.5.*&platform=All&function=fixId&fixids=DSClients--jdbc_sqlj-10.5.0.11-FP011&includeRequisites=1&includeSupersedes=0&downloadMethod=http...
-
Anu committed [r646]
fix website
-
This is fixed now.
-
David posted a comment on discussion Technical questions
Thanks PAscal - that did indeed help with the error message. But the (successful!) SSH tunnel (see thread linked in your original message above) means, it appears, that this error message is not triggered in any case. Good to know, though! Thanks.
-
Did it! Thanks - those links were a real help, but they eventually led me to the Postgresql help on SSH tunnels. Putting that all together, I came up with a command line (in shell on Ubuntu) that looks like this: $ ssh -L 63333:localhost:5432 serverid@example.com -p 22 where serverid is my login identity on the remote machine, -p prompts for password authentication, and 22 is the port I login to. Then, in SQLeo, my connection profile looks like this: jdbc:postgresql://localhost:63333/dbname with...
-
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/...
-
I am trying to use SQLeo to connect to a database which lives on a remote server. The "new connection" dialog for SQLeo allows me to enter credentials for the database, but no user/passwd for actually getting data from the remote server. In my case, the "db user" and the "server user" credentials are different. I notice a couple other threads in this forum which exhibit the same symptoms as I see: https://sourceforge.net/p/sqleo/discussion/general/thread/e8df1c4937/ and a much older one: https://sourceforge.net/p/sqleo/discussion/general/thread/e75dae49/...
-
I am trying to use SQLeo to connect to a database which lives on a remote server. The "new connection" dialog for SQLeo allows me to enter credentials for the database, but no user/passwd for actually getting data from the remote server. In my case, the "db user" and the "server user" credentials are different. I notice a couple other threads in this forum which exhibit the same symptoms as I see: https://sourceforge.net/p/sqleo/discussion/general/thread/e8df1c4937/ and a much older one: https://sourceforge.net/p/sqleo/discussion/general/thread/e75dae49/...
-
I am trying to use SQLeo to connect to a database which lives on a remote server. The "new connection" dialog for SQLeo allows me to enter credentials for the database, but no user/passwd for actually getting data from the remote server. In my case, the "db user" and the "server user" credentials are different. I notice a couple other threads in this forum which exhibit the same symptoms as I see: https://sourceforge.net/p/sqleo/discussion/general/thread/e8df1c4937/ and a much older one: https://sourceforge.net/p/sqleo/discussion/general/thread/e75dae49/...
-
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
-
webswing: java.lang.ClassCastException: class org.webswing.common.GraphicsWrapper cannot be cast to class sun.java2d.SunGraphics2D
-
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
-
Anonymous posted a comment on discussion Technical questions
Hi switching from Ubuntu 19.04 to Ubuntu 20.04 LTS I can no longer connect the DB using the jdbc: mysql: // localhost: 3306 How can i solve? Thanks in advance regards Max
-
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
-
PAscal posted a comment on discussion Technical questions
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
-
Colin posted a comment on discussion Technical questions
Hi PAscal I am using the Connector J that comes with MySQL. You can see the picture of the what I see in the explorer. If I scroll down here you see every schema in the DB. [cid:part1.746A5113.77E59A07@outlook.com] Here is what I see when I create a query in the visual query builder. This is showing the fields from 3 different versions of the disciplines table in 3 different schema's even thou the connection is to only one of the schemas. Selecting the wrong field give error when the select is run....
-
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...
-
Not sure if this is still being mainatained or not. I suspect this an MySQL issue but when I connect to a single DB in mysql 8.0 I can see all the fields in all databases. When I look at the table definitions on the meta data it shows the table definitions in every database that the table exists in on the MySql Server When I try to create a query I get the field list from every table of that name in every schema. The schema's are different so a table in one schema might have fields that a table with...
-
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
-
SQLeo Visual Query Builder released /SQLeoVQB/SQLeoVQB.2019.01.rc1.zip
-
support for java 9,10 and 11
-
fix undomanager > java8
-
Thank you Herbert, Anudeep developper of SQLeo has found some time to start the migration. We have a Beta verion in tests Regards PAscal
-
Anonymous posted a comment on discussion Donate, sponsor, contribute
Hello PAscal, I'm no developer but in https://crunchify.com/java-11-and-javax-xml-bind-jaxbcontext/ there seems to be a hint for solution. Regards Herbert
-
fix classcast exception
-
jaxb jars as sqleo startup classpath params
-
Fix NPE in claspath and add jaxb in lib folder for > java 8
-
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
-
Alan Baker posted a comment on discussion Technical questions
Hi PAscal, I ran the jar without MySQL driver, installed the latest MariaDB connector, and got the same result. So I thought maybe the Java version was significant, so I tried running it with JRE 8 update 131 as you did, but still got the same result. Thanks for your help, but I'm giving up. Alan
-
Hi here is a jar file without the MySQL jdbc driver embeded. Please try with it (following documentation) Regards PAscal
-
Thanks, PAscal. My server is running 10.2.20-MariaDB. I downloaded the latest connector, MariaDB connector/J version 2.3.0 and put its location into the CLASSPATH. I still get the null pointer exception, but maybe SQLeo didn't use the new connector. How can I confirm that it is actually using the new connector? Regards, Alan
-
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...
-
I'm running Windows 10 Pro with Java version 8 update 191 released October 16, 2018. I'm connecting with MySQL (MariaDB Jdbc Driver). The output of the command java -jar SQLeoVQB.jar is SystemLookAndFeel: com.sun.java.swing.plaf.windows.WindowsLookAndFeel SQLeoUsingLookAndFeel: [The Java(tm) Look and Feel - javax.swing.plaf.metal.MetalLookAndFeel] version: 2017.03.rc1+ Loading resources... Loading window... HTTP status: 200 Server version:2017.03.rc1 Alan
-
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 Thank you, PAscal. Is there a recommended version of Java for SQLeo? I'm running Windows 10 Pro with Java version 8 update 191 released October 16, 2018. Alan
-
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, 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. Any debugging suggestions? Alan
-
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
-
Anonymous posted a comment on discussion Technical questions
I have tried that one. The result is the same:
-
with postgres driver, downloaded from https://jdbc.postgresql.org/download/postgresql-42.2.5.jar driver: org.postgresql.Driver is available and works
-
Anonymous posted a comment on discussion Technical questions
That guide does not help. I have installed libpostgresql-jdbc-java 42.2.5-1.pgdg100+1 on my computer (the same as the driver on the webpage you refer to) but there is no file org.postgresql.Driver in the package not even in the source of the package. Yet your gui is looking for org.postgresql.Driver . Pointing it to any of the postgresql*.jar-files in /usr/share/java does not make any difference: /usr/share/java/postgresql-42.2.5.jar /usr/share/java/postgresql-jdbc3.jar /usr/share/java/postgresq...
-
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
-
Anonymous posted a comment on discussion Technical questions
When connecting to AWS Athena using the Athena jdbc connector you need to specify the usual connection parameters: URL, user, password but you need also to specify an extended parameter: S3OutputLocation Without it the connection failed. How can I add it?
-
Anonymous posted a comment on discussion Technical questions
I use the MariaDB driver to access multiple MySQL schemas--the mySQL driver does not show multiple schemas.
1 >