JBoss4.0.4RC1: tables were dropped

[gus888]

Hi all,

It was very painful when I tried to migrate to JBoss4.0.4RC1 from EJB3.0RC3. Finally, it worked, but I found that all my data in database were deleted and tables were recreated. My persistence.xml was:

<persistence>
 <persistence-unit name="dvd">
 <jta-data-source>java:/DVD_DS</jta-data-source>
 <properties>

 <property name="hibernate.hbm2ddl.auto" value="create-drop"/>

 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect" />

 <property name="hibernate.cache.provider_class"
 value="org.jboss.ejb3.entity.TreeCacheProviderHook"/>
 <property name="hibernate.treecache.mbean.object_name"
 value="jboss.cache:service=EJB3EntityTreeCache"/>

 </properties>
 </persistence-unit>
</persistence>

Later, I changed the line

<property name="hibernate.hbm2ddl.auto" value="create-drop"/>

to

<property name="hibernate.hbm2ddl.auto" value="none"/>

and recreated new tables, but I found parts of my tables were dropped, and some of them remained. I do not know what is wrong with persistence.xml. Any help would be appreciated. Thanks in advance.

GUS

[ejb3workshop]

Do the table still disappear when you restart or redeploy.

[gus888]

When I restarted AS, some tables disappeared. However, when I completely removed the line

<property name="hibernate.hbm2ddl.auto" value="create-drop"/>

All tables I recreated remain the same (no change). I do not understant why. Thank you for your response.

GUS

[aidan_b5]

set to:

<property name="hibernate.hbm2ddl.auto" value="update"/>

for permanent persistence

[aidan_b5]

double post, sorry

create-drop specifies that a table should be created if it does not exist and dropped when the AS is turned off.

Therefore, your tables were being created and dropped during the life of the server. By specifying update (which i think may be the default), the tables are created if needed, and updated as necessary - but never dropped.

Hope this helps.

[gus888]

I will try it. Thank you so much for your help. I really appreciate it.

GUS