Executing script file in h2 database

by

You can use the RUNSCRIPT SQL statement:

RUNSCRIPT FROM 'test.sql'

or you can use the RunScript standalone / command line tool:

java -cp h2*.jar org.h2.tools.RunScript -url jdbc:h2:~/test -script test.sql

You can also use the RunScript tool within an application:

RunScript.execute(conn, new FileReader("test.sql"));

More Related Contents:

  1. Timeout error trying to lock table in h2
  2. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  3. H2 in-memory database. Table not found
  4. How to Execute SQL Script File in Java?
  5. How to access in memory h2 database of one spring boot application from another spring boot application
  6. Spring Boot default H2 jdbc connection (and H2 console)
  7. Frontend tool to manage H2 database [closed]
  8. How to find rows in one table that have no corresponding row in another table
  9. SQL query that gives distinct results that match multiple columns
  10. Populate JFreechart TimeSeriesCollection from Mysql DB?
  11. Can I have H2 autocreate a schema in an in-memory database?
  12. Connect to H2 database using IntelliJ database client
  13. How can I describe a table in Oracle without using the DESCRIBE command?
  14. Embedding the Java h2 database programmatically
  15. How to map a JSON column with H2, JPA, and Hibernate
  16. View content of H2 or HSQLDB in-memory database
  17. How in H2DB get sql dump like in MySql?
  18. H2 database error: Database may be already in use: “Locked by another process”
  19. H2 Database vs SQLite on Android [closed]

Leave a Comment