Can I have H2 autocreate a schema in an in-memory database?

by

Yes, H2 supports executing SQL statements when connecting. You could run a script, or just a statement or two:

String url = "jdbc:h2:mem:test;" + 
             "INIT=CREATE SCHEMA IF NOT EXISTS TEST"
String url = "jdbc:h2:mem:test;" + 
             "INIT=CREATE SCHEMA IF NOT EXISTS TEST\\;" + 
                  "SET SCHEMA TEST";
String url = "jdbc:h2:mem;" + 
             "INIT=RUNSCRIPT FROM '~/create.sql'\\;" + 
                  "RUNSCRIPT FROM '~/populate.sql'";

Please note the double backslash (\\) is only required within Java. The backslash(es) before ; within the INIT is required.

More Related Contents:

  1. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  2. H2 in-memory database. Table not found
  3. How can I detect a SQL table’s existence in Java?
  4. Embedding the Java h2 database programmatically
  5. H2 database error: Database may be already in use: “Locked by another process”
  6. How do I get the size of a java.sql.ResultSet?
  7. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  8. How to print a query string with parameter values when using Hibernate
  9. Java Embedded Databases Comparison [closed]
  10. MySQL and JDBC with rewriteBatchedStatements=true
  11. Hibernate and no PK
  12. how can I create new XML file from existing database in PostgreSQL database using java [closed]
  13. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  14. How can I use hibernate with MS Access?
  15. Hibernate Group by Criteria Object
  16. dll missing in JDBC
  17. Android: Cannot perform this operation because the connection pool has been closed
  18. How to add JCheckBox in JTable?
  19. Java Best Practice for Date Manipulation/Storage for Geographically Diverse Users
  20. XML data to PostgreSQL database [closed]
  21. how to copy data from file to PostgreSQL using JDBC?
  22. Inserting null to an Integer column using JDBC
  23. JPA using multiple database schemas
  24. Iterating through a List Object in JSP
  25. How to use prepared statement for select query in Java?
  26. How to Iterate through HashMap in MyBatis foreach?
  27. Which one to use, int or Integer
  28. Database independence through JDBC in java
  29. How to escape colon `:` within a native SQL query in Hibernate?
  30. When to use JCR (content repository) over other options?

Leave a Comment