Insertion and Retrieval of BLOB

From: Som <shekhar(at)easi(dot)soft(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Insertion and Retrieval of BLOB
Date: 2001-01-25 04:50:27
Message-ID: 3A6FB093.27AA747@easi.soft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi Everybody,
<br>There are two methods we can insert and retrieve image from db.
<br>One is by JDBC way , another is by Postgres extensions.
<p>I have problem with both while implementing.
<br>If im trying to retrieve the image (which is stored in OID type) by
Postgres extensions,
<p>Ex: using LargeObjectManager lobj;
<br>LargeObject&nbsp; lobj.open(OID);
<br>Exception&nbsp;&nbsp;&nbsp; :<b>Fast path protocol error: Z</b>
<p>If im trying insert image by&nbsp; JDBC way i.e&nbsp; by getBinaryStream()a
and setBinaryStreams() methods of PreparedStatement
<br>Im getting Exception saying :
<br>Exception : <b>InputStream parameter is not supported.</b>
<p>any idea ?
<p>--
<br>&nbsp;Som
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<br>&nbsp;
<p>--
<br>&nbsp;</html>

Attachment Content-Type Size
unknown_filename text/html 895 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-25 04:53:29 Re: Rule not invoked in 7.1
Previous Message Ian Harding 2001-01-25 03:55:27 Re: #DELETED error when using Access 2000 as frontend