CODEWITHSUNDEEP
javamysqleclipsehibernatetransactions
Steve Chambers
Steve Chambers

Reputation: 39424

How to inspect data within a database transaction?

I'm running an integration test that executes some Hibernate code within a single transaction (managed by Spring). The test is failing with a duplicate key violation and I'd like to hit a breakpoint just before this and inspect the table contents. I can't just go into MySQL Workbench and run a SELECT query as it would be outside the transaction. Is there another way?

Upvotes: 1

Views: 731

Answers (2)

Steve Chambers
Steve Chambers

Reputation: 39424

The following can be run from Eclipse's "Display" view:

java.util.Arrays.deepToString(
  em.createNativeQuery("SELECT mystuff FROM mytable").getResultList().toArray())
  .replace("], ", "]\n");

This displays all the data, albeit not in a very user-friendly way - e.g. will need to work out which columns the comma-separated fields correspond to.

Upvotes: 0

Alexander Petrov
Alexander Petrov

Reputation: 9492

After reading your comments, my impression that predominantly you are interested in how to hit a breakpoint and at the same time be able to examine database contents. Under normal circumstances I would just offer you to log the SQLs. Having the breakpoint in mind my suggestion is:

Reduce isolation level to READ_UNCOMMITED for the integration test.

Reducing the isolation level will allow you to see the uncommitted values in the database during the debugging. As long as you don't have parallel activity within the integration test. It should be fine.

Isolation level can be set up on per connection basis. There is no need for anything to be done on the server.

One side note. If you are using Hibernate even the parallel activities may work fine when you reduce the ISOLATION LEVEL because largely Hibernate behaves as it is in REPEATABLE_READ because of the transactional Level 1 cache.

Upvotes: 1

Related Questions