Re: Multi-thread use of a connection

From: "Chris White" <cjwhite(at)cisco(dot)com>
To: "'Dave Cramer'" <davec(at)ebox(dot)com>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Multi-thread use of a connection
Date: 2002-07-23 01:06:05
Message-ID: 00a001c231e5$1f414c00$ff926b80@amer.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

The 7.2 Programmers Guide Chapter 8, JDBC Interface section 8.8.

-----Original Message-----
From: Dave Cramer [mailto:davec(at)ebox(dot)com]
Sent: Monday, July 22, 2002 3:05 PM
To: cjwhite(at)cisco(dot)com
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Multi-thread use of a connection

Chris,

AFAIK, two threads cannot share a connection. Which documentation are
you referring to?

Either way you can only have one transaction open on a connection.

Dave
On Mon, 2002-07-22 at 17:12, Chris White wrote:
> The documentation states the jdbc driver is thread safe allowing multiple
> threads to share the same connection. The documentation only talks about
> queries. So my question is: What if 2 threads are doing transactions and
one
> wants to commit its data, does this mean that the other threads data will
> also be committed even though it hasn't completed it's transaction or is
the
> driver aware of this?
>
> Chris White

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-07-23 02:29:22 Re: XAER_RMERR warnings and rollback exceptions
Previous Message G.L. Grobe 2002-07-23 00:24:46 XAER_RMERR warnings and rollback exceptions