Skip site navigation (1) Skip section navigation (2)

Re: using large objects with jdbc/odbc

From: "Peter Mount" <peter(at)retep(dot)org(dot)uk>
To: "John Thorhauer" <jthorhauer(at)phoenixcolor(dot)com>, "postgres-inter" <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: using large objects with jdbc/odbc
Date: 2000-08-22 17:01:13
Message-ID: 000001c00db0$ab0f84a0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
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


Peter T Mount  peter(at)retep(dot)org(dot)uk, me(at)petermount(dot)com
Homepage: Contact details:
PostgreSQL JDBC:
Java PDF Generator:
----- Original Message -----
From: "John Thorhauer" <jthorhauer(at)phoenixcolor(dot)com>
To: "postgres-inter" <pgsql-interfaces(at)postgresql(dot)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 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(at)phoenixcolor(dot)com
> ********************************

In response to


pgsql-interfaces by date

Next:From: S.A.PamungkasDate: 2000-08-23 05:16:52
Subject: applet-servlet and pgaccess
Previous:From: Josh BerkusDate: 2000-08-22 16:38:06
Subject: Re: odbc blob

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group