No suitable driver found java mysql libgdx

Asked Jul 26 '22 at 21:45

Active Jul 26 '22 at 22:23

Viewed 31 times

I am trying to link my project to the db with mysql but I get this error:

No suitable driver found for jdbc:sqlserver://jdbc:mysql://localhost:3306/test;databaseName=test;user=root;password=

I have the mysql connector, so i see the database and the table but i can't connect with code

edited Jul 26 '22 at 21:46

asked Jul 26 '22 at 21:45

witsel

jdbc:sqlserver is **not** for mysql. where did you get the connection string? – nbk Jul 26 '22 at 21:54
I post my code below – witsel Jul 26 '22 at 22:08
remove "`jdbc:sqlserver://" +` as you pass it aölready in address – nbk Jul 26 '22 at 22:15
Like this? Look the code – witsel Jul 26 '22 at 22:23
your connection string must look like this https://stackoverflow.com/a/33854150/5193536 so you must exchange the part of the strong with our variables – nbk Jul 26 '22 at 22:33
My string url like this? "mysql://:@:/" – witsel Jul 26 '22 at 22:55
yes like the link showed you – nbk Jul 26 '22 at 22:56
I did: "mysql://:@:<3306>/"; but don't work – witsel Jul 26 '22 at 23:01
without the < and > they are only to signalize placeholder – nbk Jul 26 '22 at 23:04
I try: String url = "mysql://root:root@localhost:3306/test"; same problem. Maybe i need: Class.forName("com.mysql.jdbc.Driver"); ? – witsel Jul 26 '22 at 23:08
yes according to this here https://www.javatpoint.com/example-to-connect-to-the-mysql-database – nbk Jul 26 '22 at 23:30
Don't work... i don't know – witsel Jul 27 '22 at 09:16
take the code form the last link and try it without any changes, and don't work isn't a proper error message, so here could be anything wrong – nbk Jul 27 '22 at 13:15

0 Answers0