-don't realy understand what singlefields are can you explain?In the default SQL92 implementation, the same data is stored on multiple places.
I will illustrate this by the following example with MySQL:
The structure we have is the following:
Object -> Insrel -> Posrel
The Object nodemanager has the field 'owner', which means in the SQL92 implementation that Insrel and Posrel also have that field in their definition.
If we look in the database, we see the following values stored:
object.owner = 'system'
insrel.owner = 'system'
posrel.owner = 'system'
I think that it is much better to store the value only one time (thus in object.owner and not on other places)
-is see only changes in "generic" is there no oracle specific code and doesI think you are refering to the name Sql92WithViews.java. I could give this class the name Like OracleWithViews, but i also want to (or try)write a version for MSSQL(if i can find suitable jdbc drivers).
Giving it the name with Oracle in it would lead to the same problems that occured with PostgreSQL* and then we would have to restructure the classes again(or dont use the OO).
-the code them compile whitout oracle-jdbc-drivers?Oracle jdbc drivers are not needed to compile.
-are we talking about 1.6 or 1.7 (with query classes)?Current HEAD-CVS of last monday (changes of Rob van Maris still have to put into it, bug changelog doesnt work on MMBase.org, i no longer receive [EMAIL PROTECTED] email, and marge led to a large amount of conflicts. More reason for me to get it into CVS, so that a dont have to use a copy)
I dont dare to put it into 1.6, since it also involves changing the current postgresql implementation.
-- Time is on my side,....
Eduard Witteveen +316 414 789 23
