> It is good to know you solved your task. The only thing I do not > understand is why do you create tables using SQL commands. Thanks to > the great work of the people around SQLobjects it just a piece of > cake to create your any table using SQLobject:
I can't speak for him, but I can speak for myself. ORMs only get you so far when it comes to maintaining databases schemas in production environments. A production database often has to be up 100% of the time. During an upgrade there is almost always a period where two versions of the application are using the same database. In these cases the new schema has to support both versions application versions. There are often schema entities outside of SQLobject's purview that have to be maintained. Among these are grants, users, triggers, and stored procedures. Data has to be transformed from the previous schema to the new schema. The changes have to be reversible so that database can be rolled back in case of deployment failure. All of this has to be done while the database is live. The simplest way of doing this is a series of SQL patches which are applied to the database. - Jeff Younker - [EMAIL PROTECTED] - ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
