Bryan,
thanks for your advice. Here in Brazil is nightime now, so Ill try it
tomorrow morning and Ill let you know.
Thanks again,
Francisco Trindade
Bryan Pendleton escreveu:
pesagens1_.PESAGEM_ID=pesagem2_.PESAGEM_ID where (animal0_.ANIMAL_ID in
( ... 800 ids ...))
Quite possibly, you are being affected by DERBY-47:
http://issues.apache.org/jira/browse/DERBY-47
Since we believe that this problem has been fixed in Derby 10.3,
it would be wonderful if you could download the DERBY 10.3 beta
release from http://wiki.apache.org/db-derby/DerbyTenThreeRelease
and give it a try to see how it affects your query.
thanks,
bryan
P.S. Myrna, I noticed that it was a bit hard to find a good
hyperlink to the beta release. Perhaps you could put a
link to the 10.3 beta on http://db.apache.org/derby/
and/or http://db.apache.org/derby/derby_downloads.html
as those would be natural places to look? Or are we
not supposed to do that because it's still a beta release?
