From: tjm2@mail.ikasths.dk
To: psql <pgsql-interfaces@postgresql.org>
Subject: Re: wrong documentation and others .....
Date: Thu, 5 Oct 2000 13:15:24 +0200
Message-ID: <004f01c02ebd$8f30a380$97bfedd4@pc4151> (raw)
References: <39DC5F29.E9F4023@dif.um.es>
Hi try this:
File file = new File("myimage.gif");
FileInputStream fis = new FileInputStream(file);
byte[] theByteArray = new byte[fis.available()];
fis.read(theByteArray);
PreparedStatement ps = con.prepareStatement("insert insert into images values (?,?)");
ps.setString(1,file.getName());
ps.setBytes(2, theByteArray);
ps.execute();
con.commit();
ps.close();
fis.close();
TJM
----- Original Message -----
From: Gabriel Lopez
To: psql
Sent: Thursday, October 05, 2000 12:59 PM
Subject: [INTERFACES] wrong documentation and others .....
Hi all.
I have several days working with LargeObject and postgres 7.0.2 and I have found many problems. In the first time the postgresql doc is wrong, in chapter 58 of PosgreSQL tutorial (JDBC Interfaces) it repot who to work with Large Object and give code that is wrong:
File file = new File("myimage.gif");
FileInputStream fis = new FileInputStream(file);
PreparedStatement ps = conn.prepareStatement("insert into images values (?,?)");
ps.setString(1,file.getName());
ps.setBinaryStream(2,fis,file.length());
ps.executeUpdate();
ps.close();
fis.close();
PreparedStatement ps = con.prepareStatement("select oid from images where name=?");
ps.setString(1,"myimage.gif");
ResultSet rs = ps.executeQuery();
if(rs!=null) {
while(rs.next()) {
InputStream is = rs.getBinaryInputStream(1);
// use the stream in some way here
is.close();
}
rs.close();
}
ps.close();
InputStream ARE NOT SUPPORTED in JDBC implementation ¡¿?¡ and "getBinaryInputStream()" really is "getBinaryStream()". I think that it is very serious. The other method (that I know) is using LargeObjectAPI, but this fail every 9 times of PreparedStatement of setObject() sentence ¡¡¡ and when use LargeObjectManager as in source examples. (I send other messages to list)
Has PostgreSQL any way to work WELL with LargeObject.?
Please reply me.
Cheers, Gabi.
--
Gabriel López Millán
Facultad de Informática -Universidad de Murcia
30001 Murcia - España (Spain)
Telf: +34-968-364644 E-mail: gabilm@dif.um.es
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tjm2@mail.ikasths.dk
Subject: Re: wrong documentation and others .....
In-Reply-To: <004f01c02ebd$8f30a380$97bfedd4@pc4151>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox