Hello List...
I'm trying to setup a servlet that posts images to a postgres table. Following the example code in the PostgreSQL
7.2.1Documentation (Chapter 8.6. Storing Binary Data) below I get an error:
setBinaryStream(int,java.io.InputStream,int) in java.sql.PreparedStatement cannot be applied to
(int,java.io.FileInputStream,long)
ps.setBinaryStream(4, fis, file.length());
^
Seems there's a mismatch of data types between int and long of InputStream and FileInputStream of java.io? How to cast
oneso it's type is compatible with the other?
Thanks for any suggestions
/j-p.
EXAMPLE CODE
To insert an image, you would use:
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();
-----------------------
JUSTATEST Art Online
www.justatest.com
