ERROR 42ZA0: Statement too complex.
What version of Derby are you using? If it is prior to 10.2, upgrading to 10.2 may help. As Dan says in http://mail-archives.apache.org/mod_mbox/db-derby-dev/200612.mbox/[EMAIL PROTECTED]
"Derby's SQL statements are compiled to Java byte code. The limits in Java byte code lead to limits on the complexity of statements that Derby can handle. " You can find an enormous amount of background material about the Derby internals of this limit by following the threads at http://mail-archives.apache.org/mod_mbox/db-derby-dev/200602.mbox/[EMAIL PROTECTED] and also looking at these Derby issues: http://issues.apache.org/jira/browse/DERBY-766 http://issues.apache.org/jira/browse/DERBY-176 Hope this helps! thanks, bryan
