Add and use files in JAVA Jar as they would be in the folder

Question

I have JAVA project which contains some *.sql files and on deploy if there is no database cleated yet I can run some classes which applies those *.sql files on database. But I have to make JAVA Jar file out of it in order to deploy. I do know how to run any class from jar, but how to add and access my *.sql in the Jar if I do not want extract the files.

The *sql files that I need is being used the following way:

mysql -uroot -ppassword < databaseStructure.sql

that creates me database. somehow I need access that file out of jar when necessary.

score 0 · Answer 1 · edited May 23 '17 at 10:27

0

You can get an InputStream from files in your classpath. I'm not sure if that does what you need, exactly.

See this previous SO article on the topic: Different ways of loading a file as an InputStream

edited May 23 '17 at 10:27

Community

1
1

answered Feb 07 '14 at 13:21

matthudson

182
6

Alexander_Winter · Accepted Answer · 2014-02-07T13:29:08.477

0

InputStream stream = YourClass.class.getResourceAsStream("/" + pathToYourFile);

Example:

You have a file insertSomething.sql in your jar.

public static String getResourceContent(
  final String path) throws IOException {
        InputStream stream = YourClass.class.getResourceAsStream("/" + path);
        if (stream != null) {
               return IOUtils.toString(stream);
        } 
    }

Now you can get the content:

String content = getResourceContent("insertSomething.sql");

edited Feb 07 '14 at 13:29

answered Feb 07 '14 at 13:23

Alexander_Winter

314
1
3
9

1

You can use `IOUtils.toString(InputStream)` to simplify this method. – Grzegorz Gajos Feb 07 '14 at 13:26
Oh thank you, didn't saw the toString-function. I edited my answer. – Alexander_Winter Feb 07 '14 at 13:27
You welcome. I think that name of this function is misleading, they could use something like `readToString` instead. It would be easier to run into. – Grzegorz Gajos Feb 07 '14 at 13:31
why do we need the "/" ? – Ingo Feb 07 '14 at 13:33
I had problems in an older version of this function where it wouldn't find the files if I don't put the '/' in front of the filepath. It should work without it. – Alexander_Winter Feb 07 '14 at 13:38

Add and use files in JAVA Jar as they would be in the folder

2 Answers2