No suitable driver found for jdbc

Question

I'm getting a message that:"No suitable driver found for jdbc:mysql://localhost/db" When I run the jar file in dist folder.

I'm using Netbeans,what's confusing me is the fact that,when I execute the program from inside Netbeans ,it works perfectly.

  try {
       Class.forName("java.sql.DriverManager");
       //**please note that I also tried "com.mysql.jdbc.Driver",but same result**
   }
   catch (Exception e) {
       JOptionPane.showMessageDialog(null, e.getMessage());
   }

And my connection string is:"jdbc:mysql://localhost/db"

None of the dozens of questions already on SO that cover this helped? — Brian Roach, Jan 12 '14 at 08:28

score 2 · Accepted Answer · answered Jan 12 '14 at 08:30

2

First get the appropriate jar, and add it to your class path. Then you can use

Class.forName("com.mysql.jdbc.Driver"); 
DriverManager.getConnection("jdbc:mysql://localhost/test?" +
                               "user=monty&password=greatsqldb");

But you do not use Class.forName("java.sql.DriverManager");.

answered Jan 12 '14 at 08:30

Elliott Frisch

198,278
20
158
249

How do I add it to the classpath? – phpcoderx Jan 12 '14 at 08:31
http://stackoverflow.com/a/9139752/2970947 – Elliott Frisch Jan 12 '14 at 08:34
or http://gpraveenkumar.wordpress.com/2009/06/17/abc-to-import-a-jar-file-in-netbeans-6-5/ – Elliott Frisch Jan 12 '14 at 08:35
And under most circumstances, you don't need to use `Class.forName` anymore. – Stephen C Nov 30 '20 at 06:07

No suitable driver found for jdbc

1 Answers1