Re: [Hibernate] dynamic schema update

[Christoph S. <ch...@sc...>]

Gavin King wrote:

>>I have now added a Schemaupdater to hibernate. At the moment it only
>>adds missing colums to the schema, and creates tables if they are
>>missing. I have testet it with sql server. All the rest of hibernate
>>seems to still work, so I could commit it to cvs if you have no
>>    
>>
>objections.
>
>Cool!! Go Ahead and check it in. Sounds like something that will really
>be used by a lot of users....
>
>
>  
>
>>Something we should really do in the near future is create classes for
>>all the sql statements. I think we should think of our database dialects
>>as SQL-Statementfactory-factories, then we could deal with different sql
>>dialects much easier.
>>    
>>
>
>
>Yes, you are absolutely right (and I have mentioned this before). The main
>remaining piece of bad-design is the lack of a proper OO model of SQL.
>If you want to have a go at writing an elegant heirarchy of classes for
>this,
>it would be _highly_ appreciated.
>  
>
i wonder if
http://sourceforge.net/projects/crossdb/ would be an option. Just saw 
that the ojb guys use this.

regards
 chris