2 Replies Latest reply on Oct 6, 2003 6:07 PM by senthilcool

    Row-locking and on-find read ahead strategy

    senthilcool Newbie

      Why doesn't the row locking of the CMP bean work if the bean is configured for on-find read ahead strategy?

      I am able to make it work with the default or on-load startegies but in either case the container fires two queries for every update. The first query to get the primary key and the second one to get the remaining fields as a SELECT FOR UPDATE.

      Is there way to make row locking work with just one query before the UPDATE statement ?

      Thanks for the help.