Getting programmatical access to the PostgreSQL exception

Question

I have the following problem. I am inserting data to Postgres database through my javafx interface.

When i import some data to my database, sometimes primary key is violated and I am getting the following stack error:

 catch(PSQLException e){

       System.out.println(e.getLocalizedMessage());
}


 duplicate key value violates unique constraint "importedDocumentPK"
 Detail: Key (part_id, supplier_id, temp_id, qty, color, sign_id, state_id)=(41A213752P9, 750, 7049, 48, 5, 1, 1) already exists.

My question is. How can I save information about this row (41A213752P9, 750, 7049, 48, 5, 1, 1) in my program?

Magnus Hagander · Accepted Answer · 2013-08-16 10:01:37Z

1

This information is only available as a text string in the error message in current versions of PostgreSQL. However, the upcoming 9.3 release will expose this as more detailed fields, see http://www.postgresql.org/docs/9.3/static/libpq-exec.html#LIBPQ-PQRESULTERRORFIELD for details. I would assume the JDBC driver will expose the same fields as well, though I'm not sure if they've defined the interface yet.

answered Aug 16, 2013 at 10:01

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Getting programmatical access to the PostgreSQL exception

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related