1. Driver Connection Failed Voxal Solucion 3

1) Download and install Driver Easy (you can download the.exe file in a USB drive from a computer with the Internet connection, then install Driver Easy in this computer). 2) Run Driver Easy and click Scan Now.Then Driver Easy will scan your computer and detect any problem drivers. 3) Click the Update button next to the network device to download the correct driver (you can do that with the.

This question already has an answer here:

• The infamous java.sql.SQLException: No suitable driver found 12 answers

I am trying to create a connection to my database, when I put test my code using the main method, it works seamlessly. However, when trying to access it through Tomcat 7, it fails with error:

I am using pooling. I put in mysql connector (5.1.15), dbcp (1.4) , and pool(1.4.5) libraries in WEB-INF/lib and in .classpath as well. I am using Eclipse IDE. My code for the database driver is:

Start of my stack trace:

What is causing this error?

TamerTamer

marked as duplicate by BalusC jdbcFeb 5 '17 at 12:26

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

21 Answers

Try putting the driver jar in the server lib folder. ($CATALINA_HOME/lib)

I believe that the connection pool needs to be set up even before the application is instantiated. (At least that's how it works in Jboss)

uncaught_exceptionsuncaught_exceptions

The reason you got this error:

Is because you forgot to register your mysql jdbc driver with the java application.

This is what you wrote:

Should be this:

You'll have to read the manual on your specific mysql jdbc driver to find the exact string to place inside the the Class.forName('...') parameter.

Class.forName not required with JDBC v.4

Starting with Java 6, Class.forName('something.jdbc.driver.YourFubarDriver') is not necessary anymore if you use a recent (JDBC v.4) driver. For details read this: http://onjava.com/pub/a/onjava/2006/08/02/jjdbc-4-enhancements-in-java-se-6.html

Eric LeschinskiEric Leschinski

I had the same problem using Tomcat7 with mysql-connector-java-5.1.26 that I put in both my $CATALINA_HOME/lib and WEB-INF/lib, just in case. But it wouldn't find it until I used either one of these two statements before getting the connection:

DriverManager.registerDriver(new com.mysql.jdbc.Driver ());

OR

Class.forName('com.mysql.jdbc.Driver');

I then followed up with removing mysql-connector-java-5.1.26 from $CATALINA_HOME/lib and the connection still works.

When running tomcat out of eclipse it won't pick the lib set in CATALINA_HOME/lib, there are two ways to fix it. Double click on Tomcat server in eclipse servers view, it will open the tomcat plugin config, then either:

1. Click on 'Open Launch Config' > Classpath tab set the mysql connector/j jar location.or
2. Server Location > select option which says 'Use Tomcat installation (take control of Tomcat installation)'

DaSourcerer

I had the mysql jdbc library in both $CATALINA_HOME/lib and WEB-INF/lib, still i got this error . I needed Class.forName('com.mysql.jdbc.Driver'); to make it work.

I had the same problem, all you need to do is define classpath environment variable for tomcat, you can do it by adding a file, in my case C:apache-tomcat-7.0.30binsetenv.bat, containing:

then code, in my case:

works fine.

Aliaksandr Belik

I'm running Tomcat 7 in Eclipse with Java 7 and using the jdbc driver for MSSQL sqljdbc4.jar.

When running the code outside of tomcat, from a standalone java app, this worked just fine:

However, when I tried to run the same code inside of Tomcat 7, I found that I could only get it work by first registering the driver, changing the above to this:

Tunde PizzleTunde Pizzle

if you are using netbeans you must add Mysql JDBC driver in the library list of the project, in the properties of your project

Gapchoos

I also had the same problem some time before, but I solved that issue.

There may be different reasons for this exception.And one of them may be that the jar you are adding to your lib folder may be old.

Try to find out the latest mysql-connector-jar version and add that to your classpath.It may solve your issue. Mine was solved like that.

j0k

Driver Connection Failed Voxal Solucion 3

Most of time it happen because two mysql-connector-java-3.0.14-production-bin.jar file.One in lib folder of tomcat and another in classpath of the project.

Just try to remove mysql-connector-java-3.0.14-production-bin.jar from lib folder.

This way it is working for me.

From what i have observed there might be two reasons for this Exception to occur:(1)Your Driver name is not spelled Correctly.(2)Driver hasn't been Associated Properly with the Java Project Steps to follow in Eclipse: (1)Create a new Java Project. (2)copy The connector Jar file (3)Right Click on the Java project and paste it there. (4)Right click on the Java project -> Properties ->Java Build Path - >libraries-> Add Jar ->choose ur project(select the jar file from dropdown) and click ok.

The solution is straightforward.

Make sure that the database connector can be reached by your classpath when running (not compiling) the program, e.g.:

Also, if you're using an old version of Java (pre JDBC 4.0), before you do DriverManager.getConnection this line is required:

PacerierPacerier

When developing using Ubuntu (Xubuntu 12.04.1) I 'HAD' to do the following:

Using

Eclipse Juno (downloaded, not installed via the software centre), Tomcat 7 (downloaded in a custom user directory) also added as a Server in Eclipse, Dynamic Web Project with a 3.0 Servlet, MySQL Server on localhost configured and tested with user and password (make sure to test)MySQL connector driver 5.1.24 jar,

I 'HAD', and I repeat 'HAD', to us the Class.Load('com.mysql.jdbc.Driver') statement along with adding the connector driver.jar to be in the web project lib folder for it to work in this situation.

IMPORTANT!!: after you copy the driver.jar to the lib make sure you refresh your project in Eclipse before running the servlet via Tomcat.

I did try adding the connector driver jar file via the Build Path with and without ClassLoad but it did not work!

Hope this helps anyone starting development with this specific situation: the Java community provides a 'LOT' of documentation but there are so many variables its hard to cover all of them and it makes things very hard on the new guy.

I think if someone could explain why Class.Load is required here (in this situation) it would be beneficial.

Enjoy

Since no one gave this answer, I would also like to add that, you can just add the jdbc driver file(mysql-connector-java-5.1.27-bin.jar in my case) to the lib folder of your server(Tomcat in my case). Restart the server and it should work.

SusieSusie

1. Put mysql-connector-java-5.0.8-bin.jar in $CATALINA_HOME/lib

2. Check for typo in connection url, example
   'jdbc:mysql://localhost:3306/report' ('report' here is the db name)

3. Make sure to use machine name(example : localhost instead of ip address(127.0.0.1))

Add the driver class to the bootstrapclasspath. The problem is in java.sql.DriverManager that doesn't see the drivers loaded by ClassLoaders other than bootstrap ClassLoader.

From other stackoverflow thread:

'Second. Make sure that you have MySQL JDBC Driver aka Connector/J in JMeter's classpath. If you don't - download it, unpack and drop mysql-connector-java-x.xx.xx-bin.jar to JMeter's /lib folder. JMeter restart will be required to pick the library up'

Please be sure that .jar file is added directly to the lib folder.

You can stick the jar in the path of run time of jboss like this:

C:Useruserworkspacejboss-as-web-7.0.0.FinalstandalonedeploymentsMYapplicationEAR.eartest.warWEB-INFlib ca marche 100%

ChrisF♦

Not the answer you're looking for? Browse other questions tagged mysqljdbctomcat7apache-commons-dbcp or ask your own question.