Re: simultaneous use of JDBC and libpq - Mailing list pgsql-general

From Csaba Nagy
Subject Re: simultaneous use of JDBC and libpq
Date
Msg-id 1088006110.9722.9.camel@coppola.ecircle.de
Whole thread Raw
In response to simultaneous use of JDBC and libpq  (alltest1 <alltest1@covad.net>)
List pgsql-general
Yes, it is safe. The JDBC and the libpq app will share nothing between
each other, so there can not be any threading issues between them.
You can only have thread safety issues inside the same application which
uses multiple threads sharing resources between each other.

Cheers,
Csaba.

On Wed, 2004-06-23 at 16:24, alltest1 wrote:
> Hi,
>
> I am wondering if it is thread-safe to use both JDBC and libpq
> simultaneously.
>
> On a Linux, JDBC is used by Tomcat and libpq is used by a client
> software written in C language. So JDBC and libpq are used by two
> different programs.
> If the same row in the same table is updated (update SQL command)
> through libpq and
> read (select SQL command) by JDBC, then would it cause a thread problem?
> I am not using any transaction, and using just select, update, and
> sometimes insert.
>
> I am using PostgreSQL 7.3.6 with pg73jdbc3.jar downloaded and libpq that
> came with Redhat Enterprise 3.
>
> Thank you very much in advance.
>
> Bob
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: RHEL 2.1 rpms for 7.4.2
Next
From: "Joshua D. Drake"
Date:
Subject: Re: RHEL 2.1 rpms for 7.4.2