Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
PL/SQL Developer
Commit Rollback on all windows
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
Commit Rollback on all windows
#62322
01/15/21
10:52 AM
Joined:
Oct 2017
Posts: 16
K
kcl
OP
Member
OP
kcl
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
.
Copy Link to Clipboard
Re: Commit Rollback on all windows
kcl
#62323
01/16/21
10:06 AM
Joined:
Aug 1999
Posts: 22,220
Marco Kalter
Member
Marco Kalter
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
Copy Link to Clipboard
Re: Commit Rollback on all windows
Marco Kalter
#62345
01/26/21
09:18 AM
Joined:
Oct 2017
Posts: 16
K
kcl
OP
Member
OP
kcl
Member
K
Joined:
Oct 2017
Posts: 16
Ah, nice!! Thank you Marco - I appreciate it!
Copy Link to Clipboard
Re: Commit Rollback on all windows
Marco Kalter
#62370
02/03/21
01:05 PM
Joined:
Oct 2017
Posts: 16
K
kcl
OP
Member
OP
kcl
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?
Copy Link to Clipboard
Re: Commit Rollback on all windows
kcl
#62371
02/04/21
09:44 AM
Joined:
Aug 1999
Posts: 22,220
Marco Kalter
Member
Marco Kalter
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
Copy Link to Clipboard
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
Plyxon Alpha / Beta
PL/SQL Developer 15.0 Beta
Print Thread
Switch to Threaded Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
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