Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f26BvEx66506 for ; Tue, 6 Mar 2001 06:57:14 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f26BvB766501; Tue, 6 Mar 2001 06:57:11 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: Martin Schild Subject: Re: object id Message-ID: <983879831.3aa4d097bf217@webmail.retep.org.uk> Date: Tue, 06 Mar 2001 06:57:11 -0500 (EST) From: Peter T Mount Cc: pgsql-interfaces@postgresql.org References: <3AA37334.20564E8C@gmx.de> In-Reply-To: <3AA37334.20564E8C@gmx.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200103/52 X-Sequence-Number: 1213 Quoting Martin Schild : > Hi, > > I'm using the setBytes() method of jdbc to store a large object to > database. Now i want to store the object id to another table. Is there > a > > possibility to get the oid of an object directly after the object is > stored to store this id into another table. setBytes() actually stores the large object's OID in that column, so to get the oid, simply use getInt() or getString() on the same column. Only getBytes() & get*Stream() methods (as well as the set* equivalents) actually operate on the large object itself. The others would see just the oid value. Peter -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/