RE: jdbc: getBinaryStream blocks on second call

What is "is" here, ie: the is.close() line?

-- 
Peter Mount
Enterprise Support Officer, Maidstone Borough Council
Email: petermount@maidstone.gov.uk
WWW: http://www.maidstone.gov.uk
All views expressed within this email are not the views of Maidstone Borough
Council


> -----Original Message-----
> From: Ingo Luetkebohle [mailto:ingo@blank.pages.de]
> Sent: Sunday, December 03, 2000 4:13 PM
> To: pgsql-interfaces@postgresql.org
> Subject: [INTERFACES] jdbc: getBinaryStream blocks on second call
> 
> 
> Hello,
> 
> I'm using the Postgresql-JDBC interface inside of a Jave Server Page
> and request a large object. When the page is first called, it works
> fine. When its called twice for the same database row, the
> ResultSet.getBinaryStream method blocks infinetely. This is on
> postgresql 7.0.3 (from RPM, on Linux, glibc).
> 
> The code is something like:
> 
>     dbc.setAutoCommit(false);
>     Statement st = dbc.createStatement();
>     ResultSet rs = st.executeQuery("SELECT contents FROM 
> file WHERE id=" + id);
>     dbc.commit();
>     if(rs.next()) {
>         Reader r = new InputStreamReader(rs.getBinaryStream(1));
>         char buf[] = new char[2048];
>         for(int read = r.read(buf); read != -1; read = 
> r.read(buf))
>             out.write(buf, 0, read);
> 
>         out.flush();
>         r.close();
>         is.close();
>     }
> 
> (yes, I known that the getBytes method is more convenient but the
> JspWriter class a JSP page provides can't write byte[], only char[])
> 
> -- 
>     Ingo Luetkebohle / ingo@blank.pages.de / 95428014
> /
> |PraxisXML Open Source contact; Computational Linguistics
> |student; Fargonauten.DE sysadmin; Gimp Registry (not-)maintainer;
>