NullPointerException:null

[David]

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]

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

[Eric Werk]

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]

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]

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]

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

[cardonbj]

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]

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]

Patch SR5 P1 is now available via update site.

[Rick Otten]

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

[Heiko Hilbert]

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.