Use jdbc connection in a web application (jsp, Tomcat and MySQL)

Question

I have a problem when I try to make database calls from a web application.

I'm using a javabean to make these calls. I have already tested this bean, and it is working in classical application (i mean: not a web application).

I tried to use it in a jsp pages, but it didn't work. I got an exception:

>java.sql.SQLException
No suitable driver found for jdbc:mysql://localhost:3306/db_hafic?relaxAutoCommit=true

I read articles about how to make database calls from within tomcat environment, but I'm still quite lost.

I'm using jsp/tomcat/mysql.

stackoverflow.com/questions/2873510/…

Sergey Benner
– Sergey Benner

2012-01-26 10:08:52 +00:00
Commented Jan 26, 2012 at 10:08 — Sergey Benner
– Sergey Benner, Commented Jan 26, 2012 at 10:08

kgiannakakis · Accepted Answer · 2012-01-26 09:57:15Z

3

First read the documentation:

Install the .jar file(s) containing the JDBC driver in Tomcat's common/lib folder. You do not need to put them in your application's WEB-INF/lib folder. When working with J2EE DataSources, the web application server manages connections for your application.

answered Jan 26, 2012 at 9:57

kgiannakakis

104k28 gold badges163 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Aliaksei Kliuchnikau · Accepted Answer · 2012-01-26 10:07:50Z

0

3 common problems:

Incorrect syntax Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/XX","root","XXXX")
Typo mistake on "com.mysql.jdbc.Driver" e.g. Class.forName("com.mysql.jdbc.Driver").newInstance();
Missing mysql_jdbc Jar Include the latest mysql jdbc driver in your tomecat classpath

your situation should be the problem 3, download the driver at http://www.mysql.com/downloads/connector/j/

add the library at WEB-INF/lib/ and deploy again.

Hope it can help!

edited Jan 26, 2012 at 10:07

Aliaksei Kliuchnikau

13.7k4 gold badges64 silver badges74 bronze badges

answered Jan 26, 2012 at 10:03

Calvin Lai

832 silver badges7 bronze badges

Collectives™ on Stack Overflow

Use jdbc connection in a web application (jsp, Tomcat and MySQL)

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related