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


 

Forums >

comp.lang.ruby

DBI Timeout

greg.kujawa

2/28/2007 3:18:00 PM

I am currently trying to retrieve a rather large recordset from a
remote MS SQL Server. The recordset is retrieved using Ruby DBI. The
recordset is roughly 120,000 rows. The Ruby script bombs out with an
SQL timeout error. Is there a parameter I can use to extend the
timeout value in the DBI library so that I can pull everything?
4 Answers

greg.kujawa

2/28/2007 5:17:00 PM

0

On Feb 28, 10:17 am, "gregarican" <greg.kuj...@gmail.com> wrote:
> I am currently trying to retrieve a rather large recordset from a
> remote MS SQL Server. The recordset is retrieved using Ruby DBI. The
> recordset is roughly 120,000 rows. The Ruby script bombs out with an
> SQL timeout error. Is there a parameter I can use to extend the
> timeout value in the DBI library so that I can pull everything?

Specifically I am using the dbd_ado DBI library. Since the fetch_all
method was timing out (the DB is alive and kicking; I've verified
that) I tried while-looping a fetch method to append to the result
array as an alternative. Either way the operation still times out :-(

khaines

2/28/2007 5:48:00 PM

0

greg.kujawa

2/28/2007 5:52:00 PM

0

On Feb 28, 12:48 pm, khai...@enigo.com wrote:
> On Thu, 1 Mar 2007, gregarican wrote:
> > Specifically I am using the dbd_ado DBI library. Since the fetch_all
> > method was timing out (the DB is alive and kicking; I've verified
> > that) I tried while-looping a fetch method to append to the result
> > array as an alternative. Either way the operation still times out :-(
>
> It sounds to me like the timeout is coming from the database. Do you have
> a full stack trace for the exeption?
>
> Kirk Haines

It is definitely coming from the database. Right now I'm trying to
narrow down how to specify a CommandTimeOut parameter for the ADO
conncection. My provider is SQLOLEDB. It's not specified in the
connection string, I know that at least. But it's a property of the
ADO connection itself. I know how to do this in VB, VBScript, C#, etc.
but not using the Ruby DBI implementation.

khaines

2/28/2007 6:12:00 PM

0