Batch SQLs are not visible in J2EE statistics / SQL

Questions about YourKit Java Profiler
Post Reply
vidj
Posts: 8
Joined: Fri May 09, 2014 12:29 pm

Batch SQLs are not visible in J2EE statistics / SQL

Post by vidj »

Batch processed SQL-s are not visible in J2EE statistics / SQL. I use hibernate batch processing http://docs.jboss.org/hibernate/orm/3.3 ... batch.html. If I set batch_size to "1" it works OK.
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

Which version of the profiler do you use?

Please try v2014 EAP:
http://www.yourkit.com/eap
thyzz
Posts: 5
Joined: Tue May 06, 2014 9:50 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by thyzz »

I've also noticed this.
I'll retry with the latest EAP.

(btw. that it works with batch_size=1 is logical because in that case hibernate won't start a batch process but insert/update as it does normaly)
thyzz
Posts: 5
Joined: Tue May 06, 2014 9:50 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by thyzz »

To bad...
Using EAP build 14048
I still don't see the batch insert in the SQL query statistics.

Using the CPU call tree I can still pretty much figure out which statement is being called looking at the method list. But the statement itself is never recorded
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

Could you please send the following information to [email protected]
1. The problematic snapshot file
2. The profiler agent log file (<user home>/.yjp/log/<session name>-<pid>.log)
3. A screenshot of the call tree which demonstrates the missing call.
vidj
Posts: 8
Joined: Fri May 09, 2014 12:29 pm

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by vidj »

Same thing with EAP build 14048.

What do you mean with:
3. A screenshot of the call tree which demonstrates the missing call.

Batch inserts and updates are performed by hibernate when I call EntityManager.flush() and call tree is OK! Problem is in Java EE statistics/SQL where batch inserts and updates are missing, all other sql-s are present. I don't understand how to demonstrate this with call tree screenshot?
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

and call tree is OK!
Please make a screenshot (a picture) of the profiler window when it shows this call tree. That is, we want to see what you see when you say the tree is OK. It's nice to have the picture to properly locate the calls you mean.

Have you sent the requested info (#1, #2) by email?
vidj
Posts: 8
Joined: Fri May 09, 2014 12:29 pm

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by vidj »

I just sent the e mail with requested files. I hope it will help!
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

What is the subject line of the email? I'm afraid I can't find it.
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

Now we see it. Thank you.
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

Could you please try profiling with the latest EAP build 14054:
http://www.yourkit.com/eap/

It should show batch SQLs in the "Java EE high-level statistics" view.
vidj
Posts: 8
Joined: Fri May 09, 2014 12:29 pm

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by vidj »

With latest EAP build 14054 it works!Thank you for really fast response!
Anton Katilin
Posts: 6172
Joined: Wed Aug 11, 2004 8:37 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by Anton Katilin »

Thank you for the feedback.
thyzz
Posts: 5
Joined: Tue May 06, 2014 9:50 am

Re: Batch SQLs are not visible in J2EE statistics / SQL

Post by thyzz »

Thanks Anton for the fast response!
Post Reply