From: Peter Mount <peter@retep.org.uk>
To: John Thorhauer <jthorhauer@phoenixcolor.com>
To: postgres-inter <pgsql-interfaces@postgresql.org>
Subject: Re: using large objects with jdbc/odbc
Date: Tue, 22 Aug 2000 18:01:13 +0100
Message-ID: <000001c00db0$ab0f84a0$6f0010ac@maidstone.gov.uk> (raw)
References: <39A15037.96FC0076@phoenixcolor.com>
This error is from the backend. Its saying it doesn't know how to convert lo
to and from int4. You'll need to create some functions to handle this
conversion.
Peter
--
Peter T Mount peter@retep.org.uk, me@petermount.com
Homepage: http://www.retep.org.uk Contact details: http://petermount.com
PostgreSQL JDBC: http://www.retep.org.uk/postgres/
Java PDF Generator: http://www.retep.org.uk/pdf/
----- Original Message -----
From: "John Thorhauer" <jthorhauer@phoenixcolor.com>
To: "postgres-inter" <pgsql-interfaces@postgresql.org>
Sent: Monday, August 21, 2000 4:52 PM
Subject: [INTERFACES] using large objects with jdbc/odbc
> 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: peter@retep.org.uk, jthorhauer@phoenixcolor.com
Subject: Re: using large objects with jdbc/odbc
In-Reply-To: <000001c00db0$ab0f84a0$6f0010ac@maidstone.gov.uk>
* 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