Run SQL script

gistfile1.txt

import org.apache.ibatis.jdbc.ScriptRunner;

@Resource(mappedName = "ecumen/jdbc/smedev")
private DataSource dataSource;

@Override
@TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
public void saveAdmin() {

    InputStream inputStream = getClass().getClassLoader().getResourceAsStream("META-INF/import.sql");
    Connection connection;
    try {
        connection = dataSource.getConnection();
    } catch (SQLException e) {
        e.printStackTrace();
        return;
    }

    ScriptRunner scriptRunner = new ScriptRunner(connection);
    try {
        scriptRunner.setAutoCommit(false);
        scriptRunner.runScript(new BufferedReader(new InputStreamReader(inputStream, "UTF-8")));
    } catch (UnsupportedEncodingException e) {
        e.printStackTrace();
    }

}