public   void  JabberNotifyAll()  throws  SQLException {
        java.sql.Connection m_Conn;       
        Properties props =  new  Properties();
        props.put( "user", "***" );
        props.put( "password", "***" );
        String dbURL;
         try  {
             Class .forName("org.postgresql.Driver");
            dbURL = "jdbc:postgresql://127.0.0.1/fxflow2";
            m_Conn = DriverManager.getConnection( dbURL , props );
           
            XMPPConnection conn =  null ;
             try  {
                conn =  new  XMPPConnection("127.0.0.1");
                conn.login("jabberbot","jabberbot");
                PreparedStatement stmt = m_Conn.prepareStatement("SELECT * FROM v_il_notifications");
                ResultSet rs = stmt.executeQuery();
                 while  (rs.next()) {
                    String subject = rs.getString("subject");
                    String url = rs.getString("url");
                    String jabberuser = rs.getString("jabberuser");
                    String commenttext = rs.getString("commenttext");
                     try  {
                        Chat newchat = conn.createChat(jabberuser);
                        newchat.sendMessage("\n\n " + commenttext + "  " +subject + "\n" + url);
                    }  catch  (XMPPException ex) {
                        ex.printStackTrace();
                    }
                }
                rs.close();
                stmt.close();
                conn.close();
            }  catch  (XMPPException ex) {
                ex.printStackTrace();
            }
        }  catch  (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }
    
     protected   void  processRequest(HttpServletRequest request, HttpServletResponse response)
     throws  ServletException, IOException {
         try  {
            JabberNotifyAll();
        }  catch  (SQLException ex) {
            ex.printStackTrace();
        }
    }

                 try  {
                    Thread.sleep( 2000 );
                    conn.close();
                }  catch  (InterruptedException ex) {
                    ex.printStackTrace();
                }

    XMPPConnection connection =  new  XMPPConnection("jabber.org");
    connection.login("user", "password");
    Message message =  new  Message();
    message.setTo("tom@jabber.org");
    message.setSubject("Server down");
    message.setBody("The 'jupiter' server has just gone down");
    message.setType(Message.Type.HEADLINE);
    connection.sendPacket(message);
    connection.close();