Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

NullPointerException:null

Help
David
2012-03-06
2013-04-29
  • David
    David
    2012-03-06

    Hi,

    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?

    Thanks,
    David

     
  • 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 net.sourceforge.sqlexplorer.patch.feature.group SQL Explorer Project (eclipsesql.sourceforge.net)
      Eclipse SQL Explorer 3.6.1.v20110906_SR4 net.sourceforge.sqlexplorer.feature.group SQL Explorer Project (eclipsesql.sourceforge.net)

    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 net.sourceforge.sqlexplorer.feature.group SQL Explorer Project (eclipsesql.sourceforge.net)

    Thanks!

     
  • 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
    java.lang.NullPointerException
            at net.sourceforge.sqlexplorer.dataset.DataSet.loadCellValue(DataSet.java:573)
            at net.sourceforge.sqlexplorer.dataset.DataSet.loadRows(DataSet.java:428)
            at net.sourceforge.sqlexplorer.dataset.DataSet.initialize(DataSet.java:286)
            at net.sourceforge.sqlexplorer.dataset.DataSet.<init>(DataSet.java:125)
            at net.sourceforge.sqlexplorer.dbproduct.ExecutionResultImpl.createDataSet(ExecutionResultImpl.java:111)
            at net.sourceforge.sqlexplorer.dbproduct.ExecutionResultImpl.nextDataSet(ExecutionResultImpl.java:137)
            at net.sourceforge.sqlexplorer.sqlpanel.SQLExecution.doExecution(SQLExecution.java:234)
            at net.sourceforge.sqlexplorer.sqlpanel.AbstractSQLExecution.run(AbstractSQLExecution.java:116)
            at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

     
  • 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:

    http://eclipsesql.sourceforge.net

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