SQLeo Visual Query Builder / Discussion / Technical questions: java.lang.NullPointerException

Alan Baker - 2018-12-24

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

NullPointer.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 - 2018-12-25
  
  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.
  
  Any debugging suggestions?
  
  Alan
  
  java.lang.NullPointerExceptionhttps://sourceforge.net/p/sqleo/discussion/general/thread/e8df1c4937/?limit=25#59b5
  
  Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/sqleo/discussion/general/
  
  To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/
  
  alternate
  
  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.

Alan Baker - 2018-12-27

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

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-12-27

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

Last edit: PAscal 2018-12-27

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.

Alan Baker - 2018-12-27

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

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-12-28

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 your (MariaDB/Oracle) MySQL version / java version, declare it and use it in SQLeo as described at http://sqleo.sourceforge.net/guide/English_SQLeo_Help.htm#_Toc467091860

Regards
PAscal

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.

Alan Baker - 2018-12-28

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

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-12-28

Hi
here is a jar file without the MySQL jdbc driver embeded.
Please try with it (following documentation)

Regards
PAscal

SQLeoVQB-without-MySQLdriver-2017.03.rc1+.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.

Alan Baker - 2018-12-28

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

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-12-28

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

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 - 2020-12-20

I'm having the same problem with Oracle thin connection.
Windows 10,
ojdbc8.jar driver.

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.

java.lang.NullPointerException

Helping users to quickly understand SQL queries

Forums

Help

java.lang.NullPointerException

java.lang.NullPointerException

Helping users to quickly understand SQL queries

Forums

Help

java.lang.NullPointerException document.SUBSCRIPTION_OPTIONS = { "thing": "topic", "subscribed": false, "url": "subscribe", "icon": { "css": "fa fa-envelope-o" } };

java.lang.NullPointerException