Thread: JDBC and BLOB in Postgres
Hi, I'm trying Blob with JDBC Driver jdbc7.0-1.2 on postgresql 7.0.2 (Mandrake 7.1) follwing the example given in paragraph "Using Large Objects" Chapter 58. JDBC Interface. the getBinaryStream seems ok provided the blob is in the database, while the setBinaryStream method call returns : Error : InputStream as parameter not supported Did I miss something ? Thanks in advance. The Code I'm using: File file = new File("Blob.class"); FileInputStream fis = new FileInputStream(file); cx.setAutoCommit(false); ps = cx.prepareStatement("insert into mytable (myid, myblob) values (1, ?)"); ps.setBinaryStream(1, fis, (int) file.length()); ps.executeUpdate(); ps.close(); fis.close(); cx.commit();
On Fri, 6 Oct 2000, Didier Boudigue wrote: > Hi, > > I'm trying Blob with JDBC Driver jdbc7.0-1.2 on postgresql 7.0.2 > (Mandrake 7.1) follwing the example given in paragraph "Using Large > Objects" Chapter 58. JDBC Interface. > > the getBinaryStream seems ok provided the blob is in the database, > while the setBinaryStream method call returns : > > Error : InputStream as parameter not supported > > Did I miss something ? No. getBinaryStream() currently reads the entire blob into a ByteArrayInputStream, which is what it then returns. setBinaryStream() is in 7.1 Some alternatives are in the ImageViewer example. Peter -- Peter T Mount peter@retep.org.uk http://www.retep.org.uk PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ Java PDF Generator http://www.retep.org.uk/pdf/
On Fri, 6 Oct 2000, Didier Boudigue wrote: > Hi, > > I'm trying Blob with JDBC Driver jdbc7.0-1.2 on postgresql 7.0.2 > (Mandrake 7.1) follwing the example given in paragraph "Using Large > Objects" Chapter 58. JDBC Interface. > > the getBinaryStream seems ok provided the blob is in the database, > while the setBinaryStream method call returns : > > Error : InputStream as parameter not supported > > Did I miss something ? No. getBinaryStream() currently reads the entire blob into a ByteArrayInputStream, which is what it then returns. setBinaryStream() is in 7.1 Some alternatives are in the ImageViewer example. Peter -- Peter T Mount peter@retep.org.uk http://www.retep.org.uk PostgreSQL JDBC Driver http://www.retep.org.uk/postgres/ Java PDF Generator http://www.retep.org.uk/pdf/