Hello,
We have been using Hibernate/JPA/Spring based configuration for the project and for the development phase we are using "<property name="hibernate.hbm2ddl.auto" value="create-drop" /> ". Hibernate takes care of creating tables and db using entities based annotation when the application server starts/restarts.

We have been using some Stored procedures and triggers as well, but each time db is dropped they have to be created manually, though tables are getting created automatically.

Can someone point a direction so that may be we can execute a .sql file containing creation of trigger/SP SQL statements and it get executed on server startup automatically?

thanks a ton.

By using Hibernate, you can't create stored procedures or trigger automatically, I tried before but it doesn't work

Yes......so for time being, I created my own dispatcher servlet in spring, created a dao with method to execute scripts from my project folder, on startup of application server, spring executes dispatcher servlet and hence my .sql file gets processed and job is done. still waiting for other idea/solution....