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.
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?
Can you check your .metadata/.log for a stack trace of this exception.
I have experienced the same problem.
Database: Oracle XE, driver: oracle.jdbc.driver.OracleDriver
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
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)
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.
I'm getting this same error using jTDS in the just-released-today 3.6.1.
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.
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.
Patch SR5 P1 is now available via update site.
I've looked around and can't find the suggested patch. Can you post a link to it?
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.