I am using the Ruby/mysql module installed from gems and everything is
working fine except the connections arent closing. I was under the
impression that upon completion of a script the database handle will
close automatically but regardless even by explicitly stating
dbh.close() at the end of the script I cant get the database to close
the connection. This is obviously a problem as the limit of connections
is eventually reached.
I am running apache2 on ubuntu 7.10, I am calling the ruby script (that
connects and queries the database) from embedded ruby in an .rhtml file.
I do not have the code available right now as I am posting from another
computer but can post the code if anyone thinks it will help.
Any help appreciated,