CONTROLLER, INFORMATION PROCESSING APPARATUS, AND RECORDING MEDIUM

• US 20140236997A1
• Filed: 11/25/2013
• Published: 08/21/2014
• Est. Priority Date: 02/15/2013
• Status: Active Grant

• Current Assignee: Omron Corporation
• Original Assignee: Omron Corporation
• Inventors: NISHIYAMA, Yoshihide, YAOITA, Koji, OKAMURA, Kotaro, OTA, Masanori, NAKASAKI, Masaru
• Granted Patent: US 9,984,244 B2
• Time in Patent Office: Days
• US Class Current: 707/781
• CPC Class Codes: G06F 11/3664 Environments for testing or debugging software
• CPC Class Codes: G06F 11/3684 for test design, e.g. generating new test cases
• CPC Class Codes: G06F 21/6218 to a system of files or objects, e.g. local or distributed file system or database

Abstract

A technique for facilitating debugging in a user program which operates by cooperation of a PLC and another system in a control system including a controller and another system. A CPU unit has a communication interface, executes a user program, calls DB connection service in accordance with an instruction included in the user program, and generates a statement to access a database device. In the DB connection service, operation is performed while switching a first mode and a second mode. In the first mode, a statement according to an access instruction is generated, the generated statement is transmitted to a database system, and a result of a response is sent to the user program. In the second mode, without transmitting the statement to the database device, a result of execution corresponding to the statement is sent to the user program.

Claims

1. A controller comprising:

a communication interface configured to be connected to a database system;

an instruction executing unit configured to execute a user program for controlling a control object; and

an access processing unit, at the time of executing the user program including an access instruction to access the database system by the instruction executing unit, configured to control an access to the database system via the communication interface by a statement according to the access instruction, wherein

the access processing unit operates in a first mode and a second mode,

in the first mode, transmits a statement according to the access instruction to the database system and sends a result of response of the statement to the user program, and

in the second mode, sends an execution result corresponding to the statement to the user program without transmitting the statement to the database system.

2. The controller according to claim 1, further comprising a counting unit configured to count time, wherein

at the time of executing a predetermined process in the user program, the instruction executing unit stores into a memory the process and time counted by the counting unit in association with each other, as a log, and

the access processing unit stores into the memory a process according to the access instruction and time counted by the counting unit in association with each other, as the log.

3. The controller according to claim 2, wherein the access processing unit generates a statement according to the access instruction and stores the generated statement as the log into the memory.

4. The controller according to claim 1, wherein in the second mode, the access processing unit transmits to the user program, as an execution result corresponding to the statement according to the access instruction, a response indicating that an access to the database system according to the statement is normally performed or a response indicative of occurrence of an error in an access to the database system according to the statement.

5. The controller according to claim 1, wherein a control unit comprises a response time setting unit configured to accept a setting of response time and,

in the case of operating in the second mode, outputs a result of a process according to the access instruction after lapse of the set response time since start of the process.

6. The controller according to claim 1, further comprising an input/output unit configured to transmit/receive data to/from an information processing apparatus connected to the controller, wherein

the input/output unit outputs a result of a response to the user program by the access processing unit to the information processing apparatus in response to a request of the information processing apparatus.

7. The controller according to claim 6, wherein the input/output unit accepts a designation of either the first mode or the second mode in which the access processing unit is to be operated from the information processing apparatus, and

the access processing unit switches either the first or second mode in accordance with the designation accepted from the information processing apparatus.

8. The controller according to claim 1, wherein the user program includes a designation instruction of instructing either the first mode or the second mode in which the access processing unit is to be operated, and

the access processing unit operates in either the first mode or the second mode in accordance with the designation indicated by the designation instruction.

12. The controller according to claim 2, further comprising an input/output unit configured to transmit/receive data to/from an information processing apparatus connected to the controller, wherein

the input/output unit outputs a result of a response to the user program by the access processing unit to the information processing apparatus in response to a request of the information processing apparatus.

13. The controller according to claim 3, further comprising an input/output unit configured to transmit/receive data to/from an information processing apparatus connected to the controller, wherein

the input/output unit outputs a result of a response to the user program by the access processing unit to the information processing apparatus in response to a request of the information processing apparatus.

14. The controller according to claim 4, further comprising an input/output unit configured to transmit/receive data to/from an information processing apparatus connected to the controller, wherein

the input/output unit outputs a result of a response to the user program by the access processing unit to the information processing apparatus in response to a request of the information processing apparatus.

15. The controller according to claim 5, further comprising an input/output unit configured to transmit/receive data to/from an information processing apparatus connected to the controller, wherein

the input/output unit outputs a result of a response to the user program by the access processing unit to the information processing apparatus in response to a request of the information processing apparatus.

9. A computer-readable recording medium storing a computer program executable by a processor and configured to control operation of a controller, wherein

the controller comprises a communication interface configured to access a database system, the processor, and a memory, and

the program causes the processor to execute:

a step of executing a user program to control a control object; and

a step of, at the time of executing the user program including an access instruction to access the database system, controlling an access to the database system via the communication interface by a statement according to the access instruction,

a step of controlling an access to the database system by the statement according to the access instruction is performed in the first and second modes, and the program causes the processor to perform a step of

in the first mode, transmitting a statement according to the access instruction to the database system and sending the result of response of the statement to the user program, and

in the second mode, sending the result of execution corresponding to the statement to the user program without transmitting the statement to the database system.

10. An information processing apparatus to be connected to a controller, wherein

the controller comprises:

a communication interface configured to be connected to a database system;

an instruction executing unit configured to execute a user program for controlling a control object;

an access processing unit, at the time of executing the user program including an access instruction for accessing the database system by the instruction executing unit, configured to control an access via the communication interface to the database system by a statement according to the access instruction; and

an input/output unit configured to be connected to the information processing apparatus and to transmit/receive data to/from the information processing apparatus,

the access processing unit operates in a first mode and a second mode,

in the first mode, transmits a statement according to the access instruction to the database system and sends a result of a response to the statement to the user program, and

in the second mode, sends a result of execution corresponding to the statement to the user program without transmitting the statement to the database system, and

the information processing unit comprises;

a reception processing unit configured to receive a result of a response to the user program by the access processing unit via the input/output unit of the controller; and

a display processing unit configured to display the response result received by the reception processing unit on a monitor.

11. A controller comprising:

a communication interface configured to be connected to a database system;

a processor; and

a memory, wherein

the processor is configured to operate while switching a first mode and a second mode, executes a user program for controlling a control object, at the time of the execution of the user program including an access instruction to access the database system, controls an access via the communication interface to the database system by a statement according to the access instruction, in the case of operation in the first mode, transmits the statement according to the access instruction to the database system, sends a result of response to the statement to the user program, in the case of operation in the second mode, sends a result of execution corresponding to the statement to the user program without transmitting the statement to the database system.