Retrieving multiple BLOBs in mySql

[Arie Fishler]

Hi,

I am having problems retrieving multiple BLOBs using a SELECT statement. when the result of the select is more than a single row, there is no BLOB returned from the Resultset. The same code has no problems retrieving the BLOB when the ResultSet contains a single row only.

Also, is it true that in any case, even if the ResultSet contains more than a single row, the actual action when retrieving the BLOBs would be to access the DB for every BLOB separately. Thia means that if I have 5 rows, I will get 5 DB access times instead of a single access compared to a regular SELECT that retireves multiple rows with no BLOBs.

The code I am using to retrieve the BLOB from the ResultSet:

Blob wrapBlob = rs.getBlob(PRICE_WRAP);
if (wrapBlob != null) {
try {
InputStream is = wrapBlob.getBinaryStream();
ObjectInputStream objInputStream = new ObjectInputStream(is);
wrap = (PriceWrap)objInputStream.readObject();
}
catch (Exception e) {
Monitor.log(SearchDb.SEARCH_DB, Monitor.ERROR, e);
}
}