Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

No Suitable driver found for jdbc:mysql:// #1317

Closed
AdamFermier opened this issue Jan 26, 2016 · 19 comments
Closed

No Suitable driver found for jdbc:mysql:// #1317

AdamFermier opened this issue Jan 26, 2016 · 19 comments

Comments

@AdamFermier
Copy link

Working on Gephi Version 0.90 and trying to connect to an edge list library (MySQL) - which I was able to do in Gephi Version 0.8.2 following the "instructions" found here: https://forum.gephi.org/viewtopic.php?f=3&t=3580&p=10712#p10712 - followed those same instructions with no luck.

Any suggestions?

@computermacgyver
Copy link

Check out #1225 . Is the problem fixed if you right click Gephi and use the run as administrator option?

@AdamFermier
Copy link
Author

Thanks! That got the "Test Connection" to work - but when I go to pull the data (i.e., click ok button) window goes away - but the "import progress" in bottom RHS does not show up in Gephi 0.90 like it does for Gephi 0.8.2.

Almost there - any further suggestions?

@mbastian
Copy link
Member

Weird, if you don't get an error here the query should have worked. Maybe the query just return nothing? Take a look at the message log (Windows > Output), maybe there's an error there somehow.

@mbastian
Copy link
Member

Update?

@ShobhitSaxena29
Copy link

Hi I am also facing same problem, getting "No suitable driver found for jdbc:mysql://localhost:3306/sys"

I have tried following:

  1. Help -> check for updates
  2. tools -> plugin -> check for updates
  3. Running Gephi with administrator rights (Run as Administrator)

I am using Gephi 0.9.1

Steps:

  1. File -> Import database -> edge list
  2. Host: localhost
  3. Port: 3306
  4. database: sys
  5. username/pswd: root/root
  6. hit on Test Connection

and getting the error that driver not supported.
Please help urgently...

@ShobhitSaxena29
Copy link

I have tried executing Gephi as admistrator. B7t no success.

@ShobhitSaxena29
Copy link

Have mentioned same in comments as well. Please help me urgently..

@eduramiba
Copy link
Member

What is your java version? Is the mysql connector in your gephi installation? (gephi\gephi\modules\ext\org.gephi.db-drivers\mysql\mysql-connector-java.jar)

@eduramiba
Copy link
Member

Also please post your log file, located at:

C:\Users{username}\AppData\Roaming.gephi{gephi.version}\dev\var\log\messages.log

@ShobhitSaxena29
Copy link

I have Java 1.6 and 1.7 running in my system. Yes gephi\gephi\modules\ext\org.gephi.db-drivers\mysql\mysql-connector-java.jar is present.. let me get you the logs..

@ShobhitSaxena29
Copy link

messages.txt

@eduramiba
Copy link
Member

As I see, https://github.com/gephi/gephi/blob/0.9.1/modules/DBDrivers/src/main/java/org/gephi/io/database/drivers/MySQLDriver.java is not doing the typical Class.forName, though it should not be necessary anymore with recent versions of java (according to https://docs.oracle.com/javase/7/docs/api/java/sql/DriverManager.html).

Can you try to update your Java version to a more recent version of Java 7?

Maybe we should add the Class.forName so it works in all cases.

@ShobhitSaxena29
Copy link

Really sorry, But I can`t change JAVA in my machine, is there any other workaround?

@eduramiba
Copy link
Member

Maybe, let me try something, will write back.

@ShobhitSaxena29
Copy link

Thanks

@eduramiba
Copy link
Member

Can you try to install the following nbm?
db-drivers-0.9.1.nbm.zip

Unzip it, then go to Tools - Plugins - Downloaded and locate the file manually and install it.

@ShobhitSaxena29
Copy link

ok Let me try this..

@ShobhitSaxena29
Copy link

It Worked.. Thanks a lot 👍

@eduramiba
Copy link
Member

Cool! Releasing it through update center then!

@eduramiba eduramiba added this to the 0.9.2 milestone Jun 23, 2016
eduramiba added a commit that referenced this issue Jun 23, 2016
Gephi 0.9 bug saving projects that are in Geo Layout? #1373

Modularity Calculation Throws Exception On Empty Graph #713
Getting null pointer error when trying to calculate modularity #1419

No Suitable driver found for jdbc:mysql:// #1317
No Suitable Driver Found for jdbc:postgresql #1466
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants