Bookmarks not being saved...

[txblackbird]

If I have read the documentation correctly, bookmarks are supposed to be saved with the window / document that they are associated with. When the window / document is re-opened, the bookmarks are supposed to be restored.

This is not happening for me. I set my bookmarks and then save the window / document. The next time it is opened or PL/SQL Dev is restarted, the bookmarks are no longer in place. I have to remake my bookmarks.

Am I mis-reading the documentation or is something wrong?

I am on version 12.0.4.1826 (64-bit) 01.114608.

 

[Marco Kalter]

This applies to Program Windows only, and only if the "Save Window State" option is enabled (Preferences > Program Window).

 

[txblackbird]

Thanks. At least I know that I am not crazy. Can this bookmark saving feature be applied to an SQL window? It would be a real time saver because I have my window broken up into sections for different tasks I need to perform. I use the bookmark feature to keep track of the different tasks. I have a window for each group of tasks rather than having multiple windows open with smaller tasks in each window.

 

[Marco Kalter]

This only works for the Program Window at the moment. I have added this to the list of enhancement requests.

 

[txblackbird]

Thanks. I look forward to seeing this feature in a future release (hopefully...)

 

[Kevin McCabe]

I am able to set/use bookmarks in a SQL window for a file full of queries. I can close the file and then reopen the file and see the bookmarks are remembered and operational. So I thought the functionality in this thread had been implemented.

However, if I close PLSQL Developer and reopen it, the bookmarks are no longer available.

Bug or still unimplemented feature request?

Version 15.0.4.2064 (64 bit)
01.134591 - Unlimited user license
Service Contract: 2022/02/01
Style: Windows 11 Light
Windows 11 Build 22631
en-US(1033)/English (United States)

 

[Marco Kalter]

This seems to work fine for me. Can you go to Preferences > Windows > General and check if the "Save window state" properties are set correctly?

By default the window state will be saved in %APPDATA%\PLSQL Developer 15\PFinfo\files.info. This file has a section for each file or database object you have opened. This section includes information about the bookmarks.

 

[Kevin McCabe]

Thanks for the reply and cool tool!

I have the Save Window state preferences set as you indicated.

After more troubleshooting, I have found that bookmark saving works as expected IF you do not have the named desktop in play where the shortcut looks like this:

"C:\Program Files\PLSQL Developer\plsqldev.exe" desktop=dev1

If I remove the desktop commandline option, bookmarks are working perfectly for SQL scripts.

HOWEVER, I like the desktop option, as with it I am able to quit PLSQL Dev with multiple sql worksheets open (that have never been saved to a file), and the desktop option allows them to be recovered, so I never lose any unsaved queries. The way I do this is to quit the tool using the X, then responding to the Save changes dialog by checking the "do the same..." and then pressing the NO button.

Questions for you:
1. Am I abusing the desktop option for what I want?
2. Can I expect bookmarks to be saved when using the desktop=dev1 methodology?

 

[Marco Kalter]

I would expect that bookmarks are preserved when using the desktop= parameter like you described. We'll investigate and will enhance this.

 

[Kevin McCabe]

For now, I have removed desktop= parameter from my shortcut.

Bookmarks are sticking around as they should.

Today, I encountered a rare crash. Upon restarting, the tool presented me with the recovery options when it started, which I answered with a YES, and the bookmarks disappeared.

While PL/SQL Dev was open I inspected the files.info and saw the bookmark info still in the file, but after I closed PL/SQL Dev, I rechecked files.info and the bookmarks are gone.

Just letting you know as it appears the recovery feature seems to impact the bookmarks negatively like the desktop= feature.