input large object from internet
От | S.A.Pamungkas |
---|---|
Тема | input large object from internet |
Дата | |
Msg-id | 20000919022033.11992.qmail@web4904.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: input large object from internet
|
Список | pgsql-interfaces |
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 по дате отправления: