h2sql-scripts

Executing script file in h2 database

First of all I would like to say am new to h2 database. I need to execute a sql script file in h2 database. I have a script file test.sql and I want to execute this in h2 database. Is it possible?

Solution

  • 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"));