RE: getAutocommit assertion error

Sorry for this late anwser ...

Dave, for the version of driver is:

<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.2</version>

Jens,

I can't debug, because the problem only appears when bamboo lannched my test cases ... impossible to reproduce IDE and Maven command line ...

________________________________
De : Jens Carlberg <jens(dot)carlberg(at)gmail(dot)com>
Envoyé : mardi 13 novembre 2018 10:11:32
À : pgsql-jdbc(at)lists(dot)postgresql(dot)org
Objet : 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<mailto: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<mailto: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<mailto:adriennolarsen(at)hotmail(dot)fr>>
Envoyé : lundi 12 novembre 2018 14:10:50
À : pgsql-jdbc(at)lists(dot)postgresql(dot)org<mailto: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