0 Replies Latest reply: Jun 26, 2012 11:25 AM by Corvinus RSS

    BLOB data type (or value "null") not supported in the "built-in" SQLite DB?

      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?