Simple usually is. :) In my environment I'm currently using a little EJB3 JMX Pojo called a "DatabaseBootstrapService". Its responsibility:
* Ensure the necessary schemas exist, and if not, creates 'em * Ensure the necessary DB users exist, and if not, creates 'em. * Creates the necessary tables. * Populates required data for the system to work. All this is done via execution of SQL Files I place in $JBOSS_HOME/server/[serverName]/sql. In local development and staging environments, HBM2DDL is set to autogen (create-drop for local and update for stage). However, in production, I don't want Hibernate ever mucking with the schema. So I set the Service to fire off the SQL scripts, which are really just preapproved executions of the Hibernate HBM2DDL from the stage environment logs. ...and this is my solution for DB migration between versions as well. Build locally, test on Stage, and once I'm sure that the SQL fired by Hibernate (and any other operations I need to do) are square, I create SQL Scripts for them and fire from the JMX console so I can take advantage of the transaction it provides. What are some other solutions out there for migration/DB population? S, ALR View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4008001#4008001 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4008001 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
