mORMot Open Source

bigheart

Member

Registered: 2014-08-01

Posts: 54

CreateMissingTables function return error for MySql

Hello,

When i connect the DB and execute CreateMissingTables(), then error is returned as below:

  TMyOrm = class(TOrm)
  private
    FCode: RawUTF8;
    FCode_name: RawUTF8;
    FCheck_item: Boolean;
  published
    property Code: RawUTF8 index 10 read FCode write FCode;
    property Code_name: RawUTF8 index 80 read FCode_name write FCode_name;
    property Check_item: Boolean read FCheck_item write FCheck_item;
  end;

FConnectProp := TSQLDBZEOSConnectionProperties.Create(
    TSQLDBZEOSConnectionProperties.URI(dMySQL, FHostIp + ':' + FPort), FDBName, FUserId, FPasswd);
  
FModel := TOrmModel.Create([TMyOrm]);
VirtualTableExternalRegisterAll(FModel, FConnectProp);

FOrmServer := TRestServerDB.Create(FStockBaseModel, SQLITE_MEMORY_DATABASE_NAME, False);

FOrmServer.CreateMissingTables(); <== Here is exception occurred 'Unknown MySQL data type!'

**) The actual return error funtion is ConvertMySQLHandleToSQLType() in ZDbcMySqlUtil.pas

Help me how to solve this problem.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,253

Website

Re: CreateMissingTables function return error for MySql

Sounds more like a ZDBC issue than a mORMot issue...

What is the SQL executed at that time on MySQL?
Which version on ZDBC are you using?
On which OS and which compiler?

bigheart

Member

Registered: 2014-08-01

Posts: 54

Re: CreateMissingTables function return error for MySql

OS: windows 10
Delphi : XE5
ZeosLib : 7.3

SQL : "show variables like '''version''"

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 15,253

Website

Re: CreateMissingTables function return error for MySql

This is a Zeos/ZDBC statement.
Try a newer version of Zeos.

You may ask on the Zeos forum for assistance.
https://zeoslib.sourceforge.io/viewforu … ed8232f730