From: | snpe <snpe(at)snpe(dot)co(dot)yu> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: problem with new autocommit config parameter and jdbc |
Date: | 2002-09-09 21:04:38 |
Message-ID: | 200209092304.38918.snpe@snpe.co.yu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
On Monday 09 September 2002 08:53 pm, Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Barry Lind wrote:
> >> How should client interfaces handle this new autocommit feature? Is it
> >> best to just issue a set at the beginning of the connection to ensure
> >> that it is always on?
> >
> > Yes, I thought that was the best fix for apps that can't deal with
> > autocommit being off.
>
> If autocommit=off really seriously breaks JDBC then I don't think a
> simple SET command at the start of a session is going to do that much
> to improve robustness. What if the user issues another SET to turn it
> on?
>
> I'd suggest just documenting that it is broken and you can't use it,
> until such time as you can get it fixed. Band-aids that only partially
> cover the problem don't seem worth the effort to me.
>
> In general I think that autocommit=off is probably going to be very
> poorly supported in the 7.3 release. We can document it as being
> "work in progress, use at your own risk".
>
I'm use 'autocommit=false' and have problem with psql
When any commnad is lost, then next commnad get error for transactions
(simple select command).BTW
snpe> select * from org_ba;
ERROR: relation org_ba does not exists
snpe> select * from org_ban;
ERROR: current transactions is aborted, queries ignored until end of
transaction block
snpe> rollback;
ROLLBACK
snpe> select * from org_ban;
this command is ok.
regards
Haris Peco
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Howe | 2002-09-09 21:05:27 | Re: Rule updates and PQcmdstatus() issue |
Previous Message | Rod Taylor | 2002-09-09 21:03:46 | Re: problem with new autocommit config parameter and jdbc |
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Lind | 2002-09-09 21:11:05 | Re: Closing Statements and ResultSets |
Previous Message | Rod Taylor | 2002-09-09 21:03:46 | Re: problem with new autocommit config parameter and jdbc |