ANNOUNCEMENT: community.oracle.com is currently Read only due to planned maintenance until 02:30 AM PST, 28-March-2015. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
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
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 9:25 AM by
BLOB data type (or value "null") not supported in the "built-in" SQLite DB?
Jun 26, 2012 9: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