Blob's that worked in 7.1 fail in 7.2.1
От | Michael Andreasen |
---|---|
Тема | Blob's that worked in 7.1 fail in 7.2.1 |
Дата | |
Msg-id | 3D7CCC0F.70707@dunlops.com обсуждение исходный текст |
Список | pgsql-jdbc |
I have just upgrading my database to 7.2.1 (I was on 7.1.3) There are some little funnies between the two versions, mostly things that have been tightened up in 7.2.1. However, I have found the this code that used to work now fails. It is code for writting a blob (image) back into the database. File file = new File(imageFileName); FileInputStream fis = new FileInputStream(file); int length = (int)file.length(); pStmt.setBinaryStream(1, fis, length); pStmt.setInt(2, currentEmployee); int upd = pStmt.executeUpdate(); It now fails with this.... java.sql.SQLException: ERROR: oidin: error in "~DGR:LOGO,09180,054,000000000000000......... can't parse "~DGR:LOGO,09180,054,000000000000000........ etc, etc .... at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94) at org.postgresql.Connection.ExecSQL(Connection.java:398) at org.postgresql.jdbc2.Statement.execute(Statement.java:130) at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73) at org.postgresql.jdbc2.PreparedStatement.executeUpdate(PreparedStatement.java:113) at com.dunlops.warehouse.checking.SetCustomerLogo.saveLogo(SetCustomerLogo.java:124) What's wrong?
В списке pgsql-jdbc по дате отправления: