tag:blogger.com,1999:blog-5874979429188093780.post5131578506384094824..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: View Criteria and CRITERIA_AUTO_EXECUTE Property - ADF 11g PS3Andrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-5874979429188093780.post-2557881331017745822017-09-01T07:45:58.869+02:002017-09-01T07:45:58.869+02:00I understand this, but you should check in runtime...I understand this, but you should check in runtime log - if it really writes state to DB.<br /><br />Even if it does, i dont see it as performance issue. This is not a passivation/activation event.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-20821822002014404992017-09-01T06:35:20.465+02:002017-09-01T06:35:20.465+02:00Looks YES,
saveState – It saves the snapshot of al...Looks YES,<br />saveState – It saves the snapshot of all literal values and variable values.<br />i.As per the state management - if the jbo.server.internal_connection is not set explicitly then the state management facility creates the temporary tables using the credentials of the current application database connection.<br />To keep the temporary information separate, <b>the state management facility uses a different connection instance from the database connection pool,</b> but the database credentials are the same as the current user.<br />Jagadeesh Badrinoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-53213623841159435902017-08-30T07:53:33.242+02:002017-08-30T07:53:33.242+02:00I doubt it, you should check the log - if it reall...I doubt it, you should check the log - if it really does passivation on VC saveState.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-72526728557708765882017-08-30T01:38:05.007+02:002017-08-30T01:38:05.007+02:00Hi Andrejus,
We noticed connection are being incre...Hi Andrejus,<br />We noticed connection are being increased in production due to this change(calling saveState on vc).<br />we suspect when we are using saveState on View Criteria Item ,bindVariable are storing as snapshot and resulting in passivation(writing these bind params state) to PS_TXN table <br />is there any alternate way to achive this requirment.<br />is it safe to call saveState on VC .does it cause the increase of connections <br /><br />Thanks<br />Karnakar<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-82812402234203909722017-07-09T06:09:42.260+02:002017-07-09T06:09:42.260+02:00Hi Andrejus,
does reset button works in this case?...Hi Andrejus,<br />does reset button works in this case?<br />what I Observed is reset is not working with this approach.<br />could please download link for this applicationAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-46992828996903676212011-05-09T17:11:39.947+02:002011-05-09T17:11:39.947+02:00Thanks,
It works
CorneliuThanks,<br /><br />It works<br /><br />CorneliuCorneliuhttps://www.blogger.com/profile/10191018750756874488noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-36871028200348397542011-05-09T12:43:56.012+02:002011-05-09T12:43:56.012+02:00Hi,
It will happen, only if Query Auto Execute is...Hi,<br /><br />It will happen, only if Query Auto Execute is set to True.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-70581204766255219932011-05-09T10:24:21.733+02:002011-05-09T10:24:21.733+02:00Hi,
Should the iterator auto reset when I reset a...Hi,<br /><br />Should the iterator auto reset when I reset a view criteria?<br />Because on the page the iterator still remains with the values from search.<br /><br />Regards CorneliuCorneliuhttps://www.blogger.com/profile/10191018750756874488noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-19753073967553573832011-05-09T10:21:08.070+02:002011-05-09T10:21:08.070+02:00Hi,
I make a search and after reseting the ViewCr...Hi,<br /><br />I make a search and after reseting the ViewCriteria, the iterator on page won't reset to its previous state. <br /><br />Should the Iterator automaticaly reset also when I reset the ViewCriteria?<br /><br />Regards CorneliuCorneliuhttps://www.blogger.com/profile/10191018750756874488noreply@blogger.com