Re: PREPARE and transactions - Mailing list pgsql-hackers

From James Robinson
Subject Re: PREPARE and transactions
Date
Msg-id A93A5E4E-C5EF-11D8-8247-000A9566A412@socialserve.com
Whole thread Raw
In response to Re: PREPARE and transactions  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
List pgsql-hackers
[ all snipped ]

A problem with redefining the lifetime of a PREPARE'd statement 
according to if it was defined within an explicitly managed transaction 
or not would be with middlewares such as J2EE / EJB containers. The 
container / JDBC driver performs most operations within explicitly 
managed transactions *by the middleware container*, and, if the 
middleware container is configured to cache prepared statements between 
transactions, then it will expect them to live well beyond their 
initial explicitly-managed transaction.

----
James Robinson
Socialserve.com



pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: JDBC prepared statements: actually not server
Next
From: "Thomas Hallgren"
Date:
Subject: Re: bug in GUC