• David

    David - 2012-03-06


    I've been using SQL Explorer for a while without any problems and generally love it, however recently I have started to get the strange problem detailed below. Clearly there is a work around, but it is annoying.

    If I execute the following SQL statement in SQL Explorer SQL Editor:

    select * from popular_campaigns;

    I get an error dialog popup with the title "Error Executing SQL" and the message is "java.lang.NullPointerException:null".

    However if I execute any of the following:

    select * from `popular_campaigns`;

    select * from test1.popular_campaigns;

    select id from popular_campaigns;

    The query is successful and results are displayed.

    I am running the 64 bit version of 3.6.1.v20111007_SR4_P1, the System Info tab reports the Java version as 1.6.0_26-b03.

    Any ideas anyone?


  • Heiko Hilbert

    Heiko Hilbert - 2012-03-06

    Can you check your .metadata/.log for a stack trace of this exception.

  • Eric Werk

    Eric Werk - 2012-04-11

    I have experienced the same problem.
    Database: Oracle XE, driver: oracle.jdbc.driver.OracleDriver
    Eslipse: 3.7.2.v20120207…
    Version of SQL Explorer:

      Eclipse SQL Explorer 3.6.1.v20111007_SR4_P1 SQL Explorer Project (
      Eclipse SQL Explorer 3.6.1.v20110906_SR4 SQL Explorer Project (

    There is no trace of the exception in .metadata/.log

    Could not reproduce the error in the standalone client, version 3.6.1.v20101117

  • Eric Werk

    Eric Werk - 2012-04-12

    Seems to be fixed with version:
    Eclipse SQL Explorer 3.6.1.v20120412_SR5 SQL Explorer Project (


  • Heiko Hilbert

    Heiko Hilbert - 2012-04-12

    Hopefully. We did some changes but this NPE occured randomly. With this release all exception will be logged. If this error will occure again we would have a stacktrace to better find out what the real reason for this error is.

  • cardonbj

    cardonbj - 2012-04-12

    I'm getting this same error using jTDS in the just-released-today 3.6.1.

  • cardonbj

    cardonbj - 2012-04-12

    Here is the exception that is being thrown. I cannot run any query no matter how it is formatted….

    !ENTRY net.sourceforge.sqlexplorer 4 4 2012-04-12 15:17:11.889
    !MESSAGE Error executing.
    !STACK 0
            at net.sourceforge.sqlexplorer.dataset.DataSet.loadCellValue(
            at net.sourceforge.sqlexplorer.dataset.DataSet.loadRows(
            at net.sourceforge.sqlexplorer.dataset.DataSet.initialize(
            at net.sourceforge.sqlexplorer.dataset.DataSet.<init>(
            at net.sourceforge.sqlexplorer.dbproduct.ExecutionResultImpl.createDataSet(
            at net.sourceforge.sqlexplorer.dbproduct.ExecutionResultImpl.nextDataSet(
            at net.sourceforge.sqlexplorer.sqlpanel.SQLExecution.doExecution(

  • Heiko Hilbert

    Heiko Hilbert - 2012-04-13

    This is a new Bug. It comes allways if you select large text columns (CLOB, TEXT, LONGVARCHAR) which have null values.
    A workaround until I have released the patch is to use ifnull on this columns to convert nulls into empty string.

  • Heiko Hilbert

    Heiko Hilbert - 2012-04-13

    Patch SR5 P1 is now available via update site.

  • Rick Otten

    Rick Otten - 2012-04-19

    I've looked around and can't find the suggested patch.  Can you post a link to it?

  • Heiko Hilbert

    Heiko Hilbert - 2012-04-20

    The patch is available via update site:

    In eclipse go to Help/Install New Software… Select the SQL Exporer Update Site or 'Add…' the URL above.


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

Sign up for the SourceForge newsletter:

No, thanks