RE: input large object from internet - Mailing list pgsql-interfaces

From Peter Mount
Subject RE: input large object from internet
Date
Msg-id 1B3D5E532D18D311861A00600865478CF1B3FE@exchange1.nt.maidstone.gov.uk
Whole thread Raw
In response to input large object from internet  ("S.A.Pamungkas" <moenk_2000@yahoo.com>)
List pgsql-interfaces
The fastpath & large object api's work over the same TCP/IP connection
(which you must be if you are using a servlet), so you can access blobs from
anywhere.

With the applet, you wont be able to access the user's local drive (part of
applet security), but you can using HTTP Post and standard HTML forms.

Peter

-- 
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: S.A.Pamungkas [mailto:moenk_2000@yahoo.com]
Sent: Tuesday, September 19, 2000 3:21 AM
To: pgsql-interfaces@postgresql.org
Subject: [INTERFACES] input large object from internet


Hi all

According imageviewer example, I made GUI ( by
applet-servlet ) for input data to DB, including blob.
Input data from localhost ( the same PC ) is ok. For
example, I could input image data by writing
"/usr/aji/home.gif" in my GUI. 

My question : Is it possible to input blob from other
computer ( from ineternet ) ?
If YES, how to do that ? Which method should I use ?

This is my servlet skeleton code :
............. String image_file  = getImage_file(); // resulting
String "/usr/aji/home.gif".......if(leccod!=null && teacod!=null && date!=null &&
viname!=null && image_file!=null && dept!=null)
{           Statement stat = null;       try   {                 LargeObjectManager lom =
((org.postgresql.Connection)con).getLargeObjectAPI();
     con.setAutoCommit(false);     byte buf[] = new byte[3000];     FileInputStream fis = new FileInputStream(new
 File(image_file));
 
     int oid = lom.create();     LargeObject blob = lom.open(oid);     int s, t=0;
        
 
while((s=fis.read(buf,0,buf.length))>0)  {t += s;blob.write(buf,0)   }   blob.close();
   stat = con.createStatement();   stat.executeUpdate("insert into images values('" +
leccod + "','" + teacod + "','" + date + "','" +
viname + "'," + oid + ",'" + dept + "')");
   con.commit();   con.setAutoCommit(false); ..........

Any suugestion would be appreciate.
Thank you.

-pamungkas-

__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/


pgsql-interfaces by date:

Previous
From: "S.A.Pamungkas"
Date:
Subject: input large object from internet
Next
From: Zeljko Trogrlic
Date:
Subject: Re: input large object from internet