MySQL SchemaUpdate error

[DK-Warder]

I have got exception on SchemaUpdate with MySQL 5.1.31:

System.InvalidCastException: Specified cast is not valid.
at NHibernate.Tool.hbm2ddl.ColumnMetadata..ctor(DataRow rs)
at NHibernate.Tool.hbm2ddl.TableMetadata.AddColumn(DataRow rs)
at NHibernate.Tool.hbm2ddl.TableMetadata.InitColumns(ISchemaReader
meta)
at NHibernate.Tool.hbm2ddl.TableMetadata..ctor(DataRow rs,
ISchemaReader meta, Boolean extras)
at NHibernate.Tool.hbm2ddl.DatabaseMetadata.GetTableMetadata(String
name, String schema)
at NHibernate.Cfg.Configuration.GenerateSchemaUpdateScript(Dialect
dialect, DatabaseMetadata databaseMetadata)
at NHibernate.Tool.hbm2ddl.SchemaUpdate.Execute(Boolean script,
Boolean doUpdate)

My config:
<property
name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</
property>
<property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>

SchemaExport works fine.

[Fabio Maulo]

MySQL don't has a specific metadata provider implemented.

The work to create one is not so complicated; Take a look to src\NHibernate\Dialect\Schema and please send us a patch for your preferred RDBMS (MySQL).

Thanks.

2009/3/5 DK-Warder <dkwa...@gmail.com>

--
Fabio Maulo

[DK-Warder]

I have completed work. Patch was sent on nhibernate-development (at)
lists (dot) sourceforge.net

On 5 мар, 17:28, Fabio Maulo <fabioma...@gmail.com> wrote:
> MySQL don't has a specific metadata provider implemented.The work to create

> one is not so complicated; Take a look to src\NHibernate\Dialect\Schema and
> please send us a patch for your preferred RDBMS (MySQL).
>
> Thanks.
>

> 2009/3/5 DK-Warder <dkwar...@gmail.com>

[Tuna Toksoz]

Can you also send it to http://jira.nhforge.org

Tuna Toksöz
http://tunatoksoz.com
http://turkiyealt.net
http://twitter.com/tehlike

Typos included to enhance the readers attention!

2009/3/6 DK-Warder <dkwa...@gmail.com>

[DK-Warder]

Email was rejected... I forward it to nhibernate-
devel...@googlegroups.com

[DK-Warder]

http://nhjira.koah.net/browse/NH-1695

On 6 мар, 13:42, Tuna Toksoz <tehl...@gmail.com> wrote:
> Can you also send it tohttp://jira.nhforge.org
>

> Tuna Toksözhttp://tunatoksoz.comhttp://turkiyealt.nethttp://twitter.com/tehlike

>
> Typos included to enhance the readers attention!
>

> 2009/3/6 DK-Warder <dkwar...@gmail.com>

[Davy Brion]

applied in revision 4118, thanks

[Sushant]

Has this been applied to MS SQL (Compact Edition) or SQLite ? With
SchemaUpdate.Execute I get exactly the same error using both these
datatypes..

[Sushant]

Has this been applied to MSSQLCE and SQLite? I'm getting exactly the
same error on both when I use SchemaUpdate......

[Fabio Maulo]

on trunk NH2.1.0Alpha1 SQLite has Metadata classes for schema Update/Validation.

MsSQL Ce don't has metadata.

The work to create one is not so complicated; Take a look to src\NHibernate\Dialect\Schema and please send us a patch for your preferred RDBMS (MsSQL Ce).

Thanks

2009/3/17 Sushant <mpsk...@gmail.com>

Has this been applied to MSSQLCE and SQLite? I'm getting exactly the
same error on both when I use SchemaUpdate......

--
Fabio Maulo

[Sushant]

Here's the patch:

http://nhjira.koah.net/secure/attachment/12721/MsSqlCeMetaData.patch

On Mar 17, 6:19 pm, Fabio Maulo <fabioma...@gmail.com> wrote:
> on trunk NH2.1.0Alpha1 SQLite has Metadata classes for schema

> Update/Validation.MsSQL Ce don't has metadata.

> The work to create one is not so complicated; Take a look to
> src\NHibernate\Dialect\Schema and please send us a patch for your preferred
> RDBMS (MsSQL Ce).
> Thanks
>

> 2009/3/17 Sushant <mpsk2...@gmail.com>

[Fabio Maulo]

What happen ?

2 patches here 3 patches there... easy... easy...

The correct is the one of 5K ?

2009/3/18 Sushant <mpsk...@gmail.com>

--
Fabio Maulo

[Sushant]

Yes.. the 5 K one is correct.. sorry bout that .. lol :D

On Mar 18, 5:33 pm, Fabio Maulo <fabioma...@gmail.com> wrote:
> What happen ?2 patches here 3 patches there... easy... easy...

>
> The correct is the one of 5K ?
>

> 2009/3/18 Sushant <mpsk2...@gmail.com>