Menu

#3 Executing Stored Procedures timeout during execution

open
nobody
None
5
2004-11-22
2004-11-22
freedumb87
No

When executing stored procedures using ORM in the
following way "DataSet ds =
StoredProcedures.PROC_NAME ();" I will get a timeout
error if it takes longer than 30 seconds.

Using the exposed "dm.CommandTimeout" property
doesn't work when using stored procedures.

The only way that I was able to extend the timeout was
to modify the StoredProcedures generated class and
change "private static DataManager dm;" to "public
static DataManager dm;" Then I could do something like
StoredProcedures.dm.CommandTimeout = ###;

So, my request would to be to expose the DataManager
object insided the StoredProcedures class.

Thanks.

Discussion


Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.