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@source.com.au
______________________________