Why in the seam-booking example sql data disappear when jbos

[janprill]

Hi, Guest,

I've not used Seam myself, but anyway: Since Seam uses EJB3 as it's ORM-Layer my bet would be, that you have

hibernate.hbm2ddl.auto=create-drop

in your deploy/ejb3.deployer/META-INF/persistence.properties. This means, that the database where the entity-beans get persisted gets dropped on every undeployment of the ear that carries the booking demo. Undeployment happens on shutdown. So try to set this to 'create'. 'create-drop' comes in useful while you are changing lots of things on your model while you are in development. For more in detail information refer to the EJB3-Docs at http://docs.jboss.org/ejb3/app-server/reference/build/reference/en/html/index.html

best regards
Jan Prill

[gavin.king]

This is true, but another reason is that by default the demo app is using an in-memory instance of HSQLDB.

You need to change the settings in booking-ds.xml.

[gavin.king]

"Guest" wrote:


ps: i am using sqlserver as datasource

Oh, I did not see this. Yes, disable schema dropping,