Johannes Verelst wrote:
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.
No, not this version, but is it is based on a working
SQL92WithViews.java and a working 1.8-hacked version. The case of tables
and views are gemerated based on what the driver (metadata) wants.
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.
MS SQL Server supports triggers. It might be some changes in syntax.
Nico
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
