Print Thread
Commit Rollback on all windows
#62322 01/15/21 10:52 AM
Joined: Oct 2017
Posts: 16
K
kcl Offline OP
Member
OP Offline
Member
K
Joined: Oct 2017
Posts: 16
Hi

When I insert into a table all the other windows also have an active commit/rollback - attached a screen-shot.

This needs to indicate the pending transaction only in the window where I did the insert - any ideas?

Regards,
Kenny

Attached Files
commit.png (30.76 KB, 71 downloads)
Last edited by kcl; 01/15/21 12:30 PM.
Re: Commit Rollback on all windows
kcl #62323 01/16/21 10:06 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Can you go to Preferences > Oracle / Connection and check if the "Session Mode" is set to "Multi Session"? Only then will all windows have their own session, and therefore their own transaction.


Marco Kalter
Allround Automations
Re: Commit Rollback on all windows
Marco Kalter #62345 01/26/21 09:18 AM
Joined: Oct 2017
Posts: 16
K
kcl Offline OP
Member
OP Offline
Member
K
Joined: Oct 2017
Posts: 16
Ah, nice!! Thank you Marco - I appreciate it!

Re: Commit Rollback on all windows
Marco Kalter #62370 02/03/21 01:05 PM
Joined: Oct 2017
Posts: 16
K
kcl Offline OP
Member
OP Offline
Member
K
Joined: Oct 2017
Posts: 16
Marco - it seems none of my work on PL-D, for my different sessions is saved when my system crashes - is there any reason for that?

Re: Commit Rollback on all windows
kcl #62371 02/04/21 09:44 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Have you enabled the recovery options (Preferences > Files / Backup)? You need to enable the "Save on execute" and/or "Save on time interval" options.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.049s Queries: 15 (0.009s) Memory: 2.5140 MB (Peak: 3.0408 MB) Data Comp: Off Server Time: 2024-05-19 17:58:10 UTC
Valid HTML 5 and Valid CSS