I've got a database during my sql and that i have multiple clients by using their database. each time a column within the database is up-to-date I wish to call the related java method around the client side. Essentially this is actually the message system, when user get new message I wish to provide him a notification. Is the proper way to get it done? If so how do you implement it. Otherwise an amount be the proper way to get it done?

Any help appreciated

Thanks

No, this isn't the proper way to get it done. To transmit messages, use message-oriented middleware (Mother), using JMS. You will find free JMS implementations available (like ActiveMQ, for instance).

You will find texting frameworks for such reason for instance :

  • Jabber
  • UDP multicast (http://download.oracle.com/javase/1.4.2/paperwork/api/java/internet/MulticastSocket.html)
  • JMS (http://activemq.apache.org/)

You will probably find interesting the next blog publish and thread: http://www.unlimitednovelty.com/2009/04/twitter-blaming-ruby-for-their-mistakes.html

Your blog was written when Twitter has transformed its texting system platform from Ruby to Scala. It produced an ineteresting flame about texting systems between experts...