Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f119AMq39378 for ; Thu, 1 Feb 2001 04:10:22 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f11995D39223; Thu, 1 Feb 2001 04:09:05 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: shekhar@easi.soft.net, Som Subject: Re: Image insertion by using BLOB Message-ID: <981018545.3a7927b14ddcf@webmail.retep.org.uk> Date: Thu, 01 Feb 2001 04:09:05 -0500 (EST) From: Peter T Mount Cc: Queries References: <3A77F4EA.A3BC14A8@easi.soft.net> In-Reply-To: <3A77F4EA.A3BC14A8@easi.soft.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200102/2 X-Sequence-Number: 1170 Quoting Som : > Hi ALL, > I am trying to insert the image from the client to database by > spicifying the Windows NT machine filepath. > The server(postgresql 7.0) is situated at the linux. > If filepath is linux m/c's then i can ... > If filepath is winNT then i have Exception saying : > > ERROR: lo_import : ca't open unix file "/jigsaw/jigsaw/www/som.gif " > No such file or directory > > Query is as follows:: > insert into tablename values('som', lo_import('PATH')); lo_import only works on the servers filesystem. > > If possible , how ? You need to use the fastpath/largeobject api's to send the image over the network connection. There's 2 C & 1 Java examples included in the source showing this. Peter > > > -som > > > > > > > > > > > > > -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/