Database overwritten at each JBoss startup once again.

[tzablock]

Although i have his line in my persistance.xml file

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

the database gets recreated each time the application is deployed or the server is shutdown.

Any clue on what is the reason?

tzablock

[silviu.marcu]

what db are you using ?

[tzablock]

I've managed to fix this issue at last. I'm using Oracle Express database. Unfortunately JBoss is not reading this hbm2dll property while deploying the application. I had to configure the persistance.properties file in the ejb3.deployer folder. That was the solution...

[silviu.marcu]

it is reading ...
you should have:
in xyz.ejb3 file you can have a META-INF/persistence.xml

this is read at ejb3 deploy time ...

[jmoring]

How do you get JBoss/Hibernate to never generate DDL? I left the option out of the persistence.xml file and it seems the default is to create the tables on startup and drop them on shutdown. If this is true it is insane. Who would ever want that option let alone have it as the default. Hopefully I am missing something here as I am new to EBJ3 persistence.

SQLServer 2000
jTDS 1.2

Thanks
Jim

[jmoring]

Solved my problem....

Sorry I didn't search the forums before posting this (emotions were running high:) ). The default Persistence.properties in Ebj3/deployer contained the SchemaUpdate option. I removed it and now my tables are unchanged at start up.