On Thu, 2002-06-27 at 08:22, Erik Visser wrote: > After adding a user, i see the following warning in the log file: > > WARN module.database.support.MMSQL92Node commit.? - changing the 'owner' > field, could give probems due to update on 2 tables without locking(builder, > object) > > Is there a setting to avoid these possible problems? no , not realy, if you use informix of postgresql an update to an object like posreal automaticaly updates the 'paren' builder (owner from the insrel table and owner from the object table')'
But when you are using mysql/hypersonic this behaviour is 'faked' and an update on fields like owner results in 3 sql update statements. the current implementation of the sql92 interface does'nt do transactions yet (work in progres) so this warning will keep comming back. The short solution is to remove the line that prints out the message. > > (sorry if this posting is posted twice) > > Erik Visser > Java Programmer > > Finalist IT Group > Java Specialists
