Subject: Re: jdbc and postgresql function session question
To: Michael Moore <michaeljmoore@gmail.com>,
 postgres list <pgsql-sql@postgresql.org>
References: 
 <CACpWLjNyvDcn4J+2-PFDTOn11BrWJJG6VG65iYEv3oLED5tkyg@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <f96cb0db-79e8-46a8-2baf-42baaae04eb9@aklaver.com>
Date: Tue, 31 May 2016 15:01:04 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.1.0
MIME-Version: 1.0
In-Reply-To: 
 <CACpWLjNyvDcn4J+2-PFDTOn11BrWJJG6VG65iYEv3oLED5tkyg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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.klaver@aklaver.com


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql