getting class not found exception for com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

Question

I'm writing JDBC code in which I have this import:

import com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException;

While executing I'm getting:

java.lang.ClassNotFoundException: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

Though I have already added the mysql.jar in class path. Any solution for this? Do I have to add any other jar file for this class?

Since your code compiled, the class obviously existed in the classpath at compile-time. It would seem that you didn't include the .jar file in the classpath at runtime. — Andreas
– Andreas, Commented Jul 31, 2017 at 20:11

Krunal · Accepted Answer · 2020-08-04 11:11:59Z

2

I found this error while upgrading my JDBC connection JAR file to mysql-connector-java-8.0.21.jar

And realised that package name is changed from com.mysql.jdbc.exceptions.* to java.sql.*

May be this will help you, if you replace

import com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException;

with

import java.sql.SQLIntegrityConstraintViolationException

May this help you to understand, if you have the similar issue: JAVA: cannot find symbol PreparedStatement (JAR Upgrade)

answered Aug 4, 2020 at 11:11

Krunal

79.9k49 gold badges255 silver badges268 bronze badges

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

Comments

Mark Rotteveel · Accepted Answer · 2017-07-31 21:32:51Z

-1

"java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" is NOT a compilation error. The solution is to make sure that the JAR file is on the classpath when you run the application.

If you're using Eclipse, follow below points

Right click your project folder and open up Properties.
From the right panel, select Java Build Path then go to Libraries tab.
Select Add External JARs to import the mysql driver.
From the right panel, select Deployment Assembly.
Select Add..., then select Java Build Path Entries and click Next.
You should see the sql driver on the list. Select it and click first.

edited Jul 31, 2017 at 21:32

Mark Rotteveel

110k241 gold badges160 silver badges233 bronze badges

answered Jul 31, 2017 at 20:47

NS009

111 gold badge2 silver badges6 bronze badges

1 Comment

Mark Rotteveel Over a year ago

This doesn't address the problem of the question, or at least, "java.lang.ClassNotFoundException: com.mysql.jdbc.Driver" is NOT a compilation error indicates you haven't tailored your answer to the actual question.

Collectives™ on Stack Overflow

getting class not found exception for com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related