Thread: problem with getBytes

problem with getBytes

From
"Rafal Piotrowski (CSCS)"
Date:
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