Java Mysql Integrity Constraint Violation Exception

Question

My Swing applications throws few exceptions. I tried to catch Integrity Constraint Violation Exception and display message "Duplicate ID". But when that happened, without catching it here: catch(MySQLIntegrityConstraintViolationException ex) it goes to catch (SQLException ex). What I want to do is, catch Integrity Violation exception and display user friendly message instead of technical message comes from ex.getMessage(). How do I do this?

              ShippmentTransfer shipTrns = new ShippmentTransfer(shipID, GIN, issueDate, ToStore, itemName, Qty, Driver, Vehicle);
                    int res = ShipmentTansController.addShipGIN(shipTrns);
                    if (res > 0) {
                          JOptionPane.showMessageDialog(null, "Record Added");
                          resetAll();
                    }
              } catch (DataIntegrityViolationException ex) {
                    JOptionPane.showMessageDialog(null, "Duplicate ID");

              } catch (ClassNotFoundException ex) {
                    JOptionPane.showMessageDialog(null, ex.getMessage());
              } 
              catch (SQLException ex) {
                    JOptionPane.showMessageDialog(null, ex.gets);
              }
        }

mhpreiman · Accepted Answer · 2021-11-03 10:33:14Z

3

In order to catch a specific SQLException, you need to compare against SQL state using getSQLState() method. Ex: SQL State 23 for Data Integrity violation.

catch (SQLException ex) {
    if (ex.getSQLState().startsWith("23")) {
        JOptionPane.showMessageDialog(null, "Duplicate");
    } 
}

Found from here

edited Nov 3, 2021 at 10:33

mhpreiman

1492 gold badges4 silver badges13 bronze badges

answered Apr 9, 2013 at 7:23

amal

3,62610 gold badges31 silver badges45 bronze badges

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

Comments

PSR · Accepted Answer · 2013-04-09 06:45:18Z

1

you can not use

MySQLIntegrityConstraintViolationException  directly.

Because no exception available in java with that name.

try this

try {

}
catch (DataIntegrityViolationException ex) {
    .....
}

and then get the error code using ex.Then compare it

edited Apr 9, 2013 at 6:45

answered Apr 9, 2013 at 6:15

PSR

40.4k43 gold badges115 silver badges154 bronze badges

7 Comments

amal Over a year ago

Thnx for your response. Then how do I catch the Integrity Constraint Violation Exception? Do you have any idea?

PSR Over a year ago

try to get the name of exception using ex.Then compare

PSR Over a year ago

try to debug ex when raised the exception.What it contains when IntegrityVoilationException raises and other raised.

amal Over a year ago

Sure. I ll try in that way.

amal Over a year ago

Finally managed to sort it out. I used method getSQLState() produces specific error code. Ex. 23 for Data Integrity violation. if(ex.getSQLState().startsWith("23")){ Anyway I appreciate your effort to help me.

|

JSBach · Accepted Answer · 2013-06-29 18:33:42Z

1

For those checking later, you might either choose to check instance type as:

try {
...
} catch (Exception e) {

    if (e instanceof SQLIntegrityConstraintViolationException) {
          // duplicate record or alike problem
    }
}

answered Jun 29, 2013 at 18:33

JSBach

4461 gold badge6 silver badges14 bronze badges

Collectives™ on Stack Overflow

Java Mysql Integrity Constraint Violation Exception

3 Answers 3

Comments

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related