Hi all, I have an architecture problem, and maybe someone finds the time to read this and to give me a hint. The environment is ND 4 on NT and MS SQL Server. I have a project which contains java pages. These client side pages needs to be notified when certain data in the database changes. I solved this in the following way: I have triggers defined on the tables in question which write the current time to a special time stamp table. When loaded, each ClientSideLoader starts a thread wich reads the timestamp table in certain intervals and, if it finds a time stamp newer than in the previous run, it creates an event which triggers the appropriate actions on the applet page (or java frames or whatever). This architecture works, but it has three severe intrinsic problems. The first one is, there is always a delay between the database update and the time the applet can react to it given by the time cycle of the thread. The second problem is that every client starts a thread, which of course runs on the client, but this creates a lot of load on the database, especially when there are many clients accessing the application. The third problem is that I have to monitor the thread and to restart it in case it dies. To solve all those problems, it would be most convenient if I could write some code on the server which invokes the event handlers on the client side java pages directly. I did some experimenting with the RMI API but I finally gave up because I could not create a RMI server on the client due to security restrictions. Is there any way to use NetDynamics for this? Any ideas are highly appreciated. Thanks Axel _________________________________________________________________________ For help in using, subscribing, and unsubscribing to the discussion forums, please go to: http://www.netdynamics.com/support/visitdevfor.html For dire need help, email: [EMAIL PROTECTED]
