pooled prepared statements - Mailing list pgsql-jdbc

From Thomas Finneid
Subject pooled prepared statements
Date
Msg-id 4A0978A3.6030900@fcon.no
Whole thread Raw
Responses Re: pooled prepared statements
Re: pooled prepared statements
List pgsql-jdbc
Hi

When a PreparedStatment is created by a pooled connection, as far as I
understand if, that creation happens on the server side, and a
reference, of sorts, is returned to the client jdbc.

Is that prepared statement shared among the connections or is it only
available to that single connection? and more importantly, can many
connections use that prepared statement concurrently?

If it is shared, then it must be usable by concurrent connections,
otherwise it will be difficult for the client to know if the statement
is occupied or not. So I just want to confirm that I understand how the
JDBC driver works.

regards

thomas

pgsql-jdbc by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Unable to access table named "user"
Next
From: John Lister
Date:
Subject: Re: pooled prepared statements