Обсуждение: Error codes in SQLException
Hi list, I was just wondering if there is a overview somewhere with the integer values returned by SQLException when calling getErrorCode(). Thanks! Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230
Στις Τρίτη 30 Οκτώβριος 2007 12:06, ο/η Christian Rengstl έγραψε: > Hi list, > > I was just wondering if there is a overview somewhere with the integer > values returned by SQLException when calling getErrorCode(). Browsing at the sources of 7.4.12 (dont shout please!! i know we must upgrade in the future), i dont see any reference to getErrorCode() in PSQLException. The right way however is to use the standardized getSQLState() according to http://www.postgresql.org/docs/7.4/interactive/errcodes-appendix.html > Thanks! > > > > Christian Rengstl M.A. > Klinik und Poliklinik für Innere Medizin II > Kardiologie - Forschung > Universitätsklinikum Regensburg > B3 1.388 > Franz-Josef-Strauss-Allee 11 > 93053 Regensburg > Tel.: +49-941-944-7230 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Achilleas Mantzios
Christian Rengstl wrote: > I was just wondering if there is a overview somewhere with the integer > values returned by SQLException when calling getErrorCode(). getErrorCode() will return a vendor specific code; this is the third argument in the three-argument constructor of java.sql.SQLException. As far as I can see this constructor is never used in PostgreSQL, so I would say that getErrorCode() will always return 0. This makes sense since PostgreSQL uses no vendor specific error codes, but the (supposedly fairly standardized) SQLSTATEs (see http://www.postgresql.org/docs/current/static/errcodes-appendix.html). You can get those with getSQLState(). Yours, Laurenz Albe