cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

JDBC Bind Value Maximum Length

Jeff_13
Visitor

We're on version 1.234.118.20220211-112119 of Oneagent. We've noticed some bind values being truncated when reviewing PurePaths. It usually occurs on XML data. What is the current maximum length for bind values? Is there to increase it?    

2 REPLIES 2

AntonioSousa
DynaMight Guru
DynaMight Guru

@Jeff_13,

Interesting question. Documentation doesn't reveal the limit:

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/support-for-sql-bind-variables

If you have access to a truncated bind value in a Purepath, you can copy & count. Please beware that the best way is to look at the code, as for instance two consecutive spaces will count only as one in HTML. This has tricked me in the past in other contexts...

Antonio Sousa

Julius_Loman
DynaMight Guru
DynaMight Guru

It's a setting of the JDBC Sensor, not visible for the customers, unfortunately. Reach to DTONE via in-product chat to get the value for you.

However, it's a better way to capture the information from the application code and not capture whole bind variables unless it's really necessary.

Certified Dynatrace Master | TEMPEST a.s., Slovakia, Dynatrace Master Partner