blob without largeobject api

From: Edoardo Ceccarelli <eddy(at)axa(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: blob without largeobject api
Date: 2004-04-05 12:55:12
Message-ID: 40715730.3090902@axa.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2004-04-05 12:57:09 [ODBC] psqlodbc problem?
Previous Message Jose' Cruanyes 2004-04-05 11:21:05 Re: invalid input syntax for type tid: '(,)'