From: Rolland Crunk <rc@crunk.net>
To: pgsql-interfaces@postgresql.org
Subject: JDBC - large objects
Date: Tue, 06 Jul 1999 01:56:40 -0700
Message-ID: <4.1.19990706011551.00c89a20@crunk.net> (raw)
I am having some problem getting the jdbc driver to work properly with
large objects using standard jdbc interfaces. The tables are pretty much
standard relational tables except for one column that I serialize
implementations of the java.security.acl.Acl as objects into.
The error I get is: ERROR: lo_write: invalid large obj descriptor (0)
This was the same error I got running the blobtest until I applied Tatsuo Ishii's
patch I found in the mailing list archives. I tried the same thing in my code
(turn on explicit transactions when storing a blob) but it doesn't seem to
have any effect.
I have tried defining the acl field in my create table statement as both:
: :
acl oid,
: :
and
: :
acl char[]
: :
And see same thing.
The same (java) code runs fine using Oracle 8 and their thin driver.
I guess what I need to know is: is what I am trying to do possible using
PostgreSQL/JDBC without using the PostgreSQL extensions? (not an
option for me). If so, what should I use for serialized columns in the
create table sql statement? Can it be done without turning off autocommit?
Thanks in advance for any help anyone can provide.
Cordially,
rc
ps: My environment is:
Solaris 2.7 (intel)
jdk 1.2 (jdk 1.1 fares no better)
PostgreSQL 6.5
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: rc@crunk.net
Subject: Re: JDBC - large objects
In-Reply-To: <4.1.19990706011551.00c89a20@crunk.net>
* 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