From: | David Langton <djlangton+pgjdbc(at)googlemail(dot)com> |
---|---|
To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Connection Properties for FetchSize and Autocommit |
Date: | 2009-10-09 16:35:43 |
Message-ID: | 7c49e7040910090935n6973d5c0xd9082ea926f90526@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2009-10-11 22:16:56 | Re: Connection Properties for FetchSize and Autocommit |
Previous Message | Oliver Jowett | 2009-10-09 09:59:36 | Re: Connection Properties for FetchSize and Autocommit |