[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

ruby/mysql connection close problem

Adam Hurlburt

10/20/2008 6:07:00 PM

Hello,

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,

Thanks
--
Posted via http://www.ruby-....
1 Answer

Roger Pack

10/21/2008 3:23:00 AM

0

> 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,
>
> Thanks


I suppose if you got really desperate you could use mysqlplus then hard
force close the connection.

descriptor_number = conn.socket
a = IO.new(descriptor_number)
a.close
Maybe.
-=R
--
Posted via http://www.ruby-....