(not) drop tables when running app?

[Jack Punt]

I've used roo to define database entities, and use the generated views/forms to insert data into the database.
I have configured to use mysql rather than the in-mem hsqldb:

persistence setup  --provider HIBERNATE  --database MYSQL

And indeed the data is correctly persisted.

But when I re-run the app/tomcat (from within STS) existing tables are dropped.

Can someone point me to the config/switch that makes STS or whatever [not] delete the data?

[Andrew Swan]

Please see this thread and others.

[Jack Punt]

Thank you.

I knew it should be easy, but didn't know what to search for.

[Ben Alex]

I'll get this added to the reference guide (tracked as https://jira.springsource.org/browse/ROO-627).

[Jack Punt]

And a comment in the persistence.xml might be helpful.
I believe many users will find their way to this config file, so it's is a good place to put the info or a link:

    <persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
        <provider>org.hibernate.ejb.HibernatePersistence</provider>
        <properties>
            <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
	    <!-- value="create" to get new database each run; value="update" to use existing database: see ... -->
            <property name="hibernate.hbm2ddl.auto" value="update"/>
            <property name="hibernate.ejb.naming_strategy" value="org.hibernate.cfg.ImprovedNamingStrategy"/>
        </properties>
    </persistence-unit>

[Andrew Swan]

I'll get this added to the reference guide (tracked as https://jira.springsource.org/browse/ROO-627).

Fixed that for ya.

P.S. Jack's idea of putting a comment in persistence.xml is a great one.

[Ben Alex]

ROO-627 is now completed. Both the persistence.xml suggestion and reference guide section have been added.