pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedJDBC and waiting for commit on a locked table in 6.4.2
4+ messages / 3 participants
[nested] [flat]
* JDBC and waiting for commit on a locked table in 6.4.2
@ 1999-04-27 09:12 Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 4+ messages in thread
From: Constantin Teodorescu @ 1999-04-27 09:12 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I'm using JDBC PostgreSQL with 6.4.2 database.
I'm using the new code style (conn.setAutoCommit(false)).
When the transaction is waiting for another transaction to terminate, is
there a way to set a timeout period , let's say a maximum of 30 seconds
?
If the lock still persist after 30 seconds the statement.upDate() to
fail and to throw a SQLException?
Of course, without the classical watchdog thread object.
Thanks in advance,
(BTW : I tried the same thing on 6.5 beta 1 and my both transactions
have committed without problem. Nice work that MVCC. I'm watching daily
the development waiting for the big day of 6.5 final)
Best regards,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2
@ 1999-04-27 09:52 Peter Mount <petermount@it.maidstone.gov.uk>
1999-04-27 10:52 ` Re: [INTERFACES] JDBC and waiting for commit on a locked table in6.4.2 Vadim Mikheev <vadim@krs.ru>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Mount @ 1999-04-27 09:52 UTC (permalink / raw)
To: Constantin Teodorescu <teo@flex.ro>; pgsql-interfaces
I'm not sure about the time out. I'll check the specs.
Talking about 6.5 final, when is the expected date (assuming no show
stopping bugs)? The last date I had heared was May 1st.
I'm way behind on a few fixes in JDBC (work is taking up my time :-( ),
and it would be easier to know of a date to target with.
Peter
--
Peter T Mount, IT Section
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as the
official words of Maidstone Borough Council
-----Original Message-----
From: Constantin Teodorescu [mailto:teo@flex.ro]
Sent: Tuesday, April 27, 1999 10:13 AM
To: PostgreSQL Interfaces
Subject: [INTERFACES] JDBC and waiting for commit on a locked table in
6.4.2
Hello,
I'm using JDBC PostgreSQL with 6.4.2 database.
I'm using the new code style (conn.setAutoCommit(false)).
When the transaction is waiting for another transaction to terminate, is
there a way to set a timeout period , let's say a maximum of 30 seconds
?
If the lock still persist after 30 seconds the statement.upDate() to
fail and to throw a SQLException?
Of course, without the classical watchdog thread object.
Thanks in advance,
(BTW : I tried the same thing on 6.5 beta 1 and my both transactions
have committed without problem. Nice work that MVCC. I'm watching daily
the development waiting for the big day of 6.5 final)
Best regards,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [INTERFACES] JDBC and waiting for commit on a locked table in6.4.2
1999-04-27 09:52 RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2 Peter Mount <petermount@it.maidstone.gov.uk>
@ 1999-04-27 10:52 ` Vadim Mikheev <vadim@krs.ru>
0 siblings, 0 replies; 4+ messages in thread
From: Vadim Mikheev @ 1999-04-27 10:52 UTC (permalink / raw)
To: Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: Constantin Teodorescu <teo@flex.ro>; pgsql-interfaces; PostgreSQL Developers List <hackers@postgreSQL.org>
Peter Mount wrote:
>
> I'm not sure about the time out. I'll check the specs.
>
> Talking about 6.5 final, when is the expected date (assuming no show
> stopping bugs)? The last date I had heared was May 1st.
>
> I'm way behind on a few fixes in JDBC (work is taking up my time :-( ),
> and it would be easier to know of a date to target with.
Imho, Jun 1st is good date.
?
Vadim
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2
@ 1999-04-27 11:28 Peter Mount <petermount@it.maidstone.gov.uk>
0 siblings, 0 replies; 4+ messages in thread
From: Peter Mount @ 1999-04-27 11:28 UTC (permalink / raw)
To: Vadim Mikheev <vadim@krs.ru>; Peter Mount <petermount@it.maidstone.gov.uk>; +Cc: Constantin Teodorescu <teo@flex.ro>; pgsql-interfaces; PostgreSQL Developers List <hackers@postgresql.org>
That would be good for me, as it would give me enough time to sort out
the 4 things I'd like to fix before 6.5 is out.
Peter
--
Peter T Mount, IT Section
petermount@it.maidstone.gov.uk
Anything I write here are my own views, and cannot be taken as the
official words of Maidstone Borough Council
-----Original Message-----
From: Vadim Mikheev [mailto:vadim@krs.ru]
Sent: Tuesday, April 27, 1999 11:53 AM
To: Peter Mount
Cc: Constantin Teodorescu; PostgreSQL Interfaces; PostgreSQL Developers
List
Subject: Re: [INTERFACES] JDBC and waiting for commit on a locked table
in6.4.2
Peter Mount wrote:
>
> I'm not sure about the time out. I'll check the specs.
>
> Talking about 6.5 final, when is the expected date (assuming no show
> stopping bugs)? The last date I had heared was May 1st.
>
> I'm way behind on a few fixes in JDBC (work is taking up my time :-(
),
> and it would be easier to know of a date to target with.
Imho, Jun 1st is good date.
?
Vadim
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~1999-04-27 11:28 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-27 09:12 JDBC and waiting for commit on a locked table in 6.4.2 Constantin Teodorescu <teo@flex.ro>
1999-04-27 09:52 RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2 Peter Mount <petermount@it.maidstone.gov.uk>
1999-04-27 10:52 ` Re: [INTERFACES] JDBC and waiting for commit on a locked table in6.4.2 Vadim Mikheev <vadim@krs.ru>
1999-04-27 11:28 RE: [INTERFACES] JDBC and waiting for commit on a locked table in 6.4.2 Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox