SQLWorkbench/J not starting

[Herbert Schulz]

Hello,

when I click on the SQLWorkbench64 icon to start the program, the hourglass is shown for 2 seconds and after that nothing happens. It was working until yesterday

When I start via Windows command line I get the following error:

java.lang.ExceptionInInitializerError
        at workbench.resource.Settings.getInstance(Settings.java:241)
        at workbench.WbManager.readParameters(WbManager.java:790)
        at workbench.console.SQLConsole.main(SQLConsole.java:649)
Caused by: java.lang.StringIndexOutOfBoundsException: Index 0 out of bounds for length 0
        at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:55)
        at java.base/jdk.internal.util.Preconditions$1.apply(Preconditions.java:52)
        at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:213)
        at java.base/jdk.internal.util.Preconditions$4.apply(Preconditions.java:210)
        at java.base/jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:98)
        at java.base/jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java:106)
        at java.base/jdk.internal.util.Preconditions.checkIndex(Preconditions.java:302)
        at java.base/java.lang.String.checkIndex(String.java:4570)
        at java.base/java.lang.StringLatin1.charAt(StringLatin1.java:46)
        at java.base/java.lang.String.charAt(String.java:1527)
        at workbench.util.WbProperties.addPropertyDefinition(WbProperties.java:428)
        at workbench.util.WbProperties.loadFromReader(WbProperties.java:525)
        at workbench.util.WbProperties.loadFromStream(WbProperties.java:472)
        at workbench.resource.Settings.loadConfig(Settings.java:518)
        at workbench.resource.Settings.initialize(Settings.java:328)
        at workbench.resource.Settings.<init>(Settings.java:246)
        at workbench.resource.Settings$LazyInstanceHolder.<clinit>(Settings.java:236)

I tried reinstalling SQLWorkbench/J and Open-JDK but with no success.

How can I solve the problem?

[Thomas Kellerer]

Hmm,

it looks like there is a problem with the content of workbench.settings

Can you send me that file to the support email address please?

Regards
Thomas

[Herbert Schulz]

Thx. Some of the settings files were corrupt (Many null bytes). Maybe the result of a Windows crash.

I deleted teh corrupted files and created new ones. Problem solved.

[Thomas Kellerer]

Good to hear that.

Note that you can automatically make backups of important files (workspaces, connection profiles, settings).

This can be configured through Tools -> Options -> Backups

Thomas

[Herbert Schulz]

Thx for the info. BTW: SQLWorkbench/J is the best database tool that I have ever used! I use it for over 15 years now.