jolly
VIP Member
Hi All,
I have observed that if a Table Trigger (post Insert) runs, as triggered by inserting a record in an interactive session on a web server, the trigger code is seeing a cached copy of a table (F0006). The trigger is not seeing changes made to F0006 made by other users.
Clearing JDBi Service Cache from Server Manager does not resolve this problem. Stopping the Web Instance and restarting it does resolve the problem.
Is there a better way around this issue? I want to resolve this in PD without booting off the users on what is a 24/7 operation.
System is:
8.12 8.98.4.5 Oracle WEBLogic4 iSeries V6R1 DB2 for i
Thanks
JohnO
I have observed that if a Table Trigger (post Insert) runs, as triggered by inserting a record in an interactive session on a web server, the trigger code is seeing a cached copy of a table (F0006). The trigger is not seeing changes made to F0006 made by other users.
Clearing JDBi Service Cache from Server Manager does not resolve this problem. Stopping the Web Instance and restarting it does resolve the problem.
Is there a better way around this issue? I want to resolve this in PD without booting off the users on what is a 24/7 operation.
System is:
8.12 8.98.4.5 Oracle WEBLogic4 iSeries V6R1 DB2 for i
Thanks
JohnO