6 Replies Latest reply on Oct 19, 2005 1:04 PM by spaquet

database flushed on each deploy

phon Oct 4, 2005 9:12 AM

everytime i redeploy my EJB3 application to JBoss all the data in my database gets flushed, how can i prevent this ?

1. Re: database flushed on each deploy

bill.burke Oct 4, 2005 11:32 AM (in response to phon)

comment out:

ejb3.deployer/META-INF/persistence.properties

hbm2ddl=create-drop

or change it to update.
Actions
2. Re: database flushed on each deploy

phon Oct 4, 2005 11:50 AM (in response to phon)

it seems it is already commented out, is there another place where i can config the hbm2ddl properties ?

this is my persistence.properties :

hibernate.transaction.manager_lookup_class=org.hibernate.transaction.JBossTrans
hibernate.connection.release_mode=after_statement
hibernate.transaction.flush_before_completion=false
hibernate.transaction.auto_close_session=false
hibernate.query.factory_class=org.hibernate.hql.ast.ASTQueryTranslatorFactory
#hibernate.hbm2ddl.auto=create-drop
hibernate.hbm2ddl.auto=update
hibernate.cache.provider_class=org.hibernate.cache.HashtableCacheProvider
# Clustered cache with TreeCache
#hibernate.cache.provider_class=org.jboss.ejb3.entity.TreeCacheProviderHook
#hibernate.treecache.mbean.object_name=jboss.cache:service=EJB3EntityTreeCache
hibernate.connection.datasource=java:/DefaultDS
hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
hibernate.jndi.java.naming.factory.initial=org.jnp.interfaces.NamingContextFact
hibernate.jndi.java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces
Actions
3. Re: database flushed on each deploy

phon Oct 4, 2005 12:01 PM (in response to phon)

i can find no other place to configure it

#.../jboss-4.0.3RC2$ fgrep -rin --exclude *log* hbm2ddl *
Binary file server/all/deploy/jboss-hibernate.deployer/hibernate3.jar matches
server/all/deploy/ejb3.deployer/META-INF/persistence.properties:6:#hibernate.hbm2ddl.auto=create-drop
server/all/deploy/ejb3.deployer/META-INF/persistence.properties:7:hibernate.hbm2ddl.auto=update
Binary file server/all/deploy/ejb3.deployer/hibernate3.jar matches
Binary file server/all/tmp/deploy/tmp34886hibernate3.jar matches
Binary file server/all/tmp/deploy/tmp34904hibernate3.jar matches
Binary file server/default/deploy/jboss-hibernate.deployer/hibernate3.jar matches
Actions

4. Re: database flushed on each deploy

jc7442 Oct 4, 2005 12:41 PM (in response to phon)

For my app i put it in the persistence.xml of the par.

<?xml version="1.0" encoding="UTF-8"?>
<entity-manager>
 <name>toto</name>
 <jta-data-source>java:/MySqlDS</jta-data-source>
 <properties>
 <property name="hibernate.hbm2ddl.auto" value="update"/>
 <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
 </properties>
</entity-manager>

5. Re: database flushed on each deploy

phon Oct 5, 2005 2:28 AM (in response to phon)

it seems the JBoss server updates the tables now rather than re-creating them :

07:25:09,439 INFO [SchemaUpdate] Running hbm2ddl schema update
07:25:09,439 INFO [SchemaUpdate] fetching database metadata
07:25:09,442 INFO [SchemaUpdate] updating schema

but the data inside the tables is still flushed, what could be the cause of this problem ?
Actions
6. Re: database flushed on each deploy

spaquet Oct 19, 2005 1:04 PM (in response to phon)

Using persistence.xml in the project with works properly
Actions

Go to original post