Updating tables on Tomcat (Liferay) server

Hendrik V
2013-03-15
2013-03-18
  • Hendrik V
    Hendrik V
    2013-03-15

    I would be most grateful for any help!

    When I've added/changed an attribute to a class, in Eclipse I run on build.xml "Run as" -> "Ant build", and choose "updateSchema", which adjusts my PostgreSQL tables.

    How do I do this on my server once I deploy the WAR file? (Running Ubuntu + PostgreSQL + Tomcat + Liferay 6)

    Thanks,
    Hendrik

     
  • Javier Paniza
    Javier Paniza
    2013-03-18

    Hi Hendrik,

    you have several options.
    If you have access network access from your developer machine to database production database you can:
    1. Changing the junit persistence unit configuration to point to your production database, then run updateSchema.
    2. Run some tool for synchronizing schema Postgress application, maybe they are more robust that the Hiberante schema updater.

    If you have no network access to your production database.
    3. Copy the SQL stament from your log when you execute updateSchema against your development database and execute them against your production database.
    4. Run hibernate schema from code (instead from ant) from inside your application. You have to code it, however it can be the base of a good schema evolution engine.

    In any case, make a backup of your production database before any action.


    Help others in this forum as I help you.
    Need more help? Get OpenXava professional support.