Running a .sql script using MySQL with JDBC

by

Ok. You can use this class here (posted on pastebin because of file length) in your project. But remember to keep the apache license info.

JDBC ScriptRunner

It’s ripoff of the iBatis ScriptRunner with dependencies removed.

You can use it like this 

Connection con = ....
ScriptRunner runner = new ScriptRunner(con, [booleanAutoCommit], [booleanStopOnerror]);
runner.runScript(new BufferedReader(new FileReader("test.sql")));

That’s it!

More Related Contents:

  1. Hours and seconds are lost when storing a date in the database [closed]
  2. Multiple queries executed in java in single statement
  3. MySQL and JDBC with rewriteBatchedStatements=true
  4. right syntax to use near ‘?’
  5. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  6. How to use prepared statement for select query in Java?
  7. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  8. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  9. Simulate Result set closing failed [closed]
  10. Efficient way to do batch INSERTS with JDBC
  11. Java: Insert multiple rows into MySQL with PreparedStatement
  12. How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?
  13. How does a PreparedStatement avoid or prevent SQL injection?
  14. Closing JDBC Connections in Pool
  15. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  16. Returning a ResultSet
  17. How to configure Tomcat to connect with MySQL
  18. How to enable logging for SQL statements when using JDBC
  19. Retrieve an Image stored as BLOB on a MYSQL DB
  20. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  21. mysql prepared statement error: MySQLSyntaxErrorException
  22. dll missing in JDBC
  23. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  24. How to correctly write UTF-8 strings into MySQL through JDBC interface
  25. Inserting null to an Integer column using JDBC
  26. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. JDBC MySQL connection using Unix Socket
  29. Searching between dates in SQL with JDBC?
  30. Getting last record from mysql

Leave a Comment