[MDEV-12957] Maria DB won't work with TOAD Edge Created: 2017-05-30  Updated: 2017-08-19  Resolved: 2017-07-31

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 5.5.54, 5.5.55-galera
Fix Version/s: N/A

Type: Bug Priority: Blocker
Reporter: Clay Jackson Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: galera, need_feedback
Environment:

Ubuntu, Raspbian


 Description   

Hi - disclaimer up front - I work for Quest; but not in the TOAD group.

Quest has released a "Preview Edition" of TOAD Edge for MySQL, which can be found here: https://www.toadworld.com/products/toad-edge

This will eventually become a subscription product and is intended as an "upgrade" to the Toad for MySQL FreeWare. As of this release, it returns this error when attempting to connect to a Maria Database. I've spoken to our Product Manager, and at this point, they are more interested in making sure MySQL works than in chasing this as a problem.

So - I wanted to report it here and see if you have any suggestions for a possible fix.

Thanks!

java.lang.NullPointerException
 
	at com.quest.toad.execution.dataset.AbstractDataset.get(AbstractDataset.java:225)
 
	at com.quest.toad.mysql.core.sql.MySqlDataset.getString(MySqlDataset.java:78)
 
	at com.quest.toad.mysql.core.loader.MySqlUserListLoader57.doLoad(MySqlUserListLoader57.java:55)
 
	at com.quest.toad.loader.ManagedSqlDboListLoader.doLoad(ManagedSqlDboListLoader.java:68)
 
	at com.quest.toad.loader.AbstractSqlDboListLoader.load(AbstractSqlDboListLoader.java:64)
 
	at com.quest.toad.model.DboCollection.resolveModels(DboCollection.java:243)
 
	at com.quest.toad.model.DboCollection._getModels(DboCollection.java:149)
 
	at com.quest.toad.model.DboCollection.getModels(DboCollection.java:176)
 
	at com.quest.toad.model.DboCollection.load(DboCollection.java:213)
 
	at com.quest.toad.core.BackgroundRunner$PreloaderThread.resolveItem(BackgroundRunner.java:141)
 
	at com.quest.toad.core.BackgroundRunner$PreloaderThread.run(BackgroundRunner.java:209)



 Comments   
Comment by Vladislav Vaintroub [ 2017-05-30 ]

To me, this looks like it is toad's exception, not MariaDB's, the full stacktrace. Not even a trace of our (or Oracle MySQL's) JDBC driver here. If Toads code is not available publicly, I'm wondering what we are supposed to suggest.

Comment by VAROQUI Stephane [ 2017-05-31 ]

This is very sad but you can tell the boss that there are many reasons and unique features to MariaDB that can benefit toad

  • The JDBC driver get 20 to 200% performance improvement over the MySQL tm ones
  • The JDBC driver is LGPL so your are not force to pay for licence for every deployement but more work on regular support contract to make sure things get fixed and improved the way you would like it to be on the long run
  • Our drivers support some client side dynamic plugins like authentification, such plugins can be found in some other GUI for MariaDB like HeidiSQL
  • MariaDB have unique features to track down what i happening see kb about sql error log plugin
  • Last Release of MariaDB server have some PL SQL and Oracle compatibility Feature that we know matter for Oracle tm DBA

Please tell us more what driver are you using what

  • content general log
  • content sql error log
  • content of JDBC Driver log

Tx

Comment by Vladislav Vaintroub [ 2017-05-31 ]

stephane@skysql.com It is not clear whether the bug is in JDBC. But it is clear that bug is somewhere in ToaD. NullPointerException comes directly from there.

Comment by VAROQUI Stephane [ 2017-05-31 ]

Last but not least Galera Cluster as mention in internal chat with Vladislav will anyway need a MariaDB JDBC driver to get this worked out , so considering your OEM deep cross solutions and flavor requirements JIRA may not be the best place to get access to our MariaDB Corp connector team.

Comment by Juan Telleria [ 2017-06-02 ]

I use "TOAD for MySQL" v7.9 as my main development GUI, and in that version I do not have any problem and works perfectly.

So the exceptions seems to be only raised in the new TOAD versions, as you suggest.

¿What Version of MariaDB Server are you working with?

Comment by Elena Stepanova [ 2017-06-13 ]

Juan, based on the Affects version/s field, the reporter is working with 5.5 (5.5.54, 5.5.55). What is your version?

Comment by Juan Telleria [ 2017-06-13 ]

I currently use TOAD for MySQL (Not TOAD Edge) with MariaDB Server 10.2.6; but I have also used it with MariaDB Server 10.1, and worked perfectly.

Clay Jackson, ¿Have you tried Toad Edge with MariaDB 10.1 or 10.2?

And by the way, ¿Will TOAD continue offering a freeware version of TOAD? It would be a shame to loose the features TOAD freeware already offers

Comment by Miroslav Stanik [ 2017-08-19 ]

Hi, this bug was in Toad Edge not, in MariaDB or driver.
I know this issue is closed, but just comment: there is a new version of Toad Edge a there is a better support for MariaDB, and we are working on testing of Toad Edge on the last 3 versions of MariaDB.
br.
mstanik

Comment by Juan Telleria [ 2017-08-19 ]

Great.

Feel free mstanik to add info on MariaDB's GUI "Toad Edge" when it is tested and works properly.

https://mariadb.com/kb/en/mariadb/graphical-and-enhanced-clients/

Comment by Juan Telleria [ 2017-08-19 ]

On the Knowledge Base

Generated at Thu Feb 08 08:01:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.