How to execute SQL statements during deployment
The article is about how to execute some cleanup or initialization SQL statements during the deployment time of, for example, a data source. Below is an example of how this can be done.
The following are the dependencies used in this example:
my-sql.jarcontaining the .sql files to be executed (this has nothing to do with MySQL, it's just a jar file containing .sql files, nothing more).
How it works
We must specify a GBean in the connector deployment descriptor. This gbean will execute during deployment time. But it needs the following information:
- Name of a Datasource to execute on
- Path to the .sql file
- A test sql query that will act as a boolean. If the query returns zero number of records, the sql statements will be executed (e.g. you may want to create some tables)