JDBC Bind Value Maximum Length

[Jeff_13]

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?    

[AntonioSousa]

@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...

[Julius_Loman · Accepted solution]

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.