Re: simultaneous use of JDBC and libpq

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: alltest1 <alltest1(at)covad(dot)net>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: simultaneous use of JDBC and libpq
Date: 2004-06-23 15:55:10
Message-ID: 1088006110.9722.9.camel@coppola.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2004-06-23 15:57:58 Re: RHEL 2.1 rpms for 7.4.2
Previous Message Mark Spruill 2004-06-23 15:49:14 Restore a dump with new line characters