Getting java.lang.ClassNotFoundException: com.mysql.jdbc.Driver after deploying to jar

Question

This question has asked many times, but this one is slightly different. In my case, I'm not getting any error when running from Eclipse, it successfully runs and is able to connect to MySQL.

I have a Maven project in Eclipse, using the MySQL database and MySQL Connector/J for connection.

However, after deploying to jar I am getting the error.

I am using mvn clean install to deploy

I have added dependency in pom.xml like:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.49</version>
    <scope>runtime</scope>
</dependency>

I am using following command to run the jar file java -jar ./target/project.jar

but this gives

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

What's wrong here?

Please show the pom.xml of your project. It sounds like you haven't configured Maven to generate the appropriate `Class-Path` entry in the manifest, and put the dependencies in the right location. — Mark Rotteveel, Feb 13 '21 at 11:02

Dmitrii B · Answer 1 · 2021-02-13T10:21:45.523

1

Try to change the scope from runtime to compile or delete String scope at all. This String talks about that this dependency don't load in compile time. When you call maven install then happens source compile and this dependency don't add to classpath.

edited Feb 13 '21 at 10:21

answered Feb 13 '21 at 10:19

Dmitrii B

2,672
3
5
14

I tried that, still getting the same error – NITESH KUMAR Feb 13 '21 at 10:21
try to use mvn clean -am install – Dmitrii B Feb 13 '21 at 10:23
getting build failed while running `mvn clean -am instal` – NITESH KUMAR Feb 13 '21 at 10:29

Anish B. · Answer 2 · 2021-02-13T11:15:51.087

0

Remove <scope>runtime</scope> from the mysql maven dependency as it makes the jar available only in the runtime. Either you don't put the scope at all or put that in compile time.

Do mvn clean install. It will work.

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.49</version>    
</dependency>

Also, you need to create an executable fat jar using maven. Normal jar created by maven is non-executable. It won't work.

To create a executable jar by maven. Refer here.

edited Feb 13 '21 at 11:15

answered Feb 13 '21 at 10:21

Anish B.

9,111
3
21
41

1

tried this as well, but getting same error. – NITESH KUMAR Feb 13 '21 at 10:25
@NITESHKUMAR Share your codebase through github to reproduce the issue. – Anish B. Feb 13 '21 at 10:27
@NITESHKUMAR I got the issue. No, it will not work. You have to create an executable fat jar using maven to make things work. – Anish B. Feb 13 '21 at 10:30
@NITESHKUMAR Did you get my point ? – Anish B. Feb 13 '21 at 10:32
2

no, I didn't, can you explain a bit more? – NITESH KUMAR Feb 13 '21 at 10:32
@NITESHKUMAR You need to jar which executes from a main method. – Anish B. Feb 13 '21 at 10:33
@NITESHKUMAR Maven doesn't create a jar which is executable. – Anish B. Feb 13 '21 at 10:33
@NITESHKUMAR You need to tell maven to create an executable jar. – Anish B. Feb 13 '21 at 10:34
@NITESHKUMAR Now, it's clear. ? – Anish B. Feb 13 '21 at 10:35
1

I am trying, will let you know – NITESH KUMAR Feb 13 '21 at 10:36
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/228666/discussion-between-nitesh-kumar-and-anish-b). – NITESH KUMAR Feb 13 '21 at 10:37
@NITESHKUMAR Wait. Follow this link to create an executable jar using maven - https://stackoverflow.com/questions/574594/how-can-i-create-an-executable-jar-with-dependencies-using-maven – Anish B. Feb 13 '21 at 10:37
1

I already have that, you are talking about the entry point inside mainfest tag, is it? – NITESH KUMAR Feb 13 '21 at 10:44
@NITESHKUMAR Sorry ! Yes – Anish B. Feb 13 '21 at 10:46
1

I didn't do that, really – NITESH KUMAR Feb 13 '21 at 11:09
1

You help a lot, I tried up voting, but not able to so, any way just wanted to say thanks for your efforts – NITESH KUMAR Feb 13 '21 at 11:10
1

But issue is not solved yet – NITESH KUMAR Feb 13 '21 at 11:12
@NITESHKUMAR Ok :). Not problem. – Anish B. Feb 13 '21 at 11:13

Getting java.lang.ClassNotFoundException: com.mysql.jdbc.Driver after deploying to jar

2 Answers2