After a rowInserted() event!
Hi folks, I have the Derby Network Server allowing database access to two network clients. One of the network clients adds a new record to the database. My question is: "How does the other client get told that a new record has been added?" There must be some mechanism for this! You can't implement any kind of useful system without it. I know I could write a trigger using SQL but how would this tell the other client of the new record that's just been added? Any help at all would be most welcome! Thanks in advance, Mark.
Ideally, what I'm after is the Derby Network Server doing something like firing a rowInserted() method or event in the Derby Network Client. It seems to me that this must be possible. It's how it would work if I'd designed it. I just can't find such a mechanism anywhere! This is driving me nuts. Please, if anybody can even hint to me where to look they will have my eternal thanks!
Re: After a rowInserted() event!
Not sure about the client/server relationship here, but I presume the clients are remote? You may then have to have the server open up a socket and have clients listen on that socket. When an update occurs, the server notifies all clients listening on that socket.