Filter
Top Products
6
- 14
6.1 DB Interface Function
6.1.10 DB buffering function
6
FUNCTIONS
(2) Factors for starting DB buffering
DB buffering is conducted when SQL texts or stored procedure call information cannot
be sent to the database by any of the following causes, (a) or (b).
(a) Disconnection on the network, or failure of the database server computer
Upon detection of a connection timeout, DB buffering is started.
(7) DB buffering operation
Time for detecting connection timeout is set to 10 seconds by default.
Section 7.9.1 (8) Connection timeout (Range: 1 to 180 seconds, Default: 10
seconds)
Even if a trigger condition is met again during connection timeout detection, the
corresponding job is not executed.
Section 6.1.11 (1) Operation behavior of jobs
(b) Failure of the database software
Upon detection of DB access timeout, DB buffering is started.
(7) DB buffering operation
Time for detecting DB access timeout is set to 30 seconds by default.
Section 8.5 (2) DB access timeout (required) (Range: 1 to 3600, Default: 30)
Even if a trigger condition is met again during detection of DB access timeout, the
corresponding job is not executed.
Section 6.1.11 (1) Operation behavior of jobs
If an error occurs when the sent SQL text or stored procedure is executed on the
database, by some reason such as its incorrectness or inconsistency with the
database, buffering is not performed and an SQL failure log is output on the
database server computer.
Section 8.1 DB Connection Service Functions
(3) Processing for which the DB buffering is available
Table 6.1 Processing for which the DB buffering is available
Processing DB buffering
Update/Insert/Delete
Available
Stored procedure
(Not available when using return values, output arguments, or input/output arguments.)
Select/MultiSelect
N/A
Program execution