![]() ![]() If the procedure implementation relies on the fact that all rows that it returns must be fetched, the logic will be broken. It is also allowed to use the EXECUTE PROCEDURE statement, however that might produce strange results, since for selectable procedures it is equivalent to executing a SELECT statement, but doing only one fetch after the select. Selectable procedures are executed using the "SELECT * FROM myProcedure(…)" SQL statement. These are stored procedures that contain the RETURNS keyword in their header and the SUSPEND keyword in their procedure body, usually within a loop. ![]() Procedures that return a result set, also called “selectable stored procedures”. These procedures are executed by using the EXECUTE PROCEDURE statement. These procedures can be viewed as functions that return multiple values. These are stored procedures that contain the RETURNS keyword in their header, but do not contain the SUSPEND keyword in their procedure body. Procedures that return only a single row of results. These are stored procedures that do not contain the RETURNS keyword in their header. Procedures that do not return any results. Jaybird has a few subclasses that might be interesting to the Subclasses of are thrown by the JDBC layer. XAException can wrap the GDSException, which are extracted duringĮxception conversion to preserve the error code. ResourceException was caused by an error condition not related to anĮrror returned by the database engine, error code of the SQLException The ResourceException was caused by the GDSException, latter isĮxtracted during conversion preserving the error code. Upper layerĬonverts this exception into a subclass of. Layer when an error happens in the JCA-related code. Upper layers eitherĬonvert these exceptions into the ones appropriate to that layer orĬatch them if driver can handle the error condition. This class are thrown by the GDS implementations. is an exception that directlyĬorresponding to the error returned by the database engine. thrown when the action might succeed if it is thrown when an action might be retriedīy taking recovery actions and restarting the transaction. 圎rrorException - thrown for syntax errors. That will not succeed on retry without fixing the underlying cause. 圜onstraintViolationException - thrown for constraint JDBC feature is not supported by the driver or the data source (Firebird). thrown for data-related errors,įor example conversion errors, too long values. Appendix E: Supported JDBC Scalar Functions.Mapping between JDBC, Firebird and Java Types ![]() Appendix A: Extended connection properties.Connection property serverBatchBufferSize Table statistics of a connection (experimental) ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |