Error with execution plan for "ALTER SESSION.."

[GoogleCodeExporter]

What steps will reproduce the problem?

My application using SQL like: "ALTER SESSION set NLS_DATE_FORMAT = 
'DD/MM/YYYY'"; and similar to them.
The problem is when javamelody try to do execute plan of this query.


What is the expected output? What do you see instead?

No need execution plans for query like this. Now we get sql error in execute 
plan.


What version of the product are you using? 

javamelody-1.31 

Please provide any additional information below.

I done quick fix for this (attached), but probably better will be to create 
list with "Ignored SQL" and add there SQL starts like "explain", "alter"  (and 
maybe some more). This list should be checked ignoring case.

Original issue reported on code.google.com by Stun...@gmail.com on 17 Oct 2011 at 7:49

Attachments:

• JdbcWrapper.java

[GoogleCodeExporter]

I think that excluding "alter..." from monitored requests is not needed and 
that it is only needed to exclude "alter..." from execution plans. And also, 
executing toLowerCase().startsWith("alter...") on every executed sql request 
may use too much cpu.

So it is fixed and committed in trunk (revision 2259) and ready for the next 
release (1.33).
If you want to test it, I have made a new build from the current trunk and it 
is available at:
http://javamelody.googlecode.com/files/javamelody-20111018.jar

Original comment by evernat@free.fr on 18 Oct 2011 at 9:57

• Changed state: Fixed