What are the opinions of creating SQL-update statements dynamically ?
It seems that now all fields are written to the database even if they have not been changed. So why not create an SQL statement with only the changed fields ? Does OJB know which fields have changed ? Would this feature make it into OJB ?
I need this feature because of : - background processes which have the exclusive right to write certain fields in records (I made sure that foreground processes will not write these fiels) can do so without locking mechanisme. (In fact the background processes are forbidden to wait for locks. It must have kindof realtime responses) - Changing one field in a large record has a lot of overhead.
I know that hibernate supports this mechanism in 2.0. How about OJB ?
Kees.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
