"Exceeded maximum number of sections 32K"
It seems to me that you may be suffering from a resource leak of some kind. Can you check to make sure that you are closing all of your ResultSets, Statements, and Connections as soon as you are finished with them? Also, tell us a bit more about your application: What version of Derby are you running? Is it running embedded, or client/server? How long can you run before you see this problem? Is the problem always on the same SQL statement or does it vary? thanks, bryan