On Wednesday 25 October 2006 17:36, Oleg Broytmann wrote: > On Wed, Oct 25, 2006 at 02:18:40PM +0000, Matthew Wilson wrote: > > I created the following two tables, ran the sql, and then discovered > > that the foreign keys were not in the database: > > Foreign key constraints will be implemented in SQLObject 0.8. You > can try SQLObject from the SVN trunk.
Will it be possible to still use the current capability of SQLObject to use foreign keys even on tables that are not capable of such thing internally (like with mysql's myisam tables)? In other words my question is if this new database key constraint implementation will replace the current behavior or will they both be available? I agree that the current behavior is less efficient as it has to do all the work internally and involves a lot of sql queries to perform a cascaded delete for example but it works on any type of database even if it doesn't support key constrains, so having it around for such cases would still be useful. -- Dan ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
