I was wondering if it's possible to add an auto drop & auto create schema feature to hibernate, something similar as the <create-table> and <drop-table> in jboss-cmp.
This could be easily added inside the <class> tag as elements or as attributes. <class name="com.something.PersistentClass" ....> <drop-schema>true</drop-schema> <create-schema>true</create-schema> . . </class> or <class name="com.something.PersistentClass" drop-schema="true" create-schema="true"> . . </class> Implementation shouldn't be too difficult considering existing methods Datastore.generateSchemaDropScript() and Datastore.generateSchemaCreateScript() which I used to accomplish this task in testing Hibernate, but I think this feature could be very valuable for devel-time, in an automated manner, maybe at SessionFactory construction time (for Hibernate provided db connections). Any opinions? Can this be considered for future implementation? I also been thinking another solution could be extending cirrus.hibernate.jmx.HibernateService to allow schema creation & drop (on-demand or automatic on deploy time) but this last solution leaves out all non-JMX Hibernate users. Anybody? Off course the ideal solution would be using a very smart SchemaUpdater but I don't think it's worth the effort of creating such a piece of software since most uses will be in development time when we can live with the drop-create cycle even if it doesn't always work perfectly. On the other hand, who could rely on a SchemaUpdater on a production-time system? Just my thoughts... (and desire) -- Saludos, Pablo mailto:[EMAIL PROTECTED] "The only thing that interferes with my learning is my education." Albert Einstein ------------------------------------------------------- This SF.net email is sponsored by: Get the new Palm Tungsten T handheld. Power & Color in a compact size! http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel