Changing database structure

ebu Mar 2, 2005 6:00 AM

Hi.
Definitely somebody already got the experience of changing database with data which is used by JBoss for CMP. Is there some pitfalls in using special update script generation tools such as DB SynchroComp (http://www.e-dule.com/) ? Or maybe there are better approaches?

thanx, eugen.

1. Re: Changing database structure

triathlon98 Mar 2, 2005 8:26 AM (in response to ebu)

Maybe you could check out the alter-table setting in JBoss. See the wiki pages about the CMP engine.

Joachim
Actions
2. Re: Changing database structure

ebu Mar 2, 2005 9:45 AM (in response to ebu)

Have you used this option in production system with important data? Everything was smooth? I saw couple of times that it tried to update table in a way that caused SQL Exception... so i would still afraid to entrust this process to JBoss :). Besides this while using script you can easily create backup ...
Actions
3. Re: Changing database structure

triathlon98 Mar 2, 2005 10:43 AM (in response to ebu)

Using it all the time, on production databases, use firebird as database server. Works like a dream.

Firebird will throw an exception if the database has other users. Apart from that, no problems so far (and I add fields quite often).

Joachim
Actions
4. Re: Changing database structure

ebu Mar 3, 2005 1:51 AM (in response to ebu)

Ok, thank you very mcuh.
Actions
5. Re: Changing database structure

jim168 Jun 10, 2005 3:35 AM (in response to ebu)

OS: Windows 2000
JBoss:4.0.2
EJB3.0:Preview 5
hibernate.hbm2ddl.auto=update

no matter alter-table is set or not:
when there is a property added in entity bean, there is a field added. :)
when there is a property deleted in entity bean, nothing changed in db table. :(

Is that a issue not implemented yet and called EJBTHREE-176?
Actions

Go to original post