problem with getBytes - Mailing list pgsql-interfaces

From Rafal Piotrowski (CSCS)
Subject problem with getBytes
Date
Msg-id 383986FD.A7C87D1F@CSCS.CH
Whole thread Raw
Responses Re: [INTERFACES] problem with getBytes  (Peter Mount <peter@retep.org.uk>)
List pgsql-interfaces
Hi,

Configuration:
- PostgreSQL 6.5.1
- JDBC for JDK 1.2

Problem:

I have a table which looks like this:
-------+-----------+---------------+---------------+--------------+------------
id:int | name:text | language:text | filename:text | comment:text |
content:oid
-------+-----------+---------------+---------------+--------------+------------1     |a name     |English        |a
filename    |             
 
|1102724
-------+-----------+---------------+---------------+--------------+------------
The problem starts when I use getBytes("content"). I am getting the
following error: FastPath call returned ERROR:  lo_tell: invalid large object
descriptor (0)
So, as you can see the oid is not zero. Does anyone know what is going
on?

One more thing, setBytes method, does work, but only if the array of
bytes is not too big. (I don't know the exact size) :-(

thanks,

RP

P.S. Replay to my email address, please.
-- 
..............................................................................
:           Rafal Piotrowski             :
mailto:Rafal.Piotrowski@CSCS.CH   :
:          Research Scientist            :
http://www.cscs.ch/~rpiotrow      :
: Centro Svizzero di Calcolo Scientifico : Tel.: +41 (0)91 610
8211          :
:       Via Cantonale, Galleria 2        :       +41 (0)91 610 8315
(direct) :
:       CH-6928 Manno, Switzerland       : Fax:  +41 (0)91 610
8383          :
..............................................................................


pgsql-interfaces by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [INTERFACES] table very big !!!!!
Next
From: Peter Mount
Date:
Subject: Re: [INTERFACES] problem with getBytes