ODBC queries against database views fail with errors


Description

Querying a database view using the ODBC driver fails and results in an error.  

Symptoms

When you issue a query against a database view, you receive one of the following error messages, depending on the version of the driver:    

Additionally, the instance log files contain the following entries:

Problem processing asynchronous servlet request: java.lang.StackOverflowError: com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:95)
com.glide.db.conditions.QueryCondition.clearJoins(QueryCondition.java:942)
com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)
com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)
com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)
com.glide.db.conditions.CompoundCondition.clearJoins(CompoundCondition.java:97)


Cause

An error in the underlying platform layer occurs. This error is independent of the ODBC driver.

Resolution

Set the BatchSize ODBC Administrator property value to 500. Values greater than 500 should be tested with your specific configuration.