[Mondrian] SqlTupleReader.readTuples generates huge IN list causing java.sql.SQLException
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