How to execute SQL statements during deployment
There may be times where you will want to execute some cleanup or initialization SQL statements during the deployment time of, say, a datasource. Below is an example of how this can be done.
The following are the dependencies used in this example:
- my-sql.jar containing 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)