#805 Startup Crash: NullPointerException in AliasFolderState

Core (461)
Dan Lamet

Yesterday I added a new driver, the HXTT driver for MS Access. It worked at first, but when I quit & restarted, Squirrel-SQL wouldn't finish booting up. The splash screen comes up & gets through the progress bar, but when the splash is taken down, the program quits. I opened up the bundle & ran in a command line using the boot shell script. I got the console (see attachment) with the exception at the bottom. This is snipped from that console:

Caused by: java.lang.RuntimeException: java.lang.NullPointerException
at net.sourceforge.squirrel_sql.client.gui.db.JTreeAliasesListImpl.initTree(JTreeAliasesListImpl.java:233)
Caused by: java.lang.NullPointerException
at net.sourceforge.squirrel_sql.client.gui.db.AliasFolderState.applyExpansionAndSelectionToNode(AliasFolderState.java:144)
at net.sourceforge.squirrel_sql.client.gui.db.AliasFolderState.applyExpansionAndSelection(AliasFolderState.java:160)

If I can provide any more information, feel free to contact me at dlamet@yahoo.com.


  • Dan Lamet

    Dan Lamet - 2009-11-11

    Console with exception

  • Julien Terwagne

    Julien Terwagne - 2009-11-19


    I had this bug too.

    I tried uninstall then reinstall without any result.

    The solution I found is to delete your personal squirrel settings folder
    e.g. : C:\Documents and Settings\user\.squirrel-sql

    Then start it again and it should work normally.

  • Rob Manning

    Rob Manning - 2010-02-28

    A better work-around (which does not blow away all of your aliases - just the tree structure) is to remove the file <user.home>/.squirrel-sql/SQLAliases23_treeStructure.xml) and restart. In any case, this issue is addressed in the latest snapshot version as well as in the 3.1 release.

  • Rob Manning

    Rob Manning - 2010-02-28
    • labels: 336290 --> Core
    • milestone: --> 3.0.3
    • status: open --> closed-fixed

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks