Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
ADF Mobile Preview
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jun 26, 2012 11:25 AM by
BLOB data type (or value "null") not supported in the "built-in" SQLite DB?
Jun 26, 2012 11:25 AM
Hello there - in the DB table (the content of which is queried by a service class) there is also a column of type BLOB. The values of this column are set to "null" in the SQL script that creates the tables.
Then, the following Java line
Blob goodsitemPhoto = rs.getBlob("GOODSITEM_PHOTO")
is raising an SQLException "not supported". (rs is the ResultSet object obtained by executing a prepared statement created on the DB connection).
The other "getter" commands on the rs work well (rs.getInt(...), rs.getString(...))
Might the BLOB type be unsupported?
This content has been marked as final.
Show 0 replies