Execute SQL script file with java

Question

I have a file called scripts.sql which contains a huge amount of sql queries, here is the first few lines of the file:

alter table companies change ...... ;
insert into addresses values (.....);
update users set blabla = 'blabla'......;

I want to know if in some way I can execute all the queries in this file with java.

I am using MySQL database.

Read file line by line and execute it. Only if you are sure queries wrote in single line. — Vicky Thakor, Dec 20 '13 at 12:42
I would look at something like http://flywaydb.org/. Not only will it run your DB scripts it will also keep track of which scripts have already been run. — Ben Thurley, Dec 20 '13 at 12:56

score 0 · Answer 1 · edited May 23 '17 at 12:11

0

You can use Ibatis runner to execute a sql script file. It's explained here Running SQL files scripts from a Java program

I hope this wil help

edited May 23 '17 at 12:11

Community

answered Dec 20 '13 at 12:50

Pracede

1 Answers1