Date: Sun, 3 Dec 2000 17:13:02 +0100
From: Ingo Luetkebohle <ingo@blank.pages.de>
To: pgsql-interfaces@postgresql.org
Subject: jdbc: getBinaryStream blocks on second call
Message-ID: <20001203171302.B1619@blank.pages.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
Organization: Maybe when I grow up

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;