alternative solution for saving path to database using java

Question

I'm working on a java application that create and store invoice in pdf. I create a new folder for every new year an every new month I stored it as follow:

 private void CreateDir () {

    Calendar now = Calendar.getInstance();
    int year = now.get(Calendar.YEAR);
    String yearInString = String.valueOf(year);


    int month = now.get(Calendar.MONTH) +1;
    String monthInYear = String.valueOf(month);


    File rootDir = File.listRoots()[0];
    File dir = new File(new File(new File(rootDir, "MijnFacturen"), yearInString), monthInYear);
    if (!dir.exists()){
        dir.mkdirs();
        System.out.println("directories made");
        setInvoicePath(dir.toString());
        System.out.println(invoicePath);
    } else {
        setInvoicePath(dir.toString());
        System.out.println(invoicePath);
    }

}

So for so good. But when i save the path to mysql database it automatically removes the backslashes from my string. I read that it was a bad practical to save paths in a database. But where should i save my pathfile then. And whats the best way to retrieve it ??

Kayaman · Accepted Answer · 2015-04-15 13:52:05Z

1

Why not save the invoices directly into the database as BLOBs? It'll be a lot more convenient and you can query them easily by any metadata (dates, total values, etc.) that you store with them.

answered Apr 15, 2015 at 13:52

Kayaman

73.8k6 gold badges91 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Greg Over a year ago

Can you give my a quick explanations how blobs work. We only have seen some lessons of sql and never talk about blobs ? Do you now any good websites with some examples ?

Kayaman Over a year ago

It's a binary column in the database. Essentially the same as if you'd store it in file yourself, except more robust and you don't need to worry about paths. Plenty of tutorials and info available at your favourite search engine.

Collectives™ on Stack Overflow

alternative solution for saving path to database using java

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related