SQLeo Visual Query Builder / Discussion / Technical questions: After I launch a query, where do I find the output?

Anonymous - 2014-10-20

I'm somewhat embarrassed to ask such a question. However, when I launch a query, I don't see any results. I was assuming they would open in a new window. I've spent hours trying to figure this out. If someone could point me in the right direction, it would be greatly appreciated.

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 - 2014-10-20

Hi,
could you give us more informations (screenshots could help) ?
- Which db do you use
- What is the query

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.

Anu - 2014-10-20

Could you please also mention the OS and java version, just in case to know if there is any issue.

QueryBuider results are displayed below the diagram, see example here
http://sqleo.sourceforge.net/screenshots.htm

A video demo of SQLeo can be found here
http://sqleo.sourceforge.net/videos/SQLeo%20video.html

More screenshots/videos for SQLeo http://sqleo.sourceforge.net/screenshots.htm

Do not hesitate to go through our wonderful website with lot of info, documentation available
http://sqleo.sourceforge.net/index.html

Thanks for using SQLeo, Your feedback is 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.

Anonymous - 2014-10-20

I can't provide screenshots - unfortunately some of the data I'm using is sensitive, and I probably can't share specifics. The query itself is fine, because I'm able to execute successful on other platforms.

The area where the results are supposed to be just remains gray.

I'm using Ubuntu 14.04 and here are my Java details:

java version "1.7.0_65"
OpenJDK Runtime Environment (IcedTea 2.5.2) (7u65-2.5.2-3~14.04)
OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

Thanks for the quick response everyone.

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 - 2014-10-20

database version
jdbc version
SQLeo version
?

is there an error when launched from shell:
java -jar SQLeo.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.

Anonymous - 2014-10-20

Mysql 5.5.33-31.1-log
SQLeo Version : 2014.10.rc1+

No error when launched from shell

How do I find my jdbc version?

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 - 2014-10-20

Could you please test with SQLeoVQB.2014.08.rc1.zip ?
https://sourceforge.net/projects/sqleo/files/SQLeoVQB/SQLeoVQB.2014.08.rc1.zip/download

You will have to create a new driver (in metadata exporer) and load the one in lib\mariadb-java-client-1.1.6+00.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.
- PAscal - 2014-10-22
  
  Did you test this ?
  
  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 - 2014-10-24

Here is the output I get in my terminal when I run a query:

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at com.sqleo.common.util.Store.addSQLToHistory(Store.java:90)
at com.sqleo.environment.mdi.ClientQueryBuilder$ActionLaunch.onLaunch(ClientQueryBuilder.java:355)
at com.sqleo.environment.mdi.ClientQueryBuilder$ActionLaunch.onLaunchFromDesigner(ClientQueryBuilder.java:346)
at com.sqleo.environment.mdi.ClientQueryBuilder$ActionLaunch.actionPerformed(ClientQueryBuilder.java:412)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2018)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2341)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
at java.awt.Component.processMouseEvent(Component.java:6516)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3311)
at java.awt.Component.processEvent(Component.java:6281)
at java.awt.Container.processEvent(Container.java:2229)
at java.awt.Component.dispatchEventImpl(Component.java:4872)
at java.awt.Container.dispatchEventImpl(Container.java:2287)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4832)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4492)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4422)
at java.awt.Container.dispatchEventImpl(Container.java:2273)
at java.awt.Window.dispatchEventImpl(Window.java:2719)
at java.awt.Component.dispatchEvent(Component.java:4698)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:735)
at java.awt.EventQueue.access$200(EventQueue.java:103)
at java.awt.EventQueue$3.run(EventQueue.java:694)
at java.awt.EventQueue$3.run(EventQueue.java:692)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:87)
at java.awt.EventQueue$4.run(EventQueue.java:708)
at java.awt.EventQueue$4.run(EventQueue.java:706)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:705)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:242)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:146)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:138)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:91)

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 - 2014-10-24

could you go in your home directory in
.sqleo.config
remove file
.sqleo.history.xml
that seems corrupted

restart
and tell us :-)

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 - 2014-10-24

Thanks...where do I find .sqleo.config? I cannot locate. Thanks again for your 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 - 2014-10-24
  
  In java we use
  final String userDir = System.getProperty("user.home");
  
  On Linux that should point to /home/user
  be carefull as files starts with . (dot) you will see them only when using ls -al options or someting like that.
  
  Maybe command 'echo ~username' will give you the answer
  
  On Windows
  points to C:\user\Myuser
  defined by command 'echo %USERPROFILE%'
  
  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.

Anu - 2014-10-24

Normally the error you posted should not happen ,
If you still see it, you can set in Prefernces> General - Max queries in history value to zero and restar to avoid storing in SQL history.

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 - 2014-10-24
  
  Setting max queries to 0 then restarting worked!
  
  Thank you everyone for your time and 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.

After I launch a query, where do I find the output?

Helping users to quickly understand SQL queries

Forums

Help

After I launch a query, where do I find the output?

After I launch a query, where do I find the output?

Helping users to quickly understand SQL queries

Forums

Help

After I launch a query, where do I find the output? document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

After I launch a query, where do I find the output?