Fully featured low overhead profiler for Java EE and Java SE platforms.
Performance monitoring and profiling of Jenkins, TeamCity, Gradle, Maven, Ant, JUnit and TestNG.
Easy to use performance and memory profiler for .NET framework.

JPA/hibernate show the JPQL with the related JDBC SQL?

Moderators: Vladimir Kondratyev, Anton Katilin

JPA/hibernate show the JPQL with the related JDBC SQL?

Postby sebtardif » Tue Oct 03, 2017 5:28 pm

I want to know if YourKit support showing the original JPQL or HQL SQL emitted, and under these, the many JDBC query generated?

So, for example, would like to see when a single JPQL query generates one thousand JDBC SQLs.
sebtardif
 
Posts: 1
Joined: Tue Oct 03, 2017 1:30 pm

Re: JPA/hibernate show the JPQL with the related JDBC SQL?

Postby Anton Katilin » Tue Oct 03, 2017 5:56 pm

I believe you should be able to see this in the "Events" tab:
https://www.yourkit.com/docs/dotnet/help/probes_ui.jsp

Also, the current version shows some high level event detail directly in call trees.
Anton Katilin
 
Posts: 5951
Joined: Wed Aug 11, 2004 8:37 am

Re: JPA/hibernate show the JPQL with the related JDBC SQL?

Postby sjivan » Thu May 28, 2020 1:16 pm

Hi,
I'm trying to determine the SQL executed by JPA. I went to the Events tab and filtered on JPA/Hibernate and SQL and I see the JA/Hibernate calls in the table with an expandable column that shows the SQL related operations. (I needed to have SQL enabled in the filter to see the nested SQL operations under the JPA/Hibernate) tree node. However the "SQL" text in the details on shows an abbreviated / truncated SQL text (around 45 characters) and not the entire SQL. See link to screenshot : https://cln.sh/jdbJfv

How to I get to see the entire SQL corresponding to the JPA/Hibernate operations? Also should I be seeing these SQL calls originating from JPA/Hibernate as top level SQL entries in the Events table if I filter to only show the "SQL" events?
Thanks,
Sanjiv
sjivan
 
Posts: 10
Joined: Wed Apr 25, 2007 11:49 am

Re: JPA/hibernate show the JPQL with the related JDBC SQL?

Postby Anton Katilin » Thu May 28, 2020 3:14 pm

Hi Sanjiv,

Please specify -Dyk.timeline.str.len.limit=1000 (or whatever number you need; the default is 40) in <user home>/.yjp/ui.ini

Best regards,
Anton
Anton Katilin
 
Posts: 5951
Joined: Wed Aug 11, 2004 8:37 am


Return to Java Profiler

Who is online

Users browsing this forum: No registered users and 1 guest

YourKit uses cookies and other tracking technologies to improve your browsing experience on our website, to show you personalized content and targeted ads, to analyze our website traffic, and to understand where our visitors are coming from.

By browsing our website, you consent to our use of cookies and other tracking technologies in accordance with the Privacy Policy.