[Eclipsesql-bugs] [ eclipsesql-Bugs-3207893 ] Nullpointer exception when no database selected

[SourceForge.net <no...@so...>]

Bugs item #3207893, was opened at 2011-03-12 18:05
Message generated for change (Tracker Item Submitted) made by rwchristiaanse
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Interface (example)
Group: v1.0 (example)
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Robert Christiaanse (rwchristiaanse)
Assigned to: Nobody/Anonymous (nobody)
Summary: Nullpointer exception when no database selected

Initial Comment:
OS: Windows 7 Ultimate 64 bits
SqlExplorer version: sqlexplorer_plugin-3.6.1_SR1  (Eclipse plugin)
Connector: mysql-connector-java-5.1.15

Bug: NullpointerException when no database selected

Reproduction: Create a connection profile without a database selected in the URL, like jdbc:mysql://localhost:3306. In view "Database Structure" I can now see my databases, so this is just fine.

Try to execute the following query in the SQL Editor: "SELECT * FROM mytable". There are different situations...

Situation 1, no database is selected in the dropdown: A message "No database selected" is showed. This is correct.

Situation 2, a database is selected in the dropdown: A message "java.lang.NullPointerException:null" is showed. This is not correct.

Now change the query into: "SELECT * FROM mydatabase.mytable"

Situation 3, no database is selected in the dropdown: A message "No database selected" is showed. This is not correct. The database is specified in the query.

Situation 4, a database is selected in the dropdown (it does not matter which one): The query is executed. This is correct.

Now I try to prevent this by specifying a database in the url in the connection profile. It now looks like this:  jdbc:mysql://localhost/mydatabase:3306 or jdbc:mysql://localhost/mydatabase

Not sure if this is correct, but what I do know is that it does not really help. I run into similar problems.



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3207893&group_id=132863