hibernate: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException

Question

When saving an object to database using hibernate, it sometimes fails because of certain fields in the object exceeding the maximum varchar length defined in the database.

Therefore I am using the following approach:

Attempt to save
If getting an DataException, I then truncate the fields in the object to the max length specified in the db definition, then try to save again.

However, in the second save after truncation, I'm getting the following exception:

hibernate: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails

Here's the relevant code, do you notice anything wrong with it?

public static void saveLenientObject(Object obj){

    try {
        save2(rec);
    } catch (org.hibernate.exception.DataException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();


        saveLenientObject(rec, e);



    } catch (Exception e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }



}
private static void saveLenientObject(Object rec, DataException e) {
    Util.truncateObject(rec);
    System.out.println("after truncation ");
    save2(rec);

}
public static void save2(Object obj) throws Exception{
    try{
        beginTransaction();
        getSession().save(obj);

        commitTransaction();

    }catch(Exception e){
        e.printStackTrace();
        rollbackTransaction();
        //closeSession();
        throw e;
    }finally{
        closeSession(); 
    }
}

axtavt · Accepted Answer · 2012-09-16 09:48:51Z

1

All Hibernate exceptions (except for NonUniqueResultException) are irrecoverable. If you get an exception you should close the session and open another one for further operations.

See also:

13.2.3. Exception handling

answered Sep 16, 2012 at 9:48

axtavt

243k42 gold badges518 silver badges486 bronze badges

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

1 Comment

user121196 Over a year ago

but I did roll back and then close the session. and then open a new session.

EdC · Accepted Answer · 2012-09-16 09:52:26Z

0

The hibernate documentaiton is quite clear that once an exception is thrown the session will be left in an inconsistent state so is not safe to use for further operations. I suspect that what you're getting here is that the session is left half saving your first attempt so bad things happen.

Fundamentally you should not rely on database errors to check the length of your fields, instead you should pre-validate this in java code. If you know the lengths enough to truncate, then I suggest you simply call your trucate util every time.

Alternatively use Hibernate Validator to declaratively validate the objects before saving.

answered Sep 16, 2012 at 9:52

EdC

2,3491 gold badge17 silver badges33 bronze badges

Collectives™ on Stack Overflow

hibernate: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related