Subject RE: [Firebird-Java] Jaybird RC3 BLOB problems
Author Ryan Baldwin

There was a serious bug in RC3 that caused a few different types of
symptoms. This might be another manifestation of that bug(s?). Its
possible(quite likley) that using the latest version from CVS will solve
this for you.


-----Original Message-----
From: Andrew Guts [mailto:andr@...]
Sent: 25 April 2003 08:17
Subject: [Firebird-Java] Jaybird RC3 BLOB problems


Help me please.
The code below works perfect with RC2, but fails with JBird driver RC3.
What is wrong with it?

private InputStream getImg(int id, boolean thumb, Connection conn)
throws SQLException, IOException, BusinessException
String sql = "select Picture from pJpegs where WareID = ?";
if (thumb)
sql = "select Thumb from pJpegs where WareID = ? and thumb_width
= "+Integer.toString(width);
PreparedStatement st = conn.prepareStatement(sql);
try {
st.setInt(1, id);
ResultSet rs = st.executeQuery();
if ((rs == null) || ! {
log("pJpegs: empty resultset"); // I can see this message in
log file with RC3 driver, not RC2
if (thumb) return null;
else throw new BusinessException("No picture avaliable for
Blob j = rs.getBlob(1);
if (j == null) { log("null blob"); return null; }
return j.getBinaryStream();
finally { st.close(); }



To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to