EA 2 stopped reopening worksheets on startup

Tools > Preferences > Database > Worksheet > "Open a Worksheet on connect" ?

Hi Jeff,

and No Jeff, the issue means REopen worksheet(s) from the latest session, which were opened before closing SQL Developer..

I have the same issue and it looks like there is another thread for the same issue SQL Developer version 4 EA2 does not re-open tabs

Got it - thanks for the clarifying. Will look to get a definitive answer for this in the original thread.

Sounds like something with your install is borked. That should only happen once. I'd put down a fresh copy of SQLDev and migrate the settings over from your older install.

On Windows 7, the default SQL Developer settings for all versions should be under C:\Users\<your_user>\AppData\Roaming\SQL Developer.  Settings specific to each release are found in child directories like system4.0.0.12.84 (for EA2).  Finally, recently open files are referenced in a couple of places:

1. preferences.xml  (under o.ide<JDev_version>)

2. product-preferences.xml (under o.sqldeveloper<SQLDev_version>)

The top-level directory for the settings varies by O/S.  You can override it by adding this to sqldeveloper.conf (or sqldeveloper-Darwin.conf on Mac OS):

AddVMOption -Dide.user.dir=<path_to_desired_writable_SQL_Developer_directory>

Perhaps the issue you face with repeated settings migration involves that directory not being writable.  Maybe some administrative restriction at your work?

Anyway, let's hope the original issue of not reopening those files gets tracked down soon. By not migrating settings, I found I can get the reopen to work the next time, but not thereafter.  The file does seem to remain in the File -> Reopen list, however.

Regards,
Gary

SQL Developer Team

I have this same issue, and I also see the "Migrating user settings" message each time I start SQL Developer.  I was able to find the top-level directory on OSX (~/.sqldeveloper/system4.0.0.12.84/o.sqldeveloper.12.2.0.12.84/) for EA2.  The two files mentioned are writeable by my user.  I even confirmed the timestamp on those two files changes when I open and close SQL Developer.

However, I am questioning whether my install procedure was correct.  I followed the instructions here:

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-install-mac-1969675.html

Is that enough?  I believe on top of those instructions, I also trashed my SQLDeveloper.app folder/file, but did not do anything with the hidden ~/.sqldeveloper/ folder, which I learned about today.

Hi guys,

It looks like the issue was fixed (at least for me) in the latest (production) release 4.0.0.13.80.

Thansk Jeff for your hard work. That's really nice tool.