In particular, when you use the LiveWire Database Service to interact with a relational database, errors can occur for a variety of reasons. For example, SQL statements can fail because of referential integrity constraints, lack of user privileges, record or table locking in a multiuser database, and so on. When an action fails, the database server returns an error message indicating the reason for failure. Your code should check for error conditions and handle them appropriately. The return value of the methods of the LiveWire objects may indicate whether or not an error occurred.
Methods can return values of various types.
Depending on the type, you can infer different information about possible errors. When a method returns a number, the return value can either represent an actual numeric value or a status code. For example, Cursor.columns returns the number of columns in a cursor, but Cursor.updateRow returns a number indicating whether or not an error occurred. The Cursor.columns and Resultset.columns methods return an actual numeric value. Connection.execute Connection.majorErrorCode Connection.minorErrorCode Connection.release Connection.rollbackTransaction Connection.