But it wouldn’t find it until I used either one of these two statements before getting the connection:. Do you have mysql running on your computer? Try putting the driver jar in the server lib folder. This also helped me when I was setting up TeamCity. I even tried to copy mysql-connector-java Add the driver class to the bootstrapclasspath.

Uploader: Mitaur
Date Added: 14 January 2013
File Size: 48.1 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 77669
Price: Free* [*Free Regsitration Required]

Deathcore Ortega 19 5. Stack Overflow works best with JavaScript enabled. Driver” ; This is what you are missing to have everything working. Joan Payano Camacho 21 1. Using Eclipse Juno downloaded, not installed via the software centreTomcat 7 downloaded in a custom user directory also added as a Server in Eclipse, Dynamic Web Project with a 3. I had a similar problem, just verify the port where your Mysql server is running, that will solve the problem.

I was also getting the same error but could not find a single working solution and wasted my whole day after it. Driver” ; This forces the driver to register itself, so that Java knows how to handle those database connection strings. No, starting with Java 6, Class.


Interbase eption: No suitable driver

Driver ; OR Class. If the driver is currently registered, no action is taken Use DriverManager. Hope this helps anyone starting development with this specific situation: I put in mysql connector 5. An example of retrieving data from a table having columns column1, column2 ,column3 column4, cloumn1 and 2 hold int values and column 3 and 4 hold varchar 10 import java.

I am using jdk version 1. If the driver is currently registered, no action is taken.

java.sql.SQLException: No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [Solution]

Bro, you can also write code as below: But it wouldn’t find it until I used either one of these two statements before getting the connection: I would recommend using this and not jdk 11 latest till the date this is being written because jdk 9 onwards do not include jdbcexcwptionreporter explicitly Read more here: In my case application runs fine in jetty server via maven or stand alonebut when I try to run jdbcexceptionfeporter in other servers I tested in tomcat and glassfish I get above error.

Copied jar from the Platform Independent zip file into the folder prompted in TeamCity setup and hit refresh drivers button.


Suitsble can stick the jar in the path of run time of jboss like this: Mine was solved like that. Hari Nair 1 2.

If those answers do not fully address your question, please ask a new question. Max 1, 7 No suitable driver found for jdbc: Text copied from this answer: Susie 3, 6 39 From other stackoverflow thread: Abhishek J 26 1. See Javadoc of DriverManager for details. When running the code outside of tomcat, from a standalone java app, this worked just fine: Driver” statement along with adding the connector driver.

Tunde Pizzle 1 7 There may be different reasons jdbcexdeptionreporter this exception. I believe that the connection pool needs to be set up even before the application is instantiated.