SQLException: ERROR: oidin: when loading GIF file

Hi

Has anyone run into difficulties uploading a blob to postgres?

I am unable to load an image file into postgres using the jdbc7.1-1.3.jar driver.

Application server runs on NT, Postgres on Linux 7.1

Error received:

java.sql.SQLException: ERROR: oidin: error in "GIF89a1.....

Code:

Class.forName("org.postgresql.Driver");
Connection conn = DriverManager.getConnection("jdbc:postgresql://192.168.0.50:5432/ezweb","administrator","password");
File file = new File("d:/Temp/testimage.gif");
FileInputStream fis = new FileInputStream(file);

PreparedStatement ps = conn.prepareStatement("INSERT INTO IMAGES VALUES (?, ?)");
ps.setString(1, file.getName());

Long length = new Long(file.length());
ps.setBinaryStream(2, fis,length.intValue());
ps.executeUpdate();
ps.close();
fis.close();

Any pointers to what "oiden" refers to would be much appreciated.

______________________________

Craig Jarman
Source IT
Ph: 612 9974 1480
Fx: 612 9974 1280
cjarman(at)source(dot)com(dot)au
______________________________