Execute Filename.sql file in Java using MyBatis

Question

I have a Filename.sql(Mysql Script) file which has multiple SQL Statements. I'm using MyBatis as persistence framework and MySQL as the database. I want to execute the Filename.sql file in a Java program.

NOTE: I don't want to execute the queries as separate SQL Statements.

This operation is equivalent to source Filename.sql in MySQL command prompt.

This post codeproject.com/Articles/802383/… and this mkyong.com/jdbc/how-to-run-a-mysql-script-using-java might help. But please show what you have tried. — Lucky
– Lucky, Commented Dec 10, 2015 at 8:21

Persia · Accepted Answer · 2016-01-04 08:40:46Z

4

you can use org.apache.ibatis.jdbc.ScriptRunner to do this:

ScriptRunner runner = new ScriptRunner(dataSource.getConnection());
runner.setAutoCommit(true);
runner.setStopOnError(true);
runner.runScript(getResourceAsReader("Filename.sql"));
runner.closeConnection();

answered Jan 4, 2016 at 8:40

Persia

9155 silver badges9 bronze badges

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

2 Comments

agad Over a year ago

What about myBatis?

Matt Wonlaw Over a year ago

it is in the mybatis repo under the ibatis pkg path -- github.com/mybatis/mybatis-3/blob/…

Praveen Hiremath · Accepted Answer · 2016-02-22 11:53:53Z

0

private void runMysqlScript(String sqlScriptFilePath) {

    try {
        // Create MySQL Connection
        Class.forName(driverClassName);
        Connection connection = 
                DriverManager.getConnection(jdbcURL, jdbcUsername, jdbcPassword);
        // Initialize object for ScriptRunner
        ScriptRunner runner = new ScriptRunner(connection);
        // Give the input file to Reader
        Reader br = new BufferedReader(new FileReader(sqlScriptFilePath));
        // Execute script
        runner.runScript(br);

    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (Exception e) {
        e.printStackTrace();
    }
}

answered Feb 22, 2016 at 11:53

Praveen Hiremath

4,2192 gold badges19 silver badges11 bronze badges

1 Comment

agad Over a year ago

What about myBatis?

Collectives™ on Stack Overflow

Execute Filename.sql file in Java using MyBatis

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related