Q:

Java and HSQLDB, how to add column automatically after update

I have an application in Java Spring using HSQLDB database.
For an evolution, i have to add a column to an existing table.
So, I have done what I have to do (adding the attribute in the entity class with the info) but when i deploy my new app in tomcat, the database is not updated and i can't start my app.
Is it possible to add the column automatically?
Here is the configuration of the database in the applicationContext.xml:
<bean id="myEmf"
    class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
    <property name="dataSource" ref="dataSourceDb" />
    <property name="jpaVendorAdapter">
        <bean
            class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
            <property name="generateDdl" value="true" />
        </bean>
    </property>
    <property name="jpaProperties">
        <props>
            <prop key="hibernate.dialect">org.hibernate.dialect.HSQLDialect</prop>
            <prop key="hibernate.show_sql">true</prop>
            <prop key="hibernate.format_sql">false</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
        </props>
    </property>
</bean>

Thank you for your help.

A:

Of course, if you using Hibernate, you can make use of auto-generation from object model.
But this way is not good for a production use.
I suggest you to use database migration tool. It provide you means for auto execution of your sql scripts in certain order.
Look at flyway, liquibase.

