How to run sql script file using JDBI

Question

I am using jdbi to make connection to db and execute sql command.

dbi = new DBI("jdbc:mysql://"+dbHostName+"/"+dbName, "root", "");
    dbi.withHandle(new HandleCallback<Object>() {
        @Override
        public Object withHandle(Handle handle) throws Exception {
            handle.execute("Query to execute")
            return null;
        }
    });

Now i want to run sql file using jdbi. I googled a lot but couldn't figure out how.

Read here : docs.oracle.com/javase/tutorial/essential/io/file.html and replace "Query to execute"' by what you read. — StephaneM
– StephaneM, Commented Dec 23, 2015 at 14:16

Deinlandel · Accepted Answer · 2016-01-19 10:13:39Z

8

You should read your sql file to string and then execute it like

String script = ".. your sql file contents here ..";
try (Handle h = dbi.open()) {
    h.createScript(script).execute();
}

edited Jan 19, 2016 at 10:13

answered Jan 19, 2016 at 8:54

Deinlandel

1,0331 gold badge8 silver badges25 bronze badges

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

1 Comment

GACy20 Over a year ago

... this doesn't actually work. It interprets the SQL and sometimes it breaks. For example on Oracle it gives error if your SQL contains stuff like trigger definitions with multiple statements...

Collectives™ on Stack Overflow

How to run sql script file using JDBI

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related