Rails - Nov 2005 - connection failure when SQL server is reset

Hey guys,

I have a rails app using SQL Server. The application server has Win2000,
Apache 2 + scgi. The database server is Win2000 + SQL Server. When the
database server is rebooted, the rails application returns the following
error: Connection failure: connection reset by peer. Now, I have no control
over when the database gets rebooted, that is in the hands of the db folks.
It seems to me that rails likes to open a db connection and keep it open for
the lifetime of the rails app. In the event of a reboot, it throws back an
error, as it still thinks it has a connection. Is there any way workaround
for this?

Thanks,

Jin


_______________________________________________
Rails mailing list
Rails-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org
http://lists.rubyonrails.org/mailman/listinfo/rails

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Nov 8, 2005, at 9:40 AM, Jin Lee wrote:
> I have a rails app using SQL Server. The application server has  
> Win2000, Apache 2 + scgi. The database server is Win2000 + SQL  
> Server. When the database server is rebooted, the rails application  
> returns the following error: Connection failure: connection reset  
> by peer. Now, I have no control over when the database gets  
> rebooted, that is in the hands of the db folks. It seems to me that  
> rails likes to open a db connection and keep it open for the  
> lifetime of the rails app. In the event of a reboot, it throws back  
> an error, as it still thinks it has a connection. Is there any way  
> workaround for this?
Please see
   http://dev.rubyonrails.org/ticket/428
and
   http://dev.rubyonrails.org/ticket/1697

jeremy
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (Darwin)

iD8DBQFDcQB/AQHALep9HFYRAok9AJ9Psgd0roNTslOoBItxdBoFXJYV0gCfdWRf
wYI9lHH5gpJ/nyrXABwIhUY=fb0F
-----END PGP SIGNATURE-----