From: John Thorhauer <jthorhauer@phoenixcolor.com>
To: postgres-inter <pgsql-interfaces@postgresql.org>
Subject: using large objects with jdbc/odbc
Date: Mon, 21 Aug 2000 11:52:23 -0400
Message-ID: <39A15037.96FC0076@phoenixcolor.com> (raw)
I am successfully using large objects in postgres with the latest
version of postgtres and the latest jdbc driver (thanks to a lot of help
from this list :-)) However, I need to make sure that my table is
accessible from both jdbc and odbc drivers. I need to make sure that
programs that utilize the odbc driver for postgres can also access large
object data in the same table that the jdbc driver is accessing the
data.
So I thought that I would have to define the large object field as type
'lo' instead of 'oid'. But then jdbc wont recognize it. So I tried
defining a type in the org.postgres.Field.java of 'lo' as VARBINARY and
also tried it as INTEGER, hoping that the driver would then recognize
the type of lo in the table but it did not work and I get the following
error:
Attribute 'fieldA' is of type 'lo' but expression is of type 'int4'
Any ideas on this? Is it possible to even do this or should I go back
to the drawing board?
Thanks,
John
--
********************************
** John Thorhauer
** jthorhauer@phoenixcolor.com
********************************
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jthorhauer@phoenixcolor.com
Subject: Re: using large objects with jdbc/odbc
In-Reply-To: <39A15037.96FC0076@phoenixcolor.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox