Driver not found in Netbeans IDE

Question

I have read all possible answer here and here and here. I believe I have a problem somewhere else and it may useful to others also.

I have a Java Servlet and it was executing well in eclipse IDE but later I shifted the project to Netbeans. I imported MySQL JDBC driver in Libraries and using the code below for connection

connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/bolsms", "root", "@#$5869@#$");

but I am getting this error No suitable driver found for jdbc:mysql://localhost:3306/bolsms

I looking for answer for two days and community will appreciate that I am not repeating the question.

Edit 1:

MySQL JDBC driver in Libraries Folder

You need to add the driver to the application server library path and restart the app server. Which one are you using? GlassFish? — perissf, Apr 10 '12 at 12:18
@perissf I am using Apache Tomcat 7.0.22.0. As I wrote I have added driver to the Libraries Folder. Let me restart and get back to you. — Gaurav Agarwal, Apr 10 '12 at 12:21
You have shown the application's lib folder. Tomcat's lib folder is a different thing. Moreover, after you have done, you need to the restart Tomcat. Restarting NetBeans is a different thing. — perissf, Apr 10 '12 at 12:42

alain.janinm · Accepted Answer · 2012-04-10T14:36:07.307

6

When you use it in Tomcat you have to explicitly load jdbc driver. I experienced the same error in a servlet in Tomcat. And adding Class.forName("com.mysql.jdbc.Driver"); solve it.

The other thing I think, is to put the jar file in your WEB-INF/lib, then in your project properties, in Libraries, add the JAR you store in WEB-INF/lib.

To create the lib directory, right click on WEB-INF and choose New -> Folder... If you don't see Folder choose Other then in the new windows choose Other again and Folder.

The Tomcat / JDBC issue is referenced here for more information.

edited Apr 10 '12 at 14:36

answered Apr 10 '12 at 13:43

alain.janinm

19,951
10
65
112

I tried loading class with Class.forName("com.mysql.jdbc.Driver") but it does not work. Also I quote from Murach's Java Servlet & JSP (IInd Edition) Page 445 **With JDBC 4.0, the database drive is loaded automatically. This feature is known as automatic driver loading.** There is no WEB-INF/lib folder in Netbeans. I reiterate the problem is specific to Netbeans IDE, it was working fine on Eclipse. – Gaurav Agarwal Apr 10 '12 at 13:59
2

Once again JDBC is loaded automatically yes but not (always) in Tomcat. And my solution works on Netbeans (I don't use Eclipse). If you made a Tomcat project you have a WEB-INF directory for sure. Create the lib directory yourself and add the jar. It's how I do on Netbean. See this link https://issues.apache.org/bugzilla/show_bug.cgi?id=48214 – alain.janinm Apr 10 '12 at 14:17
1

Thanks. I will appreciate if you could edit the answer to include creation of lib folder and bug link in your answer. – Gaurav Agarwal Apr 10 '12 at 14:31

score 1 · Answer 2 · answered Apr 10 '12 at 12:53

1

Include the following piece of code in your code:

Class.forName("com.mysql.jdbc.Driver");//load driver
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/bolsms", "root", "@#$5869@#$");//connect to the database

answered Apr 10 '12 at 12:53

mykey

575
2
10
24

1

Second line code is already there and Loading Driver is not necessary in JDBC 4 which is part of Java 6. – Gaurav Agarwal Apr 10 '12 at 12:59

score 0 · Answer 3 · answered Oct 24 '12 at 11:40

0

you could also import it using the jsp tag <%@page import='com.mysql.jdbc.*'%> or the usual way Class.forName("com.mysql.jdbc.Driver").newInstance(); in the try catch of the jsp page. Good luck

answered Oct 24 '12 at 11:40

Douglas olupot

11
1

score 0 · Answer 4 · answered Jan 31 '14 at 23:11

Check to make sure that your mysql-connector-java-(version)-bin.jar is here:

C:\Murach\Servlets and JSP\jsp2_allfiles\servlet_jsp\netbeans\ex_starts\ch14sqlGateway\build\web\WEB-INF\lib

Also check to see if it is in here:

C:\Murach\Servlets and JSP\jsp2_allfiles\servlet_jsp\netbeans\ex_starts\ch14sqlGateway\web\WEB-INF\lib

If it's not, paste your mysql driver jar into those directories and see if that works.

After that, make sure you're explicitly loading the driver:

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

Driver not found in Netbeans IDE

4 Answers4