r1269 and mysql

0 views
Skip to first unread message

Sharique

unread,
Nov 11, 2009, 7:13:42 AM11/11/09
to DbLinq
I have checked out latest dblinq r1269. I'm testing it for mysql. I
found northwind mysql script is missing in tests folder.

Second thing : I run dbmetal against drupal 7 dev version database. I
got following error

DbMetal failed:System.ArgumentException: Don't know how to convert the
SQL type 'mediumtext' into a managed type.
Parameter name: dataType
at DbLinq.Vendor.Implementation.SchemaLoader.MapDbType(String
columnName, IDataType dataType) in h:\soft\dot net\dblinq\src\DbLinq
\Vendor\Implementation\SchemaLoader.TypeMapping.cs:line 217
at DbLinq.Vendor.Implementation.SchemaLoader.LoadColumns(Database
schema, SchemaName schemaName, IDbConnection conn, INameAliases
nameAliases, NameFormat nameFormat, Names names) in h:\soft\dot net
\dblinq\src\DbLinq\Vendor\Implementation\SchemaLoader.cs:line 430
at DbLinq.Vendor.Implementation.SchemaLoader.Load(String
databaseName, INameAliases nameAliases, NameFormat nameFormat, Boolean
loadStoredProcedures, String contextNamespace, String entityNamespace)
in h:\soft\dot net\dblinq\src\DbLinq\Vendor\Implementation
\SchemaLoader.cs:line 122
at DbMetal.Generator.Implementation.Processor.ReadSchema(Parameters
parameters, ISchemaLoader& schemaLoader) in h:\soft\dot net\dblinq\src
\DbMetal\Generator\Implementation\Processor.cs:line 218
at DbMetal.Generator.Implementation.Processor.ProcessSchema
(Parameters parameters) in h:\soft\dot net\dblinq\src\DbMetal\Generator
\Implementation\Processor.cs:line 112
--
Sharique

Jonathan Pryor

unread,
Nov 11, 2009, 9:30:43 AM11/11/09
to dbl...@googlegroups.com
On Wed, 2009-11-11 at 04:13 -0800, Sharique wrote:
> I have checked out latest dblinq r1269. I'm testing it for mysql. I
> found northwind mysql script is missing in tests folder.

No one has "stepped up" to be the MySQL maintainer, so
instnwind.SqlServer.sql hasn't been ported yet.

Interested in helping? :-)

> Second thing : I run dbmetal against drupal 7 dev version database. I
> got following error
>
> DbMetal failed:System.ArgumentException: Don't know how to convert the
> SQL type 'mediumtext' into a managed type.

Please update to r1270.

Thanks,
- Jon


Sharique uddin Ahmed Farooqui

unread,
Nov 12, 2009, 9:55:46 AM11/12/09
to dbl...@googlegroups.com
I have posted initial port of mysql northwind in issue list.

I checked r1270 and it is working.
> --~--~---------~--~----~------------~-------~--~----~
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.
> To post to this group, send email to dbl...@googlegroups.com
> To unsubscribe from this group, send email to
> dblinq+un...@googlegroups.com
> For more options, visit this group at
> http://groups.google.com/group/dblinq?hl=en
> -~----------~----~----~----~------~----~------~--~---
>
>


--
Sharique uddin Ahmed Farooqui
(C++/C# Developer, IT Consultant)
http://safknw.blogspot.com/
"Peace" is the Ultimate thing we want.

Jonathan Pryor

unread,
Nov 12, 2009, 10:22:05 AM11/12/09
to dbl...@googlegroups.com
On Thu, 2009-11-12 at 20:25 +0530, Sharique uddin Ahmed Farooqui wrote:
> I have posted initial port of mysql northwind in issue list.

I noticed, and thank you!

I do wonder what the "errors in insert statements" are, though. Does it
actually work, or not? (Rephrased: is it in a state suitable for adding
to svn w/o getting lots of messages to the list complaining that it
doesn't work? :-)

Thanks!
- Jon


Sharique uddin Ahmed Farooqui

unread,
Nov 12, 2009, 11:19:47 PM11/12/09
to dbl...@googlegroups.com
Create statements works, insert statements have errors, which i'll fix
in few days.
> --
>
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.
> To post to this group, send email to dbl...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/dblinq?hl=.
>
>
>

--
Sent from my mobile device

Sharique uddin Ahmed Farooqui

unread,
Nov 14, 2009, 2:33:35 PM11/14/09
to dbl...@googlegroups.com
Hi,

Here is the working sql script.
--
instnwnd.mySQL.sql.zip

Jonathan Pryor

unread,
Nov 16, 2009, 9:57:52 AM11/16/09
to dbl...@googlegroups.com
On Sun, 2009-11-15 at 01:03 +0530, Sharique uddin Ahmed Farooqui wrote:
> Here is the working sql script.

This has been added to svn, r1273.

Thanks!
- Jon


Sharique uddin Ahmed Farooqui

unread,
Nov 17, 2009, 11:57:28 AM11/17/09
to dbl...@googlegroups.com
Thanks.
This script does not contains stored procedures. Which I hope to port
in next few days.
I posted file here because code google does not have option to attach
file in comment. I hope they will add this feature soon.
> --
>
> You received this message because you are subscribed to the Google Groups
> "DbLinq" group.
> To post to this group, send email to dbl...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/dblinq?hl=.
>
>
>


--
Reply all
Reply to author
Forward
0 new messages