On Wed, Apr 21, 2004 at 09:21:28AM +0200, Thomas Lange wrote: : I'm implementing a chat application, which sends all the chatting : output for each user in just one long query (servlet), which last : for the entire chatting session. : : On leaving the chatroom, the client simply closes the connection, : thus makeing the query fail, leaving the processor in an error state.
If the chat data is being stored in a session object, you could wrap this up in a SessionListener: . one member var (StringBuffer) holds the chat info . when the session expires, call a PreparedStatement that inserts the StringBuffer's contents This way, the data is comitted to the DB even if the user just closes the window: sooner or later, the session will expire, the listener will be triggered, and the data is stored. -or did I misunderstand your question? -QM -- software -- http://www.brandxdev.net tech news -- http://www.RoarNetworX.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]