#1053 Null pointer exception exporting BLOBs

3.4.0
open
Rob Manning
5
2013-10-24
2012-10-11
Anonymous
No

It is not possible to create "data scripts" for tables which have attributes that are BLOBs and are null.
If the exporting process encounter such a row it aborts the process with a null pointer exception.
Happend while trying to export such a table on a Oracle 10 XE database.

Discussion

  • Jonathan
    Jonathan
    2013-10-24

    Same problem on H2...

    2013-10-24 14:36:07,468 [Thread-6] ERROR net.sourceforge.squirrel_sql.client.session.MessagePanel  - privateShowMessage: Exception was null
    java.lang.NullPointerException
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand.genInserts(CreateDataScriptCommand.java:398)
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand$1.run(CreateDataScriptCommand.java:132)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:662)
    2013-10-24 14:36:51,849 [Thread-6] ERROR net.sourceforge.squirrel_sql.client.session.MessagePanel  - privateShowMessage: Exception was null
    java.lang.NullPointerException
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand.genInserts(CreateDataScriptCommand.java:398)
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand$1.run(CreateDataScriptCommand.java:132)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:662)
    2013-10-24 14:39:46,257 [Thread-6] ERROR net.sourceforge.squirrel_sql.client.session.MessagePanel  - privateShowMessage: Exception was null
    java.lang.NullPointerException
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand.genInserts(CreateDataScriptCommand.java:398)
        at net.sourceforge.squirrel_sql.plugins.sqlscript.table_script.CreateDataScriptCommand$1.run(CreateDataScriptCommand.java:132)
        at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
        at java.lang.Thread.run(Thread.java:662)