Re: getAutocommit assertion error

After looking at the JDBC code, the only path I see leading to this error
is if the connection has been closed. If nothing else, this might give you
a clue where to look in your test code.

Best Regards,
///Jens Carlberg

On Tue, 13 Nov 2018 at 09:39, Jens Carlberg <jens(dot)carlberg(at)gmail(dot)com> wrote:

> Hi.
>
> If you can, I suggest you run in debug and put a breakpoint in the method,
> so you can examine the thrown exception (or trace the call deeper). In
> Eclipse, it would be Run -> Debug As -> Maven Test (assuming this is when
> you run the tests). I have no experience in how to do this in other
> environment, but I assume other IDE:s at least have similar functionality.
> If you are using maven on the command line, this thread on StackOverflow
> might be helpful:
> https://stackoverflow.com/questions/2935375/debugging-in-maven
>
> Best Regards,
> ///Jens Carlberg
>
>
> On Tue, 13 Nov 2018 at 09:19, adrien ruffie <adriennolarsen(at)hotmail(dot)fr>
> wrote:
>
>> Hello Dave,
>>
>> thank you for your advise, but unfortunately that not really change ...
>> even by reversing the 2 lines, I still have the problem.
>>
>> It's very strange in source code
>>
>> private booleanisAutoCommit() {
>> try {
>> return pgStatement.getConnection().getAutoCommit();
>> } catch (SQLException e) {
>> assert false : "pgStatement.getConnection().getAutoCommit() should not
>> throw";
>> return false;
>> }
>> }
>>
>> because you can't really see the really SQLException which should throws
>> in order ot really debug the problem ...
>> I have tried to find in postgres site, in jdbc driver topic and thread in
>> internet but nothing :-(
>>
>> ------------------------------
>> *De :* adrien ruffie <adriennolarsen(at)hotmail(dot)fr>
>> *Envoyé :* lundi 12 novembre 2018 14:10:50
>> *À :* pgsql-jdbc(at)lists(dot)postgresql(dot)org
>> *Objet :* getAutocommit assertion error
>>
>>
>> Hello all,
>>
>>
>> in my java test case launched by maven I get the following exception:
>>
>>
>> java.lang.AssertionError: pgStatement.getConnection().getAutoCommit()
>> should not throw
>>
>> But I don't know why this error is returned ...
>>
>> In my class, I set auto commit to 'false' value, and I commit at the
>> ending like this:
>>
>>
>> try {
>> preparedStatement.close();
>> connection.commit();
>> } catch (SQLException e) {
>> log.error("Error while closing connection.", e.toString());
>> }
>>
>> I check where the error comme from and I just found the following code,
>> in BatchResultHandler:
>>
>>
>> private boolean isAutoCommit() {
>> try {
>> return pgStatement.getConnection().getAutoCommit();
>> } catch (SQLException e) {
>> assert false : "pgStatement.getConnection().getAutoCommit() should
>> not throw";
>> return false;
>> }
>> }
>>
>>
>>
>> I don't really understand the problem ...
>>
>> anyone can help me please ?
>>
>>
>> Best regards,
>>
>>
>> Adrien
>>
>