Recently, doing a C/S projects, opc client, after the modification of the oracle table data server needs to be issued to the PLC data, there are two solutions:
1, through the oracle's trigger notification service side, so, need to call an external application oracle,
2, the server-side programs written communications, timing scan data table, found a changes, method call issued by such not timely, and spending big,
Is there a better way? Please expert advice,

CodePudding user response:

Simple point socket communication, is a notification process, many ways,

CodePudding user response:

I can't think of another way, the service side as passive, to do timely response, if it weren't for the client to add deletion operation clockwork news server: old clothes ah, oh, I'm change which form the service side can know database has been changed in time, and then react accordingly, if like what you said to inform by the database server,

CodePudding user response:

External program if you don't want to do, you are in the original client changes, such as the client changed the server oracle table, if successfully changed, you can send to the PLC

CodePudding user response:

TCP protocol can or something the COM,