What is User-Defined SQLExceptions ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is User-Defined SQLExceptions ?

When the execution of a database-side method raises an error, Derby wraps that exception in an SQLException with an SQLState of 38000. You can avoid having Derby wrap the exception if:

* the exception is an SQLException
* the range of the SQLState is 38001-38999
(This conforms to the SQL99 standard.)

(Continued on next question...)

Other Job Interview Questions

• How to create Jar Files for Your Application?
• Explain about Embedded Derby JDBC Driver
• How does Holdable Cursors work?
• How to Sign Jar Files
• Database-Side JDBC Procedures Using Non-Nested Connections
• Extended Updatable Cursor Example
• Examples: How to create new databases and access existing ones ?
• Pitfalls of Sharing a Connection Among Threads
• Holdable Cursors and Autocommit
• What is a Derby Database Pages?
• More...