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
> ********************************