From: | "Chris White" <cjwhite(at)cisco(dot)com> |
---|---|
To: | "Barry Lind" <barry(at)xythos(dot)com> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Getting oid of 0 when doing LargeObjectManager.create() |
Date: | 2002-07-11 05:42:51 |
Message-ID: | NCBBIJCJEKFBDCFKEEEIKEAHHEAA.cjwhite@cisco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I am using jdbc7.2dev-1.2.jar. So I will try the latest development version.
I do have auto commit turned off, but don't I have to do a commit once I
have written and closed the Large Object in order for it to retained in the
database? Also, I thought I needed to store the oid in the database so I
could read/delete the Large object later, so how come it becomes invalid on
a commit, which I use all the time after doing inserts and updates?
Chris
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of Barry Lind
Sent: Wednesday, July 10, 2002 8:57 PM
To: cjwhite(at)cisco(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Getting oid of 0 when doing
LargeObjectManager.create()
Chris,
What version are you using? I just fixed a bug last week on this, so
have you tried the latest development driver build from jdbc.postgresql.org?
If this isn't related to the bug I fixed then it is likely related to
the fact that you are trying to use a large object after having done a
commit. In order to use large objects you must run with autocommit
turned off since the large object pointer becomes invalid on a commit.
thanks,
--Barry
Chris White wrote:
> I am getting a oid value of 0 returned when I do a
> LargeObjectManager.create(). This tells me that I can't create a large
> object. What reasons would cause this? and what I can do to solve the
> problems.
>
> thanks
> Chris White
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
From | Date | Subject | |
---|---|---|---|
Next Message | Yuva Chandolu | 2002-07-11 08:12:07 | Date time problem with timstamp with no timezone data type |
Previous Message | Barry Lind | 2002-07-11 03:56:56 | Re: Getting oid of 0 when doing LargeObjectManager.create() |