Large Object

From: Andreas Bauer <buki(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Large Object
Date: 2003-09-04 09:44:36
Message-ID: 24776.1062668676@www61.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I don't want to annoy anyone, but I just can't write a large object.
Code:
File file = null;
FileInputStream fis = null;
try{file = new File("c:/testen/test.pdf");
fis = new FileInputStream(file);}catch(Exception e){e.printStackTrace();}
try{
dat.openDB();
dat.db.setAutoCommit(false);
PreparedStatement ps = dat.db.prepareStatement("INSERT INTO blob_test VALUES
(?, ?)");
ps.setString(1, file.getName());
ps.setBinaryStream(2, fis, (int)file.length());
ps.executeUpdate();
System.out.println(ps.toString()); // shows: INSERT INTO blob_test VALUES
('test.pdf, 390368)
ps.close();}catch(Exception e){e.printStackTrace();}
fis.close();

The table looks like this:

CREATE TABLE blob_test (
name varchar(35),
pdf oid
);

Some further questions. How can this funny number in the insert-statement
represent a
binary file? Is it right, that the file lying somewhere on the harddisk can
be written with
this setBinaryStream-command into a db lying on a server?

Thanks in advance for any hint.

Andi

--
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualitätssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Andreas Bauer 2003-09-04 09:54:08 Large Object - Error found
Previous Message Zak McGregor 2003-09-04 02:53:01 Threadsafe from which version?