problem with getBytes - Mailing list pgsql-interfaces

From Rafal Piotrowski (CSCS)
Subject problem with getBytes
Date
Msg-id 38397C90.7800D97E@CSCS.CH
Whole thread Raw
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 file name    |
|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          :
..............................................................................
Attachment

pgsql-interfaces by date:

Previous
From: Lamar Owen
Date:
Subject: Re: [INTERFACES] pg_pwd
Next
From: Pablo Salazar Loaiza
Date:
Subject: table very big !!!!!