Question 110062 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Json – Not able to delete the file, Getting exception as File is used by another process

Can someone please help me out that how to delete the file, below is the code using to convert the JSON file to Excel file, but after conversion am unable to delete the JSON file in the respective path.Getting exception saying that "java.nio.file.FileSystemException: .Json_filesdb-AAPL.json: The process cannot access the file because it is being used by another process
"

public class DB_Search_API {

String stockname;
public static XSSFWorkbook wb;
public static XSSFSheet s;
public static FileInputStream fi;
public static FileOutputStream fo;
public static Row r;
public static Row r1;
public static Cell c;

@Test
public void FinBlock() throws Exception {
    int lastRow = dataXl.getRowCount("Sheet1");
    ////
    LocalDateTime date = LocalDateTime.now();

    DateTimeFormatter dateFormat = DateTimeFormatter.ofPattern("dd-MM-yyyy");
    String formattedDate = date.format(dateFormat);

    DateTimeFormatter dateformat = DateTimeFormatter.ofPattern("dd-MM-yyyy HH-mm");
    String formatedate = date.format(dateformat);

    Path dir = Paths.get(".//Output_Files//DB_Excelfiles-" + formattedDate);
    Files.createDirectories(dir);
    wb = new XSSFWorkbook();
     

    //////

    for (int i = 2; i <= lastRow; i++) {
        stockname = dataXl.getCellData("Sheet1", "Stock name", i);
        String USERNAME = CONFIG.getProperty("Username");
        String Password = CONFIG.getProperty("password");
        String URI = CONFIG.getProperty("API");
        SessionFilter session = new SessionFilter();
        RestAssured.baseURI = URI;

        String Response = given().auth().preemptive().basic(USERNAME, Password).filter(session).when()
                .get(RestAssured.baseURI).then().extract().response().getCookie("RAY_SESSION_ID");

        Response resp = given().cookie("RAY_SESSION_ID", Response).filter(session).when()
                .get("******"
                        + stockname
                        + "*****")
                .then().log().all().extract().response();
         
        PrintWriter out = new PrintWriter(new FileWriter(".//Json_files//db-" + stockname + ".json", true), true);
        out.write(resp.asString());
        out.close();

        JSONParser parser = new JSONParser();

        Object obj = parser.parse(new FileReader(".//Json_files//db-" + stockname + ".json"));
        JSONObject jsonObj = (JSONObject) obj;
        JSONObject response = (JSONObject) jsonObj.get("response");
        JSONObject arraybody = (JSONObject) response.get("data");
        JSONArray arrayindex = (JSONArray) arraybody.get("arrayRowData");

        int n = arrayindex.size();

        s = wb.createSheet(stockname);

        for (int j = 0; j < n; j++) {
            JSONObject jsonObject = new JSONObject((Map) arrayindex.get(j));
            JSONObject jsonObject1 = (JSONObject) jsonObject.get("header");
            String value = (String) jsonObject1.get("displayName");
            s.createRow(j + 1).createCell(0).setCellValue(value);
            JSONArray arrayindex1 = (JSONArray) jsonObject.get("cellData");

            int m = arrayindex1.size();
            int x = m - 1;
            r = s.getRow(j + 1);
            r1 = s.createRow(0);

            for (int k = 0; k <= x; k++) {
                JSONObject jsonObject12 = new JSONObject((Map) arrayindex1.get(k));
                String newdate = (String) jsonObject12.get("fiscalDate");
                r1.createCell(k + 1).setCellValue(newdate);

                if (jsonObject12.get("value") == null) {
                    r.createCell(k + 1).setCellValue("-");
                } else {
                    r.createCell(k + 1).setCellValue((double) jsonObject12.get("value"));
                }
            }
        }

        fo = new FileOutputStream(dir + "//DB_Search" + "-" + formatedate + ".xlsx");
        wb.write(fo);
        fo.flush();
        fo.close();

        try {

             Files.deleteIfExists(Paths.get(".//Json_files//db-" + stockname + ".json"));
             

        } catch (NoSuchFileException e) {
            System.out.println("No such file/directory exists");

        } catch (DirectoryNotEmptyException e) {
            System.out.println("Directory is not empty.");

        } 


    }

}

}

Tags:

2

Answers


  1. 0

    Your variable names are not descriptive, so that’s not good.

    Try to flush() the object that is reading the JSON and then close() it, that should do it.

    Login or Signup to reply.
  2. 0

    You do not close the FileReader. So instead of just creating a FileReader directly inside the method call parser.parse(..)., you should use a "try wih resources" (or at least close the reeader after reading the content).

    So instead of:

    Object obj = parser.parse(new FileReader(".//Json_files//db-" + stockname + ".json"));

    You have code like:

    Object obj;
try (FileReader reader = new FileReader(".//Json_files//db-" + stockname + ".json")) {
    obj = parser.parse(reader);
}

    That way the reader is closed and the file is no longer in use.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search