JDBC initialize database
Use this if you want to initialize a database on startup (or on exit). This can be use for example for table creation and/or population.
The script locations can also be patterns with wildcards in the usual ant style used. (e.g. classpath:/com/foo//sql/-data.sql). If a pattern is used the scripts are executed in lexical order of their URL or filename.
To use custom SQL scripts, add them to the flow resources and then use the prefix resources/
in front of the filename. Uploading the script will change the filename. To find the new filename download the file after uploading it.
eMagiz provides to initialization scripts:
When using a H2 database for a Spring Integration (channel) message store use this location:
classpath:com/emagiz/components/jdbc/int-schema-h2.sql
When using a H2 database for Spring Batch (ETL) use this location:
classpath:com/emagiz/components/jdbc/batch-schema-h2.sql