SQLException: No suitable driver found [duplicate]

by

java.sql.SQLException: No suitable driver found

This exception can have 2 causes:

  1. The JDBC driver is not loaded at all.
  2. URL does not match any of the loaded JDBC drivers.

Since the driver seems to be loaded (although in an incorrect manner), it look like that the URL is plain wrong. Ensure that the value of your url variable matches the following format

jdbc:mysql://localhost:3306/dbname

See also:

Unrelated to the concrete problem: Java code doesn’t belong in a JSP file. Work on that as well. Your exception handling is also terrible, you should throw the exception (so that it blocks executing the remnant of the code) instead of printing the message/trace and then continue with the code.

More Related Contents:

  1. MySQL JDBC Driver 5.1.33 – Time Zone Issue
  2. “Incorrect string value” when trying to insert UTF-8 into MySQL via JDBC?
  3. How to fix: “No suitable driver found for jdbc:mysql://localhost/dbname” error when using pools? [duplicate]
  4. JDBC batch insert performance
  5. What is the MySQL JDBC driver connection string?
  6. In Apache Spark 2.0.0, is it possible to fetch a query from an external database (rather than grab the whole table)?
  7. Am I Using JDBC Connection Pooling?
  8. How to configure Tomcat to connect with MySQL
  9. Where can I download mysql jdbc jar from? [closed]
  10. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  11. java.sql.SQLException: No database selected – why?
  12. What is the jdbc driver “org.gjt.mm.mysql.Driver” for?
  13. how to delete data from table A besides the customer service and director data in table B?
  14. Get records with max value for each group of grouped SQL results
  15. How to properly create composite primary keys – MYSQL
  16. Is there a MySQL option/feature to track history of changes to records?
  17. MySQL: multiple tables or one table with many columns? [closed]
  18. How can I Insert many rows into a MySQL table and return the new IDs?
  19. What is cardinality in MySQL?
  20. Can MySQL replace multiple characters?
  21. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  22. Using ORDER BY and GROUP BY together
  23. How can VBA connect to MySQL database in Excel?
  24. MySQL Pivot Table Column Data as Rows
  25. updating columns with a sequence number mysql
  26. How repair corrupt xampp ‘mysql.user’ table?
  27. Select a column with a keyword name
  28. Select all months within given date span, including the ones with 0 values
  29. Use Composite Primary Key as Foreign Key
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment