db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leslie Software <lesliesoftw...@yahoo.com>
Subject ClassFormatError while performing a SQL insert
Date Thu, 07 Sep 2006 14:11:13 GMT
I received a ClassFormatError today while trying execute some insert SQL.  The SQL is quite
long and abridged versions succeed.  I have not examined my data closely yet but I will. 
Here is the full story:

In my database loading code I am working on updating a table (named ruling).  To do that the
code drops the table and then creates it again followed by inserting the data (as read from
an xml file).  The log contains the following

2006-09-07 13:21:26.067 GMT Thread[main,5,main] (XID = 5935), (SESSIONID = 1), drop table
ruling ******* null
2006-09-07 13:21:27.082 GMT Thread[main,5,main] (XID = 5935), (SESSIONID = 1), create table
ruling (ruling_id INT NOT NULL GENERATED ALWAYS AS IDENTITY CONSTRAINT ruling_pk PRIMARY KEY,
card_id INT, ruling_date DATE, ruling VARCHAR (1024), CONSTRAINT ruling_card_fk FOREIGN KEY
(card_id) REFERENCES card) ******* null
2006-09-07 13:21:28.911 GMT Thread[main,5,main] Wrote class org.apache.derby.exe.ac08264012x010dx8870x7dfdx0000000be0501
to file ac08264012x010dx8870x7dfdx0000000be0501.class. Please provide support with the file
and the following exception information: java.lang.ClassFormatError: Invalid method Code length
69936 in class file org/apache/derby/exe/ac08264012x010dx8870x7dfdx0000000be0501
 
I have stepped through my code and the exception comes after I attempt to execute the insert
sql that looks like this:
insert into ruling (card_id, ruling_date, ruling) values (1423,'2006-02-01','If your opponent
discards any cards during his or her cleanup step to get down to the maximum hand size, the
ability will trigger and players will receive priority. After that cleanup step ends, a new
one will begin and Abyssal Nocturnus’s effect will end. It won’t carry over into the next
turn.'), 
(1423,'2006-02-01','If your opponent discards multiple cards to a single effect, this will
trigger multiple times.'), 
(1587,'2006-07-15','Adarkar Valkyrie’s ability can target a token creature, but since token
creatures cease to exist when they leave play, it won’t be returned to play.'), 
(956,'2005-10-01','Attacking creatures (including Agrus Kos) that are both red and white get
+2/+2 until end of turn.'), 
(674,'2004-12-01','The “play this ability only once each turn” restriction applies even
if the creature changes controllers.'), 
(349,'2005-06-01','Akuta must already be in your graveyard as your upkeep begins in order
for its ability to trigger.'), 
(349,'2005-06-01','In multiplayer games, it checks for each opponent.'), 
(1589,'2006-07-15','You may pay the alternative cost rather than the card’s mana cost. Any
additional costs are paid as normal.'), 
(1589,'2006-07-15','Paying the alternative cost doesn’t change when you can play the spell.
A creature spell you play this way, for example, can still only be played during your main
phase while the stack is empty.'), 
(1589,'2006-07-15','If you don’t have two cards of the right color in your hand, you can’t
choose to play the spell using the alternative cost.'), 
...
(346,'2005-06-01','You choose the mode on announcement.'), 
(1424,'2006-02-01','AEtherplasm will return to your hand before any combat damage is assigned.'),

(1424,'2006-02-01','If you want, you can return AEtherplasm to your hand and not put anything
into play. The attacking creature will still be considered blocked, so it won’t be able
to deal combat damage to you unless it has trample or a similar ability.'), 
(1424,'2006-02-01','The creature you put into play may be the AEtherplasm you just returned
to your hand. This allows it to dodge abilities likeDeathgazer’s.'), 
(1424,'2006-02-01','The creature you put into play from your hand is blocking the attacking
creature, even if the block couldn’t legally be declared (for example, if that creature
comes into play tapped, or it can’t block, or the attacking creature has protection from
it).'), 
(1424,'2006-02-01','Putting a blocking creature into play doesn’t trigger “When this creature
blocks” and “When this creature becomes blocked” abilities. It also won’t check blocking
restrictions, costs, or requirements.')

the total sql statement contains 1742 lines

When I create the sql statement with the shortest 150 lines (only those lines where the ruling
text is < 80) instead all is well.  The maximum length of the ruling text is 700 characters
so I am well under the 1024 limit on the column.

Is this a known issue?  Is my SQL too long?  I plan to look closely at my data but at 1741
lines of values that will take a while.  

Any help or advice would be appreciated.

Thanks,

Ian


--
Ian Leslie - Shareware Author (mailto:lesliesoftware@yahoo.com)



Mime
View raw message