db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: query complexity error ERROR 42ZA0
Date Mon, 25 Jun 2007 21:18:45 GMT
> 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/%3C457D8A74.1070306@apache.org%3E

   "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/%3C43E444F2.7080003@apache.org%3E
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



Mime
View raw message