search

oibo8x / subsonicproject

Automatically exported from code.google.com/p/subsonicproject
0 stars 0 forks source link

Codegeneration fails if it exceeds 60 secs #94

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I use MySQL and since I added the last few tables I cannot create the DAL
anymore.

Problem: SubSonic.QueryCommand has a fixed defaultvalue for the QueryTimeout:

private int commandTimeout = 60;

I havent found a way to set the default command timeout from provider
settings in app/web.config

I encountered crashed because of a query timeout a time ago with
Migrations, but in this case I just tweaked my connection string to
override the default command timeout (I think 30s for mysql):
connectionString="Server=server;Database=mydb;Uid=admin;Pwd=superconfidentialpas
sword;default
command timeout=180"

But that does not work for Code generation, because the CommandTimeout
defaults to 60.
For now I changed the codo to

private int commandTimeout = 120;

(Which will hopefully last til subsonic3 stable is out :-)

Maybe I add a 'defaultCommandTimeout="120"' parameter to the Provider
config / subcommander if I have enough time.

Original issue reported on code.google.com by j.steinblock@gmail.com on 29 May 2009 at 8:33