setBinary getBinary not the same - Mailing list pgsql-jdbc

From Dirk Bromberg
Subject setBinary getBinary not the same
Date
Msg-id 001101c2e285$01506950$24ddfea9@xbserv
Whole thread Raw
Responses Re: setBinary getBinary not the same
List pgsql-jdbc
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
 

pgsql-jdbc by date:

Previous
From: Joe Howes
Date:
Subject: Tips for PostgreSQL and Sun ONE Application Server
Next
From: "Dirk Bromberg"
Date:
Subject: Re: Testcase for bytea datatype