RE: input large object from internet

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(at)maidstone(dot)gov(dot)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(at)yahoo(dot)com]
Sent: Tuesday, September 19, 2000 3:21 AM
To: pgsql-interfaces(at)postgresql(dot)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/