public void processVmProcessData() { try { PreparedStatement pstmt = sqlConnection.prepareStatement(Queries.getSqlInsertVmCpuInfo()); AggregationOutput aggregationOutput = mongoTask.getAggregatedOutput("procinfo", Queries.getProcessInfoQuery()); for (DBObject obj : aggregationOutput.results()) { String hostname = (String) obj.get("_id"); double processes = Double.parseDouble(obj.get("processes").toString()); double threads = Double.parseDouble(obj.get("threads").toString()); pstmt.setTimestamp(1, new java.sql.Timestamp(timeStamp.getTime())); pstmt.setString(2, hostname); pstmt.setDouble(3, processes); pstmt.setDouble(4, threads); pstmt.setInt(5, 1); pstmt.addBatch(); } pstmt.executeBatch(); } catch (SQLException s) { s.printStackTrace(); } }