By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. StrongYoung 1 2 But it wouldn’t find it until I used either one of these two statements before getting the connection: By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. I am trying to create a connection to my database, when I put test my code using the main method, it works seamlessly.

Uploader: Goltikree
Date Added: 1 December 2008
File Size: 56.26 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 91686
Price: Free* [*Free Regsitration Required]

Go to the locations where jdk and jre are installed and paste the jar file in the ext directory, for example in my case they are C: Why String is Immutable in Java? I added the Class.

Prasad Khode 4, 9 30 Finally issue got resolvedi have changed my pom. If you dql – download it, unpack and drop mysql-connector-java-x. I think if someone could explain why Class. Saturday, September 3, How to solve java.

Interbase java.sql.SQLException: No suitable driver

There may be different reasons for this exception. If those answers do not fully address your question, please ask a new question. Driver” ; I then followed up with removing mysql-connector-java Hari Nair 1 2. From other stackoverflow thread: This question already has an answer here: How to design a vending machine in Sqlexdeption Downloading a more recent driver version will likely also make the problem go away without changing the code.


Try putting the driver jar in the server lib folder. See Javadoc of DriverManager for details. The JDBC spec requires a driver to register itself when the class is loaded, and the class is loaded via Class. In my case application runs fine in suitablr server via maven or stand alonebut when I try to run it in other servers I tested in tomcat and glassfish I get above error.

I noticed a funny where any test in SoapUI would fail until I had tried test connection from the environments and connections screen. If you have not done so, please let me know I shall elaborate the answer.

Interbase eption: No suitable driver

This way it is working for me. This question already has an answer here: Most of time it happen because two mysql-connector-java I have not loaded the sqlexceptino class, but it works locally, I can query the results from MySQL, however, it does not work when I deploy it to Tomcat, and the errors below occur:.


I believe that the connection pool needs to be set up even before the application is instantiated.

It cant find your driver. All of the answers here use the Class.

Then run the file. Driver” ; line to load the driver.

Your program like below will compile fine but as soon as you will run it you will get the error “java. You need to download the driver from here: Driver” ; This is what you are missing to have everything working.

Restart the server and it should work. Download the mysql jdbc driver and unzip it If you have not. 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.