[Mondrian] SqlTupleReader.readTuples generates huge IN list causing java.sql.SQLException

Julian Hyde julianhyde at speakeasy.net
Wed Jun 20 19:45:30 EDT 2007

> Step 2 will fail, because it creates a SQL statement that is 8,377,847
> characters long!
> The JDBC driver fails with "java.sql.SQLException: No more 
> data to read
> from socket"

Judging by that error message, the query crashed Oracle. Well done! :)

We have a property which is supposed to control this. Can you try
setting the property mondrian.rolap.maxConstraints=100 and see if the
query behaves differently?

What version of mondrian/oracle are you using?


More information about the Mondrian mailing list