> > That will make sure that an insert on the mm_news also inserts into > > the object table. This means that you won't have to do loop of inserts > > into all parent builders (like the mysql solution). > > My version is based on the old SQL92WithViews class. That one didn't use > triggers to do the insert. It is nicer to solve the insert problem > inside the database so yours is probably much better :-) I think only > Vodafone is using the SQL92WothViews class so they have only a problem > upgrading to 1.8
So you haven't tested this on oracle, just ported the code? I've noticed some bugs/features when talking to oracle; mostly to do with uppercase/lowercase tablenames. > If your version also works on mssql then we should replace my version > with yours. Well, I'd rather extend yours a bit to make it work on oracle. I have no MSSQL server, so I have no idea if my code would also work on microsoft sql server. What I will do is extend the 'withviews' to also include trigger functionality, which can be skipped if no trigger schemes are defined. > > I also wrote a sqlhandler that can deal with limit and offset by using > > some 'rownum' magic. I am still willing to commit that if you agree. > > That is what I meant with missing functionality I will spend some time this week to port my changes to your implementation. Johannes _______________________________________________ Developers mailing list [email protected] http://lists.mmbase.org/mailman/listinfo/developers
