Re: getAutocommit assertion error - Mailing list pgsql-jdbc

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.carlberg@gmail.com>
Envoyé : mardi 13 novembre 2018 10:11:32
À : pgsql-jdbc@lists.postgresql.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.carlberg@gmail.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@hotmail.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@hotmail.fr>
Envoyé : lundi 12 novembre 2018 14:10:50
À : pgsql-jdbc@lists.postgresql.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