Insertion and Retrieval of BLOB - Mailing list pgsql-sql

From Som
Subject Insertion and Retrieval of BLOB
Date
Msg-id 3A6FB093.27AA747@easi.soft.net
Whole thread Raw
List pgsql-sql
Hi Everybody, <br />There are two methods we can insert and retrieve image from db. <br />One is by JDBC way , another
isby Postgres extensions. <p>I have problem with both while implementing. <br />If im trying to retrieve the image
(whichis stored in OID type) by Postgres extensions, <p>Ex: using LargeObjectManager lobj; <br />LargeObject 
lobj.open(OID);<br />Exception    :<b>Fast path protocol error: Z</b><p>If im trying insert image by  JDBC way i.e  by
getBinaryStream()aand setBinaryStreams() methods of PreparedStatement <br />Im getting Exception saying : <br
/>Exception: <b>InputStream parameter is not supported.</b><p>any idea ? <p>-- <br /> Som <br />  <br />  <br />  <br
/> <br />  <br />  <br />  <br />  <br />  <br />  <p>-- <br />  

pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Re: Problem with Dates
Next
From: Tom Lane
Date:
Subject: Re: Rule not invoked in 7.1