connect mysql with java using eclipse

Question

i can connect mysql with java using eclipse in a java application with these statements

String unicode = "?useUnicode=yes&characterEncoding=UTF-8";
Class.forName("com.mysql.jdbc.Driver");
            con = (Connection) DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/ams-competation" + unicode,
                    username, password);

and it works good

but my problem is when i tried to connect to mysql with a server application i got this exception

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver what am i doing wrong?thank you all

Edit

i have added mysql-connector already

Please include the driver jar file in either server or application lib. — Santosh
– Santosh, Commented Jun 22, 2012 at 10:02
@tottiroma: If you have added it, you hadn't got this error message — buc
– buc, Commented Jun 22, 2012 at 10:07
@buc really i added it , and i can see it on the Referenced Libraries tab on Eclipse — William Kinaan
– William Kinaan, Commented Jun 22, 2012 at 10:08
Yes you have added it in Eclipse, but you have not added it to the application server. — buc
– buc, Commented Jun 22, 2012 at 10:09

Pramod Kumar · Accepted Answer · 2012-06-22 10:02:36Z

3

I think you have not included mysql drive jar in your web project.

put mysql-connector-java.. jar file in your web projects lib folder

answered Jun 22, 2012 at 10:02

Pramod Kumar

8,0345 gold badges30 silver badges37 bronze badges

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

6 Comments

Pramod Kumar Over a year ago

Goto your WEB-IF/lib folder and check if jar is there or not?

William Kinaan Over a year ago

can i copy past the jar to that folder?

Pramod Kumar Over a year ago

You can also put it directly in your servers lib folder... what web server you are using?

Pramod Kumar Over a year ago

Yes you can you can copy jar to lib folder directly

William Kinaan Over a year ago

tomkat , i am trying but it take some minutes cos the client is android

|

Hemant Metalia · Accepted Answer · 2012-06-22 10:08:51Z

1

for that you need to add the mysql-connector jar in the classpath.

This is because eclipse is not able to find the jar file you specified.

Hence put the jar file in the server`s lib directory

another way is to put jar file it in /WEB-INF/lib eclipse itself will notice it and get it.

edited Jun 22, 2012 at 10:08

answered Jun 22, 2012 at 10:02

Hemant Metalia

30.8k18 gold badges77 silver badges93 bronze badges

3 Comments

Hemant Metalia Over a year ago

it should be added to the server`s lib folder by doing so you can resolve the exception..

William Kinaan Over a year ago

can i add it to that folder using copy past , or i have to do some configuration steps ?

William Kinaan Over a year ago

i really thank you for helping , hope i could accept more than one answer :( , really very thank you for helping , it works

hpityu · Accepted Answer · 2012-06-22 10:09:37Z

1

Did you add the MySQL driver to the server?

It depends on the application server where the jar file is needed to be added:

Apache Tomcat: $CATALINA_HOME/common/lib
GlassFish server: GLASS_FISH_INSTALL_DIR\lib

Or add it the WEB-INF/lib folder of your web application

Try adding the mysql-connector-java-5.1.20-bin.jar file (downloadable from: http://dev.mysql.com/downloads/connector/j/ ), and restart the server.

edited Jun 22, 2012 at 10:09

answered Jun 22, 2012 at 10:04

hpityu

88911 silver badges21 bronze badges

5 Comments

hpityu Over a year ago

did you add it to the correct location AND restart the server afterwards?

William Kinaan Over a year ago

i add it on this way , right click on the project , buid path, configuration build path , add external jar file , then select mysql-connector-java-5.1.13 i can see the jar file on references libraries tab , but not on WEB-INF

hpityu Over a year ago

If you just reference it to your project it will NOT be uploaded to the server. You need to add it to the correct folder too.

William Kinaan Over a year ago

and how can i do that ? and what is the correct folder , thank you

hpityu Over a year ago

It is in my answer... It depends on your server. If you don't want to use it from multiple applications then you can also put it in the WEB-INF/lib folder of your web application

hage · Accepted Answer · 2012-06-22 10:02:29Z

0

Add the Connector/J jar file to the server's classpath (or lib folder)

answered Jun 22, 2012 at 10:02

hage

6,1933 gold badges36 silver badges46 bronze badges

Comments

Fathah Rehman P · Accepted Answer · 2012-06-22 10:04:25Z

0

add my sql connection jar file to your project. Its name will be something like "mysql-connector-java-5.1.13-bin.jar"

answered Jun 22, 2012 at 10:04

Fathah Rehman P

8,8014 gold badges43 silver badges42 bronze badges

Comments

Arslan Farooq · Accepted Answer · 2018-07-04 11:07:29Z

0

connect connector/J 8.0.11 with eclipse oxygen by following line of code.

 Class.forName("com.mysql.cj.jdbc.Driver");
           conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testing?autoReconnect=true&useSSL=false", "AF", "birru123");

        Statement st = conn.createStatement();

answered Jul 4, 2018 at 11:07

Arslan Farooq

211 bronze badge

Collectives™ on Stack Overflow

connect mysql with java using eclipse

Edit

6 Answers 6

6 Comments

3 Comments

5 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Edit

6 Answers 6

6 Comments

3 Comments

5 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related