Open file from singleton

Question

I'm trying to read a excel file in a singleton so it is loaded only once. The excel file and the singleton are in the same package but getResourceAsStream returns null.

What could I be missing ?

public static synchronized HSSFWorkbook getUniqueInstance(String fileStr) {

    if (sInstance == null) {
        try {
            InputStream file = WBSingleton.class.getResourceAsStream(fileStr);
            sInstance = new HSSFWorkbook(file);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

    return sInstance;

}

this is not singleton. HSSFWorkbook can have many instances outside your class. — Adi, Sep 07 '14 at 18:02

Tkachuk_Evgen · Answer 1 · 2014-09-07T18:27:34.930

0

Try this

WBSingleton.class.getClassLoader().getResourceAsStream(fileStr);

You can also try

URL url = getClass().getResource(fileStr); 
InputStream name = url.openStream();

edited Sep 07 '14 at 18:27

answered Sep 07 '14 at 18:12

Tkachuk_Evgen

1,334
11
17

returns null as well – JDavid Sep 07 '14 at 18:19

Open file from singleton

1 Answers1