Batch SQLs are not visible in J2EE statistics / SQL
-
- Posts: 8
- Joined: Fri May 09, 2014 12:29 pm
Batch SQLs are not visible in J2EE statistics / SQL
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.
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
-
- Posts: 5
- Joined: Tue May 06, 2014 9:50 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
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)
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)
-
- Posts: 5
- Joined: Tue May 06, 2014 9:50 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
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
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
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
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.
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.
-
- Posts: 8
- Joined: Fri May 09, 2014 12:29 pm
Re: Batch SQLs are not visible in J2EE statistics / SQL
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?
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?
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
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.and call tree is OK!
Have you sent the requested info (#1, #2) by email?
-
- Posts: 8
- Joined: Fri May 09, 2014 12:29 pm
Re: Batch SQLs are not visible in J2EE statistics / SQL
I just sent the e mail with requested files. I hope it will help!
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
What is the subject line of the email? I'm afraid I can't find it.
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
Now we see it. Thank you.
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
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.
http://www.yourkit.com/eap/
It should show batch SQLs in the "Java EE high-level statistics" view.
-
- Posts: 8
- Joined: Fri May 09, 2014 12:29 pm
Re: Batch SQLs are not visible in J2EE statistics / SQL
With latest EAP build 14054 it works!Thank you for really fast response!
-
- Posts: 6172
- Joined: Wed Aug 11, 2004 8:37 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
Thank you for the feedback.
-
- Posts: 5
- Joined: Tue May 06, 2014 9:50 am
Re: Batch SQLs are not visible in J2EE statistics / SQL
Thanks Anton for the fast response!