Re: setBinary getBinary not the same

Поиск
Список
Период
Сортировка
От Dirk Bromberg
Тема Re: setBinary getBinary not the same
Дата
Msg-id 000a01c2e345$0c2a69f0$24ddfea9@xbserv
обсуждение исходный текст
Ответ на setBinary getBinary not the same  ("Dirk Bromberg" <bromberg@tzi.de>)
Список pgsql-jdbc
Дерево обсуждения
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 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();
 
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 по дате отправления: