Mitsubishi Electric Melsec Q Series User Manual page 148

6
FUNCTIONS
(2) Factors for starting DB buffering
(3) Processing for which the DB buffering is available
6
- 15 6.1 DB Interface Function
6.1.10 DB buffering function
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
Table 6.1 Processing for which the DB buffering is available
Update/Insert/Delete
Stored procedure
(Not available when using return values, output arguments, or input/output arguments.)
Select/MultiSelect
Program execution
Processing DB buffering
Available
N/A