Sqlite Database Returns The Error Code java.lang.NullPointerException With BLOB Columns (Doc ID 1477898.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Lite - Version 10.3.0.3.0 to 10.3.0.3.0 [Release 10.3]
Information in this document applies to any platform.

Symptoms

 In using 2.2 Android device with SQLITE database wiith BLOBs datas it fails with the exception:

Exception:
java.lang.NullPointerException
at oracle.opensync.ose.OpcodeProcessor.processBeginBlob(Unknown Source)
at oracle.opensync.ose.OpcodeReader.handleRecord(Unknown Source)
at oracle.opensync.ose.OpcodeReader.doRecord(Unknown Source)
at oracle.opensync.ose.OpcodeReader.run(Unknown Source)
at oracle.opensync.ose.Engine.sync(Unknown Source)
at oracle.opensync.ose.OSESession.sync(Unknown Source)
at tests.sync.MainAct.run(MainAct.java:261)
at java.lang.Thread.run(Thread.java:1096)

Into the LogCat log :

I/Database(5134): sqlite returned: error code = 17, msg = prepared statement aborts at 17: [INSERT INTO OSE$TABLES VALUES(?, ?, ?, ?, ?, ?, ?, ?)]

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms