PLS Recovery Files

[The Cleaner]

Ok, I know there is a better way to pickup where you left off without saving all of your files then doing the old CTRL-ALT-DELETE and killing the program trick. But I've been doing that for so long its like second nature now. I've also written a short cmd file to back up the recovery files so I don't lose anything.

(echo *** Saving PL/SQL Developer Windows ***
"C:\Program Files\Tools\WinRAR\rar" a -m5 -ag -x*.cmd -x*.rar "pls-recovery-" ./*) - this produces files like pls-recovery-20060620114204.rar

My problem is this, for whatever reason, PL/SQL developer sometimes refuses to come up with the recovery window at startup and I am unable to load my windows. I've searched the registry and configuration files, but I cannot seem to find what causes them to load.

I have to tell you that it would be incredible to have a simple menu item that says exit and save progress. When you start up a box that says continue y/n. I know it sounds stupid, but at any given point I have around 95 windows open. I guess this is the equivalent of having a messy desk.. I dunno.. its how I work.

So can someone school me on the proper way to accomplish what I'm doing. Secondly, can someone please tell me how to force the load of the recovery I already have sitting out there!

Thanks !!!

 

[rbrooker]

95 windows?!?

 

[Marco Kalter]

I have found a possible cause for this, and we will improve on this in the next release (7.0.3).

 

[The Cleaner]

Oh no, I'm using Windows XP professional. Thanks a bunch Marco, I definitely appreciate it. This is one of those things where if I had my work organized, there wouldn't be an issue. But there is that situation where you have clutter and you simply have to leave. Ok strangely enough, four days later, my desktop just loaded all those windows.

Thanks again!

 

[The Cleaner]

I'm glad I posted my rar command here. Because for whatever reason, the program deleted everything in my PLS-Recovery directory. The batch file, all of my archives, everything.

I am officially giving up on the auto-recovery feature.

 

[Marco Kalter]

In 7.0.3 you can use the new Desktop=[Name] command-line parameter. This will save and restore the PL/SQL Developer desktop the same way as the recovery function does.

 

[Stew Stryker]

Originally posted by The Cleaner:
Ok, I know there is a better way to pickup where you left off without saving all of your files then doing the old CTRL-ALT-DELETE and killing the program trick. But I've been doing that for so long its like second nature now.

Dude that's just NASTY!!!

Why would you ever expect a program to recover nicely after you did that to it???

That's like walking out on a date in the middle of dinner because you just figured out how to recode your pipe stream to be faster and you had to do it right now and then expecting her to take your calls the next morning!



LOL

 

[The Cleaner]

Hi Stew,

Yes, I agree it is nasty. This is a well known workaround from previous versions. And, yes I do expect the program to recover after that. That is precisely what the recovery function is for. Its a great feature that works most of the time. Prior to what Marco has just told me in V7.0.3, that was the only way to invoke it (that I knew of) short of an actual crash.

Granted, I shouldn't rely on it on a daily basis, but I can't let my own disorganization slow me down.

Marco, thanks so much for the info, I was just frustrated yesterday..

As far as dates go, I'll stay for dinner, but if she asks me to brush the poptarts out of my beard she is history. (very vague Simpsons reference)

 

[The Cleaner]

Oh wow, that command line parameter worked GREAT! Thank you very, very much !!!

 

[William Robertson]

Another wow from me. That is very awesome. I'd seen the "desktop=" option on the new features list but hadn't quite realised what it did.

 

[Stew Stryker]

William, am I missing something here? My PSD desktop layout restores every time. Clearly you must be talking about something else?

Thanks for the clue, I could use one!

 

[William Robertson]

Aha, but try this:

• Edit the PL/SQL Dev desktop shortcut adding "desktop=bananas", and restart the application (I don't think it matters what label you use unless it is a shared network installation.)
• Open a new SQL window (for example) and enter some text.
• Suddenly realise you have to catch a train and must leave in a hurry.
• Quit PL/SQL Developer, answering 'No' when it prompts you to "Save changes to SQL Window - New?"
• Start up PL/SQL Developer again.

Notice anything different?

 

[Stew Stryker]

"Notice anything?"

Yes, if I turn off the "Save desktop setting" option, it didn't save my desktop setting change, as I'd expect.

What's the big deal?

Could you please assume I'm a clueless dolt who doesn't have time to check out non-obvious options that other people find cool, and tell me what I should be seeing?

Thanks,

 

[William Robertson]

> Yes, if I turn off the "Save desktop setting" option, it didn't save my desktop setting change, as I'd expect.

Was that one of the steps I listed?

The new feature restores new windows that you didn't save, similar to the familiar technique off killing PL/SQL Dev from Task Manager in order to be able to log off and still restore the entire session in the morning.

 

[William Robertson]

This option doesn't seem to be listed in the online help. I just started at a new site and I couldn't remember how you did this until I found this thread.