| 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: | Whole Thread | Raw Message | 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
| 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? |