I am using jdk1.5,jboss4.0.5 and mysql5.0 technologies in my application.
In my application there is scenario to retrieve records from database and send them to server ,for this puspose we implemented thread class which will read data from table for every 5 seconds and send them to server. But after approximated 100 hours i am getting following exception. I am using InnoDB as a database engine in mysql
java.sql.SQLException: General error, message from server: "Out of memory (Needed 3453372 bytes)"
jvm memory is ok free memory is around 200MB
ava.sql.SQLException: General error, message from server: "Out of memory (Needed 3453372 bytes)"