Thread: setBinary getBinary not the same
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();
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");
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
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
-----Ursprüngliche Nachricht-----
Von: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] Im Auftrag von Dirk Bromberg
Gesendet: Dienstag, 4. März 2003 20:34
An: pgsql-jdbc@postgresql.org
Betreff: [JDBC] setBinary getBinary not the sameHi,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: 2501What is going on there ?greetsDirk Bromberg