X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 20D3BD1E0E1 for ; Mon, 5 Apr 2004 12:54:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43221-06 for ; Mon, 5 Apr 2004 09:55:04 -0300 (ADT) Received: from FE-mail04.sfg.albacom.net (FE-mail04.albacom.net [213.217.149.84]) by svr1.postgresql.org (Postfix) with ESMTP id 355A7D1DC1C for ; Mon, 5 Apr 2004 09:54:35 -0300 (ADT) Received: from axa.it (217.221.81.76) by FE-mail04.sfg.albacom.net (7.0.009) id 406E6A190001C985 for pgsql-admin@postgresql.org; Mon, 5 Apr 2004 14:55:11 +0200 Message-ID: <40715730.3090902@axa.it> Date: Mon, 05 Apr 2004 14:55:12 +0200 From: Edoardo Ceccarelli User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: it, en, en-us MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: blob without largeobject api Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/40 X-Sequence-Number: 13013 I need to insert a Blob into a table without using org.postgresql.largeobject.*; classes, that's because the db pool I'm using (Resin) doesn't allow me to cast: ((org.postgresql.PGConnection)db) to get access at the Postgres LargeObjectAPI. // Generates ClassCastExep. LargeObjectManager lom = ((org.postgresql.PGConnection)db).getLargeObjectAPI(); Since I'd like to keep using the same type of connection (without changing the pool manager or directly connecting to the db) is there a way to insert Blob (oid) data into a table without using the large object api? Looked in the examples under src/interfaces/jdbc/ but all blob examples uses that type of access. Thank You -- Edoardo Ceccarelli