Skip to main content

Not sure if this is the right forum for this.  We recently started using the Data Virtualization Driver v3.1 and are getting a stack overflow that crashes our application every 10 minutes or so in production.  After some research I determined it's due to parameterized queries.  The parameter info is being cached by the driver in the connection pool until it reaches some limit and crashes with a stack overflow error.  If I turn off connection pooling, or hard-code the values into the query instead of properly parameterizing it, it stops crashing.  But I'd rather not do those things if I can help it. 

I can easily recreate the error in our lower environments by loading up a query that parameterizes 200 parameters, and then setting it to run 100 times in sequence.  Our production users aren't plugging in that many parameters, but are hitting the cache limit through sheer volume of queries instead.

Are there any connection string settings or driver settings that we can change the avoid this crash?  I've looked into it for awhile but nothing I've tried works.  We upgraded to this driver from the older DataDirect drivers from Progress.  The same queries in those drivers do not crash.