public VentaDia getVenta() {

        Connection connection = null;
        Statement  stmt       = null;
        ResultSet  rs         = null;

        try {
            connection = pool.getConnection();
            stmt       = connection.createStatement();
            rs         = stmt.executeQuery("select curdate() as hoy, sum(total) as total from omoikane.ventas where fecha_hora between curdate() and DATE_ADD(curdate(), INTERVAL 1 DAY)");

            rs.next();

            Long idSucursal   = dataSourceConfig.idSucursal;
            Date fecha        = rs.getDate("hoy");
            BigDecimal total  = rs.getBigDecimal("total");
            total             = total != null ? total : new BigDecimal("0");

            return new VentaDia(idSucursal, fecha, total);
        } catch (Exception e) {
            Logger.getLogger(ExtractorOmoikane.class).error("Error extrayendo ventas de omoikane", e);
        } finally {
            try {
                if(rs         != null) rs.close();
                if(stmt       != null) stmt.close();
                if(connection != null) connection.close();
            } catch (SQLException e) {
                Logger.getLogger(ExtractorOmoikane.class).error("Error al cerrar conexiones", e);
            }
        }

        return null;
    }