Extended error info - oracle JDBC driver
Posted on 2004-10-08
I am writing a simple Servlet that is being hosted on Apache Tomcat. I am using JDBC with the official Oracle Thin JDBC client driver to connect to an oracle 9i or greater database. Most of the time I use the standard JDBC classes, but the Oracle driver does provide some of its own extension classes (such as 'OracleResultSet').
Anyway, all i want to know is how to get the extended error information that oracle can return about SQL problems. For example, before this application, i was using perl with the DBI module. Whenever I got an SQL error, I could dump the entire SQL with the location of the problem highlighted with <*>. (this was all done automatically). So far with JDBC, I have only been able to get a simple 1-line error message such as "ORA-XXXX: Inserted data is too large for field". Is there a way, using standard JDBC or the oracle extensions, to get extended error information such as what I described above??