I have table contained BLOB and CLOB fields: Create table string is: private static final String CREATE = "CREATE TABLE ta (" "ta_id INTEGER NOT NULL," "mname VARCHAR( 254 ) NOT NULL," "mvalue INT NOT NULL," "mdate DATE NOT NULL," "bytedata BLOB NOT NULL," "chardata CLOB NOT NULL," "PRIMARY KEY ( ta_id ))"; Then I insert 2000 rows in the table. "; /*create blob and clob arrays*/ int len1 = 10000;//for blob length data int len2 = 15000;//for clob length data byte buf  = new byte Background : In Derby, when a stream is set as a parameter value, the wrapper stream object used for character data is Reader To UTF8Stream and for binary data it is Raw To Binary Format Stream.Then I update all 2000 rows by command: private static final String UPDATE = "UPDATE ta " "SET bytedata=? Both these stream objects on read() return data in a format that is used to store the respective datatype value.
For the subsequent rows, the read from the stream parameter value returns -1 and thus is updated with incorrect data.
When retrieving the row back, the format of the fields is incorrect and thus the exception. adds changes to Raw To Binary Format Stream and Reader To UTF8Stream to throw an EOFException if stream is re-read.
FUND_DATA_ID) JOIN $UNION_MBR_LEDGER ON ($DUES_INV_DED. Explanation The indicated literal begins with a digit but is not a valid integer, decimal, or floating point literal. Federated system users, if the error occurred in a pass-through session, determine what data source is causing the error (see the Troubleshooting Guide for the failing data sources).
Federated system users: a data source-specific literal representation error has occurred in apass-through session. Examine the SQL dialect for that data source to determine which literal representation rule has been violated, and adjust the failing statement as needed.
If a stream is re-read, it returns a -1 which is incorrect data.