1 Reply Latest reply on Jun 6, 2012 6:21 PM by user730201

    how to handle concurrency on stage clear command

    838103
      Hi,

      We have one jacl script which runs in an interactive mode and uploads data into RS from Report. In this jacl we are running stage clear "RSName" command. But stage clear internally truncates the stage table and while doing that acquires the lock on the table. So if another request comes and try to do the stage clear it throws resource busy Oracle error. So may I know how to make stage clear command threadsafe in Jacl. Certainly we can put jacl in singlethread mode and put incoming requests in queue but there is performance penalty on that & since our jacl is being called from multiple request we can't enque the requests. May i know is there any way to run stage clear command in thread safe way, essentially we want to know can we run portion of jacl in the threadsafe way instead of running entire jacl in single thread mode.

      Thanks,
      Sunil