com = con.prepareStatement("select sum(messagecount), sum(consumercount), sum(recievedmessagecount), sum(activeconsumercount), " + "sum(queuedepth), sum(messagedropcount), sum(bytesdropcount), sum(bytesin), sum(bytesout) from brokerrawdata where host=?"); com.setString(1, res.getBrokerList().get(i).getUri()); rs = com.executeQuery(); if (rs.next()) { com.setString(1, res.getBrokerList().get(i).getUri()); rs = com.executeQuery(); if (rs.next()) { try { com = con.prepareStatement("SELECT utcdatetime, status FROM status where uri=?;"); com.setString(1, res.getBrokerList().get(i).getUri()); rs = com.executeQuery(); if (rs.next()) {