THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
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, for example, 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)