I have a client/server application that connects to a database (using Openbase which can be found at www.openbase.com
I was inserting a few thousand records into the database using a threaded process from the client application.
Basically the client code takes file input, converts everything to an insert statement and then using RMI it calls a method on the server that inserts the records to the database.
The process seems to work perfectly fine. However, there was two occasions where the mac machine (server machine) crashed while in this process. The process inserted roughly 20,000 records, then all of a sudden the mac locked up and said that I needed to restart the computer.
After the first time this happened, I went back and made sure all ResultSets and Statements were being closed properly to prevent a memory leak and increased the heap size to a gig. Then I tried it a second time and it happened again but at 25,000 records instead of 20,000.
Can anyone thing of any other reasons that this may occur?
If you guys don't have better suggestions, I'm going to try using a profiler of some sort to try and figure out what happened but not sure if this would even be the best approach because I'm uncertain if it was the database, my application, or some other factor that may have caused this.
Any suggestions are greatly appreciated!!