You can define and link to SQL scripts in a JPA persistence context definition that will be executed at runtime. There are standardized properties to define scripts how to create the schema, bulk-load data and drop the schema, respectively:

<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
 http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
 <persistence-unit name="prod" transaction-type="JTA">
 <properties>

 <property name="javax.persistence.schema-generation.database.action"
 value="drop-and-create"/>

 <property name="javax.persistence.schema-generation.create-script-source"
 value="create-schema.sql" />

 <property name="javax.persistence.schema-generation.sql-load-script-source"
 value="load-data.sql" />

 <property name="javax.persistence.schema-generation.drop-script-source"
 value="drop-schema.sql" />

 </properties>
 </persistence-unit>
</persistence>

The SQL files are expected to reside in the classpath.

This post was reposted from my newsletter issue 004