Hello Hibernate Team, is there a good way to check in a junit test which number of sql statements are generated ? I want to tackle some of the lazy loading/class enhancement issues and those need good tests of course. Somehow related: I have a (rather trivial) fix for HHH-7842 (Hibernate Criteria does not respect fetch mode, when alias is used). As this is related to the now deprecated Hibernate Criteria API is there any chance my fix gets accepted or should I spare my time? Thanks, Thomas _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev

Hi Thomas, I can't answer your question - will leave that to the people working on Hibernate ORM - but let me share that I'd also love to see such a tool or an example for unit tests (integration tests) to assert that some specific piece of code won't be generating more than N database round trips. That would be extremely useful! Let me suggst to focus on the actual network round-trips though: looking at the number of statements being generated is misleading as Hibernate ORM is able to do many clever things with multiple statements; for example you might see many of them being logged but it could still be wrapping them all in a single batch, therefore not being a performance problem. Vlad could this be a feature of your Flexy Pool ? Would love to see such a feature as a JUnit Rule ... Thanks, Sanne On 22 September 2017 at 15:34, Thomas Reinhardt <thomas(a)reinhardt.com&gt; wrote: > > Hello Hibernate Team, > > is there a good way to check in a junit test which number of sql > statements are generated ? > I want to tackle some of the lazy loading/class enhancement issues and > those need good tests of course. > > Somehow related: I have a (rather trivial) fix for HHH-7842 (Hibernate > Criteria does not respect fetch mode, when alias is used). As this is > related to the now deprecated Hibernate Criteria API is there any chance > my fix gets accepted or should I spare my time? > > > Thanks, > Thomas > _______________________________________________ > hibernate-dev mailing list > hibernate-dev(a)lists.jboss.org > https://lists.jboss.org/mailman/listinfo/hibernate-dev _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev