Skip to Main Content
  • Questions

  • SQL Developer gives error 0 when attempting to connect to MySQL

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Kevin.

Asked: May 10, 2016 - 6:26 pm UTC

Last updated: May 14, 2016 - 3:33 am UTC

Version: 4.1.3.20

Viewed 10K+ times! This question is

You Asked

Hi,
I upgraded at the end of April to Ubuntu 16.04 and SQL Developer immediately stopped working when attempting to connect to my MySQL databases. I downloaded and installed the latest SQL Developer (4.1.3.20 Build Main-20.78). I am still getting error:
An error was encountered performing the requested operation:

Invalid connection information specified.
Verify the URL format for the specified driver.

Vendor code 0

My CLASSPATH = /root/sqldeveloper/mysql-connector-java-5.1.38/mysql-connector-java-5.1.38.bin.jar:/root//sqldeveloper/sqldeveloper/extensions/oracle.sqldeveloper.thirdparty.drivers/lib
JDK_PATH=/root/jdk1.8.0_25

java -version
openjdk version "1.8.0_91"
OpenJDK Runtime Environment (build 1.8.0_91-8u91-b14-0ubuntu4~16.04.1-b14)
OpenJDK 64-Bit Server VM (build 25.91-b14, mixed mode)
For my connection named mysql, username=root, the Custom JDBC URL is
jdbc:mysql://localhost:3306

I am able to connect to the database from the command line and run queries normally.

Thanks in advance,

Kevin

and Connor said...

Take a look here

http://www.thatjeffsmith.com/archive/2012/01/sql-developer-supports-db2-sybase-mysql-access-and-teradata/

and

http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html#conf

Make sure you got the driver defined under your 3rd party drivers under Preferences. Perhaps it got removed or moved as part of your upgrade.

Hope this helps.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

SQL Developer

Kevin Jaspan, May 11, 2016 - 1:58 am UTC

Thanks for the response. I have done all that already and it didn't work.
My preferences screen is much the same as the first reference and points to the jar file for 5.1.38.

The connection configuration screen is much simpler than the second reference, as I described in my question.

Kevin
Connor McDonald
May 14, 2016 - 3:33 am UTC

Yeah...I'm striking a blank with this one.

SQL Dev is a supported product - maybe log an SR and see if that gets you any more joy.

Sorry.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.