"Dejan Vucinic" <hotdejan(at)hotmail(dot)com> writes:
>> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
>> Probably you are not wrapping the operation into a transaction
>> (BEGIN/COMMIT). Large object descriptors are only good to the end of
>> the current transaction.
> I believe I am, the code looks like this:
> insert = connection.prepareStatement(
> "INSERT INTO FOO (A, B) VALUES (?, ?)");
> insert.setString(1, somestring);
> insert.setBytes(2, byte xx);
I have no idea what that actually does at the database level.
In particular, does the setAutoCommit(false) routine send a
BEGIN, or does it only set some state that affects later operations?
If there's not a BEGIN sent before the LO operations, they'll fail.
You might try turning on query logging at the postmaster to see
what requests are really being transmitted.
regards, tom lane
In response to
pgsql-jdbc by date
|Next:||From: Jörg Sommer||Date: 2001-07-11 19:43:51|
|Subject: Methode is not yet implemented.|
|Previous:||From: Dave Cramer||Date: 2001-07-11 19:24:34|
|Subject: RE: [PATCH] setTimestamp(int, Timestamp) fails on null timestamp|