About: Error Recovery

Not logged in : Login

(Sponging disallowed)

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Error Recovery Goto Sponge NotDistinct Permalink

An Entity of Type : foaf:Document, within Data Space : linkeddata.uriburner.com:28898 associated with source document(s)

Attributes	Values
type	Document
Title	Error Recovery
content	Preliminaries When processing some form data in VSPs, there may be errors in the PL code (for example due to deadlock condition). The most popular way of catching the SQL errors is to declare an exception handler. declare error varchar; error := null; declare exit handler for sqlstate '*', not found result { error := __SQL_MESSAGE; }; { -- some operation(s) that may cause a SQL error } if (error is not null) -- print the error message To simplify VSP production, the error handler can be written in a common file and included in each page. The external file can be included using the following markup: <?include path_to_the_external_file.extension ?> Deadlock Example The first example demonstrates the creation of a universal deadlock handler. If this file is included in any VSP the deadlock condition will cause a retry up to 3 times on an operation that follows the handler. The VSP simulates the deadlock situation by signalling the error. The error handler is therefore called. Calculator with error handler The second example is the vs_b_3 Calculator example. In this example there is an added handler to trap errors such as division by zero, and entering characters instead of numbers.
has container	http://demo.openlinksw.com/tutorial/web
description	Error handling in VSPs
dcterms:created_at	Fri, 27 Dec 2019 14:12:54 GMT
content:encoded	Preliminaries When processing some form data in VSPs, there may be errors in the PL code (for example due to deadlock condition). The most popular way of catching the SQL errors is to declare an exception handler. declare error varchar; error := null; declare exit handler for sqlstate '*', not found result { error := __SQL_MESSAGE; }; { -- some operation(s) that may cause a SQL error } if (error is not null) -- print the error message To simplify VSP production, the error handler can be written in a common file and included in each page. The external file can be included using the following markup: <?include path_to_the_external_file.extension ?> Deadlock Example The first example demonstrates the creation of a universal deadlock handler. If this file is included in any VSP the deadlock condition will cause a retry up to 3 times on an operation that follows the handler. The VSP simulates the deadlock situation by signalling the error. The error handler is therefore called. Calculator with error handler The second example is the vs_b_3 Calculator example. In this example there is an added handler to trap errors such as division by zero, and entering characters instead of numbers.
is container of of	http://demo.openlinksw.com/tutorial/web

Faceted Search & Find service v1.17_git144 as of Jul 26 2024

Alternative Linked Data Documents: iSPARQL | ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 08.03.3331 as of Aug 25 2024, on Linux (x86_64-ubuntu_noble-linux-glibc2.38-64), Single-Server Edition (378 GB total memory, 37 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software