Обсуждение: Please help! - Constraints Exception
Hello all, I am new to pgsql-JDBC and I apologize if this is a trivial question but I can not hack it! I have a table with UNIQUE constraint on the column. Inserting 2 of same values on it fails (as it should) and I can see DBLog Error message. Alas, there is no exception thrown from JDBC so that I can properly handle it. Any hints are appreciated! Config -------- postgresql 8.3 JDBC3 (8.3-604) database is accessed through the network
Sorry, I missed the "no exception thrown" part. How exactly do you issue the query? Can you give a code example?
On Wed, Jun 17, 2009 at 9:57 PM, Ivan Bojer<ibojer@gmail.com> wrote: > I have a table with UNIQUE constraint on the column. Inserting 2 of > same values on it fails (as it should) > and I can see DBLog Error message. Alas, there is no exception thrown > from JDBC so that I can properly > handle it. This is from memory, so if I talk nonsense, I hope somebody corrects me. The exception thrown should be a SQLException. These have a "getSQLState" method which returns a string. If this string is "23505", you have a UNIQUE violation. You can see the possible error codes here: http://www.postgresql.org/docs/8.3/static/errcodes-appendix.html
FYI I figured what was the problem. The database log level was changed to FATAL from ERROR (default?). On Wed, Jun 17, 2009 at 1:04 PM, Dennis Brakhane<brakhane@googlemail.com> wrote: > On Wed, Jun 17, 2009 at 9:57 PM, Ivan Bojer<ibojer@gmail.com> wrote: >> I have a table with UNIQUE constraint on the column. Inserting 2 of >> same values on it fails (as it should) >> and I can see DBLog Error message. Alas, there is no exception thrown >> from JDBC so that I can properly >> handle it. > > This is from memory, so if I talk nonsense, I hope somebody corrects me. > > The exception thrown should be a SQLException. These have a > "getSQLState" method which returns a string. If this string is > "23505", you have a UNIQUE violation. > > You can see the possible error codes here: > > http://www.postgresql.org/docs/8.3/static/errcodes-appendix.html >