Setting up query counter with Spring Boot

[vladmihalcea]

Setting up query counter with Spring Boot

[vladmihalcea]

Just adding the db-util dependency to the pom.xml and calling SQLStatementCountValidators .reset() and assertSelectCount() was not enough.

Yes, that's not enough. You also need to wrap the DataSource as explained in this article. Now, doing that in Spring Boot is more work than with a plain Spring application, and that's would explain why you needed that starter.

Anyway, I'm going to close this issue since it is Spring Boot responsibility to add support for other libraries, not the other way around.

[rodelrod]

Thanks for the very quick answer. I've read that article multiple times and the following line led me to believe that all you needed was to add the maven dependency to set up the interceptor:

Since it’s already available in Maven Central Repository, you can easily use it by just adding this dependency to your pom.xml [...]

In any event there was no indication of what else I could do, so I thought that the technique I describe could be useful for other users.

[vladmihalcea]

I can't add the dependency to the project. What if someone wants to use it with Java EE?

This is like adding a Spring dependency into Log4J.

[rodelrod]

I agree and I'm not asking for you to do that, just documenting my experience to help other users that may find themselves in the same position (which I imagine is a common one, since it's provided by a bunch of popular gems in Rails and core Django functionality since 2011; and we haven't been having any less N+1 problems with JPA/Hibernate than I've had with other ORM's, even after I read your excellent book on the subject).

Anyway, no action asked from you. Feel free to document this or let Google take care of it. Thanks again for your work, if there were just a few others like you around, life in the Java/Spring ecosystem would be much less painful.

[vladmihalcea]

I think it's better if you send me a Pull Request with the README.md file updated with this info for Spring Boot.