Large Object
От | Andreas Bauer |
---|---|
Тема | Large Object |
Дата | |
Msg-id | 24776.1062668676@www61.gmx.net обсуждение исходный текст |
Ответы |
Re: Large Object
Re: Large Object |
Список | 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
В списке pgsql-jdbc по дате отправления: