Re: jdbc and postgresql function session question

On 05/31/2016 02:20 PM, Michael Moore wrote:
> When the postgres jdbc driver calls a postgres function, does it get a
> new session every time? If I create a PREPARED statement on the first
> call, will it still be available on the 2nd call? If not, is there any
> way I could get the prepared statement to be used on successive calls?

I think this is going to need more explanation, so:

1) When you say session are you talking about connection or a
transaction? A function will run in its own transaction each time, but
can be run multiple times in a connection.

2) Where is the PREPARED statement being built, in the function or
outside it?

3) Can show an outline of what you are doing?

> TIA,
> Mike\
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com