Thread: database auto-commit

database auto-commit

From
"FERREIRA, William (COFRAMI)"
Date:
hi

i writing a j2ee application working with postgresql and i meet a problem with autocommit
from my j2ee application i call a perl function and i get an error :
in french : Les Large Objects ne devraient pas être utilisés en mode auto-commit.
in english : Large Objects should not be used in mode auto-committed.

and i didn't find how to disable autocommit.

Thanks in advance

    William

This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this
inmind if you answer this message. 

Re: database auto-commit

From
"Jim C. Nasby"
Date:
IIRC there is no autocommit in postgresql itself, so the autocommit is
probably from whatever connection library/method you're using. Note that
PSQL does have an autocommit option, but I don't see how that would
affect this case.

On Tue, May 31, 2005 at 03:12:26PM +0200, FERREIRA, William (COFRAMI) wrote:
>
> hi
>
> i writing a j2ee application working with postgresql and i meet a problem with autocommit
> from my j2ee application i call a perl function and i get an error :
> in french : Les Large Objects ne devraient pas ?tre utilis?s en mode auto-commit.
> in english : Large Objects should not be used in mode auto-committed.
>
> and i didn't find how to disable autocommit.
>
> Thanks in advance
>
>     William
>
> This mail has originated outside your organization, either from an external partner or the Global Internet. Keep this
inmind if you answer this message. 
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"