MySQL 5.1 Server error

Hi,

I'm trying to import data-base tables from MySQL and I am encountering the following exception:

Exception while processing Server Explorer drag: System.InvalidCastException: Specified cast is not valid.
   at Mindscape.LightSpeed.Generator.Extraction.MySql5.<GetColumns>d__0.MoveNext()
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.PopulateEntityFields(TConnection connection, String tableName, EntityModel entity)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.CreateEntity(TypeModel model, TConnection connection, Dictionary`2 entities, String tableName, Boolean pluralise)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.CreateEntities(TypeModel model, TConnection connection, Boolean pluralise)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.PopulateTypeModel(TypeModel model, TConnection connection, Boolean pluralize)
   at Mindscape.LightSpeed.Generator.Extraction.Provider`1.ExtractModel(Boolean pluralise)
   at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.PopulateTypeModel(ProviderType providerType, String connectionString)
   at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.PopulateTypeModel(IDbConnection connection)
   at Mindscape.LightSpeed.Generator.Integration.EntityBuilder.AddTablesToModel(Model model, IDbConnection connection, IEnumerable`1 tableNames, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.LightSpeedModelDiagram.<>c__DisplayClass4.<OnDragDrop>b__3(DragObject dragObject, IGenerationLog log)
   at Mindscape.LightSpeed.Generator.Integration.ServerExplorer.IfIsServerExplorerDrag(DragEventArgs e, DragAction action)

I'm using Visual Studio 2008, SP1, on two different machines:

Vista x64

Windows XP x64.

What gives?

I'm sorry you're seeing these problems.  We do try to test as widely as possible, and we have customers using LightSpeed on SQLite and MySQL.

I've run through our MySQL tests and I have been unable to reproduce the problem you're seeing.  I have tried this on XP x86 and Vista x64 with the current GA releases of MySQL Connector (5.2.3) and the MySQL server (5.0).  Are these the same versions that you are using?  Are you using the InnoDB or MyISAM engine?  Could you send us a copy of your database schema?

Thanks for helping us to track this down, and once again we're sorry your first experiences with LightSpeed haven't been good ones. 

 Hey,

Sorry about that. I was venting out. Nothing's been working for the last 72 hours or so.

I'm using:

Vista x64, SP1, Visual Studio 2008 SP1, MySQL 5.1.26-rc, INNODB , MySQL Connector 5.2.3 (Which is the only thing that works with VS 2008 anyways).

 Yes I can send you guys the schema... What e-mail should I forward it to?

Don't worry about the schema -- the problem appears to be the database server version.  It looks like MySQL 5.1 has a change in the way it reports the database schema which is causing our code to break.  I'll aim to get it fixed in the next nightly.  Thanks for letting us know about this!

Okay, I have now committed a fix for this and it will be in the next nightly build (available after about 1800 GMT).

This fixes only the issue with bringing MySQL tables into the LightSpeed designer.  Please be aware that there seem to be some further compatibility issues between our schema round-tripping feature and MySQL 5.1, which we have not yet resolved.  Specifically, if you create an association in the designer, and then perform an Update Database to create the corresponding column and foreign key in the MySQL 5.1 database, you will probably get the dreaded error 150.  I will look into this; let me know if it is a priority for you.  (The other direction, updating the model from the source database, works okay with 5.1.)

Please let us know if you still see problems.

Thanks for the fix and the warning.

Most of my schema is actually generated with by hand or MySQL workbench for the time being.

I'll make sure I don't try something like that!

Looking forward to the build...