[DERBY-1714] huge single insert statements fail with JVM error due to size of generated method

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.3.1
• Fix Version/s: 10.2.1.6, 10.3.1.4
• Component/s: SQL
• Environment: debian linux, sun java j2sdk 1.5
• Urgency: Normal
• Assignee: Daniel John Debrunner
• Reporter: Julian Morrison
• Created: 17/Aug/06 13:19
• Updated: 13/Dec/07 09:05
• Resolved: 21/Aug/06 01:13

Description

ERROR XBCM1: Java linkage error thrown during load of generated class org.apache.derby.exe.ace5214067x010dx1c21xe385x00000011be005.
ERROR XJ001: Java exception: 'Invalid method Code length 68686 in class file org/apache/derby/exe/ace5214067x010dx1c21xe385x00000011be005: java.lang.ClassFormatError'.

The above occurred when doing an insert statement using the mutiple row syntax "INSERT INTO foo (...) VALUES (...), (...) ..." for huge amounts of input data. I was able to insert 500 rows at once, but it balked at 1000.

Workaround: chunk one huge insert into several merely big inserts before sending them to Derby.

Issue Links

• relates to: DERBY-766 Improve code generation to handle 5000 unions in a select the union test in largeCodeGen