Received: from piora-fddi.cscs.ch (piora-fddi.cscs.ch [148.187.1.180]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA31373 for ; Mon, 22 Nov 1999 13:10:06 -0500 (EST) (envelope-from Rafal.Piotrowski@CSCS.CH) Received: from muzzano (muzzano [148.187.130.80]) by piora-fddi.cscs.ch (8.8.7/8.8.7) with ESMTP id TAA18837 for ; Mon, 22 Nov 1999 19:10:05 +0100 (MET) Received: from CSCS.CH by muzzano (8.9.1b+Sun) id TAA07032; Mon, 22 Nov 1999 19:10:05 +0100 (MET) Sender: rpiotrow@CSCS.CH Message-ID: <383986FD.A7C87D1F@CSCS.CH> Date: Mon, 22 Nov 1999 19:10:05 +0100 From: "Rafal Piotrowski (CSCS)" Organization: CSCS X-Mailer: Mozilla 4.7 [en] (X11; U; SunOS 5.7 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: problem with getBytes Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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 : ..............................................................................