Re: postresql autocommit

malgr le fait que j'utilise la version 8 de postgresql, j'ai mis setautocommit false
et ca fonctionne .....

merci tout le monde

-----Message d'origine-----
De : pgsql-fr-generale-owner(at)postgresql(dot)org
[mailto:pgsql-fr-generale-owner(at)postgresql(dot)org]De la part de FERREIRA,
William (COFRAMI)
Envoy : mardi 31 mai 2005 15:41
: Jean-Christophe Arnu
Cc : pgsql-fr-generale(at)postgresql(dot)org
Objet : Re: [pgsql-fr-generale] postresql autocommit

j'utilise la version 8.0.2 de postgresql sous windows

-----Message d'origine-----
De : Jean-Christophe Arnu [mailto:arnu(at)paratronic(dot)fr]
Envoy : mardi 31 mai 2005 15:36
: FERREIRA, William (COFRAMI)
Cc : pgsql-fr-generale(at)postgresql(dot)org
Objet : Re: [pgsql-fr-generale] postresql autocommit

FERREIRA, William (COFRAMI) m'expliquait (le 31.05.2005 15:09):

> bonjour,
>
> j'ai une application j2ee qui utilise une base de donnes Postgresql.
> j'ai une fonction perl qui traite des BLOB et quand je l'appelle via
> JDBC j'ai une erreur :
>
> Les Large Objects ne devraient pas tre utiliss en mode auto-commit.
>
> J'aurais voulu savoir comment desactiver le mode auto-commit de la base
>
> Cordialement
>
> William FERREIRA

Bonjour,

Dans quelle version de PostgreSQL ? Dans la version 7.3 de
PostgreSQL on peut spcifier
set autocommit=off;
dans psql.

Dans JDBC cel se traduit par l'appel idoine de
java.sql.Connection.setAutoCommit(boolean);

Cordialement,

--
Jean-Christophe Arnu
Paratronic

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

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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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

This e-mail is intended only for the above addressee. It may contain
privileged information. If you are not the addressee you must not copy,
distribute, disclose or use any of the information in it. If you have
received it in error please delete it and immediately notify the sender.
Security Notice: all e-mail, sent to or from this address, may be
accessed by someone other than the recipient, for system management and
security reasons. This access is controlled under Regulation of
Investigatory Powers Act 2000, Lawful Business Practises.