db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Enyedi <robert.eny...@intland.com>
Subject Large IN clause produces server error
Date Tue, 14 Nov 2006 15:50:50 GMT
In the attached JUnit error log one can see that for an query containing 
an IN clause with 1800 items, Derby generates the following error:

java.sql.SQLException: Statement too complex. Try rewriting the query to 
remove complexity. Eliminating many duplicate expressions or breaking up 
the query and storing interim results in a temporary table can often 
help resolve this error. SQLSTATE: XBCM4: Java class file format 
limit(s) exceeded: method:e4 code_length (134022 > 65535) in generated 
class org.apache.derby.exe.ac8dd747d7x010exe6b4x4757x0000000d8160183.

If rewriting the query is not an option, what alternatives are there to 
overcome this limitation?


View raw message