for a long time I've been avoiding forums because most of the things are already solved :) But now I am stuck. I made an application. It consists of simple animation and reading/writing to DB. I run it on xUbuntu with java6, apache and mysql (from repos)
I read status from DB every 5 - 10 sec and write to DB if the button is pressed.
Every thing works OK, but after 6, 7 hours the animation gets stuck and button response is slow (first insert into DB is OK but the next one can be done 5 or more sec. later). Reading from DB is normal. I guess I have a DB connection problem?
Somewhere I read that closing the statement and connection can be omitted so i didn't closed it. Maybe this is the problem?
Connection is made to localhost so actually connecting and closing isn't such a big problem...