Re: Connection Properties for FetchSize and Autocommit
От
David Langton
Тема
Re: Connection Properties for FetchSize and Autocommit
Дата
Msg-id
7c49e7040910090935n6973d5c0xd9082ea926f90526@mail.gmail.com
Ответ на
Re: Connection Properties for FetchSize and Autocommit (Oliver Jowett)
Список
Дерево обсуждения
Connection Properties for FetchSize and Autocommit David Langton <djlangton+pgjdbc@googlemail.com>
Re: Connection Properties for FetchSize and Autocommit Oliver Jowett <oliver@opencloud.com>
Re: Connection Properties for FetchSize and Autocommit David Langton <djlangton+pgjdbc@googlemail.com>
Re: Connection Properties for FetchSize and Autocommit Oliver Jowett <oliver@opencloud.com>
> David Langton wrote: >> >> defaultAutoCommit > > That seems a pretty dangerous setting to have :/ > > -O > I'm not sure! Without this parameter, you get a connection in autocommit mode anyway. If you actually set the mode yourself you get whatever it is you want. This parameter simply allows you to initially set autocommit to false in the url for those (rare) situations where it is what you want, but you can't modify the calling application. However, I'm certainly not any sort of JDBC expert, it just helped me out a lot to be able to do this (along with fetchsize) to avoid getting the whole result set sent to the driver all at once. If I could alter the application, I would have (and that would have been a better place to do it!). Regards
В списке pgsql-jdbc по дате отправления