Cannot see DBCP.DelegatingStatement on PurePath tree

Question

Question by Jose A. · Sep 02, 2015 at 07:59 AM ·

Cannot see DBCP.DelegatingStatement on PurePath tree

Hello! we are running a POC where we have found some SQL statements are not showed on PurePath Tree. It is related DBCP.DelegateStatement Class. No idea if we have to instrument any particular calls in order to get SQL statements visible.

We will upload an screenshot and small DT session

Thanks in advanced. Best regards,

JM

0 Show 2

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jose A. · Sep 02, 2015 at 08:01 AM 0

Share

dbcpdelegatingstatement.jpg

dbcpdelegatingstatement.jpg (218.6 KiB)

Jose A. · Sep 02, 2015 at 08:03 AM 0

Share

web-club-dia-prod-timeout-detalle-tienda.dts

web-club-dia-prod-timeout-detalle-tienda.dts (814.9 KiB)

Answer 1 · 2015-09-02T12:08:32Z

Best Answer

Answer by Roman S. · Sep 02, 2015 at 12:08 PM

Looking at the attached session - the PurePath timed out in the executeQuery method. Not suprised that in such a case we don't show all the information.

Can you try this with a PurePath on that application that does not run into a timeout? Or if they all do change the timeout - temporarily of course - to get a full one?

0 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 2 · 2015-09-02T16:43:11Z

Answer by Jose A. · Sep 02, 2015 at 04:43 PM

Thanks Roman. Here you are an example where you can see a purepath on same app with SQL statements

pp-example.jpg

Thanks in advance.

JM

pp-example.jpg (302.1 KiB)

0 Show 2 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Roman S. · Sep 02, 2015 at 04:55 PM 0

Share

Ok, so if that's the same app it seems to confirm the suspicion from my initial answer. The reason for not seeing SQLs is not problem with instrumentation but that the PurePath times out in the executeQuery method.

Jose A. Roman S. · Sep 09, 2015 at 09:37 AM 0

Share

So in that case, we should increase PurePath timeout to get SQL details at the end, right?

Cannot see DBCP.DelegatingStatement on PurePath tree

2 Replies

How to get started

NAM 2019 SP5 is available

LIVE WEBINAR

Follow this Question

Forum Tags