Re: jdbc and postgresql function session question
От | Adrian Klaver |
---|---|
Тема | Re: jdbc and postgresql function session question |
Дата | |
Msg-id | f96cb0db-79e8-46a8-2baf-42baaae04eb9@aklaver.com обсуждение исходный текст |
Ответ на | jdbc and postgresql function session question (Michael Moore <michaeljmoore@gmail.com>) |
Ответы |
Re: jdbc and postgresql function session question
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: