Ok,
the error must be at retrieving the bytes from the db.
if i insert and retrieve byte[]s with the pg72 jar ist works.
and if i insert byte[]s with pg73 and retrieve with 72 it works.
and if i insert byte[]s with pg72 and retrive with 73 it doesn't work.
any ideas ?
Dirk Bromberg
Hi,
i've same problem like Uwe.
table is :
ico_binary(int4, bytea)
when i use to store:
PreparedStatement addico = con.prepareStatement("INSERT INTO ico_binary (id, bin) VALUES (?,?)");
addico.setInt(1, icoID);
addico.setBytes(2, ico_bytes);
addico.executeUpdate();
addico.close();
and then retrive:
Statement getico = con.createStatement();
ResultSet res = getico.executeQuery("select id, bin from ico_binary where id="+IcoId);
if(!res.next()){
throw new IcoNotFoundException("can't find ico with id: "+IcoId);
}else{
byte[] ico_bytes = res.getBytes("bin");
The Problem :
the ico_bytes.lenght before: 2435 and after: 2501
What is going on there ?
greets
Dirk Bromberg