• Post Reply Bookmark Topic Watch Topic
  • New Topic

java.sql.SQLException: No suitable driver found for dbms:mysql  RSS feed

 
fady zohdy
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello
i have been stuck in this problem for two days now and i don't seem to find a solution for it.
i started learning mysql to connect my program to a database but every time i try to connect i get this error.
java.sql.SQLException: No suitable driver found for dbms:mysql://localhost:3306/apexdemo
at java.sql.DriverManager.getConnection(DriverManager.java:596)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at JDBCdemo2.main(JDBCdemo2.java:7)

i did the following: - added the mysql-connector-java-5.1.34 jar to my classpath
- added mysql jdbc driver to the project library
- double checked the url syntax and spelling errors
- checked that the server is running

 
Paul Clapham
Sheriff
Posts: 22819
43
Eclipse IDE Firefox Browser MySQL Database
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You didn't double-check the URL syntax enough... there's no "dbms" in it. Check again.
 
fady zohdy
Ranch Hand
Posts: 31
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:You didn't double-check the URL syntax enough... there's no "dbms" in it. Check again.


:D what do you mean there is no dbms? i am sure it's there. is it supposed to be in another format or something?
 
fady zohdy
Ranch Hand
Posts: 31
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul Clapham wrote:You didn't double-check the URL syntax enough... there's no "dbms" in it. Check again.

i am sorry. you were right . thanl you so much. it is supposed to be jdbc
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!