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 MAA23994 for ; Mon, 22 Nov 1999 12:25:48 -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 SAA18292 for ; Mon, 22 Nov 1999 18:25:36 +0100 (MET) Received: from CSCS.CH by muzzano (8.9.1b+Sun) id SAA06815; Mon, 22 Nov 1999 18:25:36 +0100 (MET) Sender: rpiotrow@CSCS.CH Message-ID: <38397C90.7800D97E@CSCS.CH> Date: Mon, 22 Nov 1999 18:25:36 +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: multipart/mixed; boundary="------------80C873E431C53C8BCD096C6B" This is a multi-part message in MIME format. --------------80C873E431C53C8BCD096C6B 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 : .............................................................................. --------------80C873E431C53C8BCD096C6B Content-Type: text/x-vcard; charset=us-ascii; name="Rafal.Piotrowski.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Rafal Piotrowski (CSCS) Content-Disposition: attachment; filename="Rafal.Piotrowski.vcf" begin:vcard n:Piotrowski;Rafal tel;cell:+41 (0)78 621 6366 tel;fax:+41 (0)91 610 8383 tel;work:+41 (0)91 610 8315 x-mozilla-html:TRUE url:http://www.cscs.ch/~rpiotrow org:Centro Svizzero di Calcolo Scientifico;Software Engineering version:2.1 email;internet:Rafal.Piotrowski@CSCS.CH title:Research Scientist note:ICQ# 23522302 adr;quoted-printable:;;Via Cantonale - Galleria 2,=0D=0A;Manno;Ticino;CH-6928;Switzerland x-mozilla-cpt:;-21728 fn:Rafal Piotrowski end:vcard --------------80C873E431C53C8BCD096C6B--