search

sougatamondal / migratordotnet

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

CommandTimeout broken for MySql provider (unsupported by driver) #53

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
>What steps will reproduce the problem?
1. Run Migrator Console with a MySql provider and connect string. Or, run
the unit tests against MySql.

>What is the expected output? What do you see instead?
Expect migrations to be applied.  However, an error appears that indicates
that set CommandTimeout is not supported.  I imagine this is due to the
recent patch to issue 48.

>What version of the product are you using? On what operating system? With
what .NET implementation/version?
0.8 from SVN.  .NET 2.0.

>What database and version are you seeing this issue on?
MySQL 5.0

According to MySql's documentation, commandtimeout is not supported.
http://dev.mysql.com/doc/refman/5.0/en/connector-net-examples-mysqlcommand.html#
connector-net-examples-mysqlcommand-commandtimeout

Original issue reported on code.google.com by evon...@gmail.com on 8 Aug 2008 at 2:09

GoogleCodeExporter commented 8 years ago 
I have changed the IDbCommand in TransformationProvider back to not using a 
CommandTimeout.

I dont have time to do it at the moment and I am going on vacation next week, 
but 
all that would need to be done here is override 
TransformationProvider.BuildCommand 
in each Provider impl. Then we can add the CommandTimeout to any database 
connections that support it.

Original comment by dko...@gmail.com on 8 Aug 2008 at 11:03

GoogleCodeExporter commented 8 years ago 
Patch attached for SqlServer to re-add the 90s timeout without affecting other 
providers.

Original comment by evon...@gmail.com on 9 Aug 2008 at 7:27

Attachments: