MySQL ORM problems

[Charles Collinson]

Just starting with ORM using the latest Delphi and hopefully the latest Kbmmw and having an issue with MySQL.

Using FireDac and the connection is working with normal queries but any attempt with ORM to access this through a connection pool gives me a ‘MetaExists(mwmdtTable) not supported or failed’.

Originally I was getting AV’ with commands like ORM.querylist, so took an example demo ORM and converted it from SQlite to MySQL but to no avail. Tried setting the metadata to several different metadata’s but makes difference. Is their a specific MySQL metadata, or am I missing something in the old demo’s?

Any pointers here to get me going with ORM would be appreciated.

 

 

 

[mrluigi2017]

Hi Charles,

Some things you might want to check:

1) Do you have a MetaData component attached to the kbmMWMySQLRewriter?
2) Do you have a kbmMWMySQLRewriter attached to the kbmMWFiredacConnectionPool?
3) Does the table name in your entity match the table name in MySQL [kbmMW_Table(‘name:person’)]
4) Make sure that the meta data component properties like “quote table name” etc. match your situation.

Kind regards,

Luigi

[Charles Collinson]

Luigi,

Much appreciated that got the ORM demo running in creating a table though it gave an integer not valid error when trying to create the indexes as per the demo. Progress at least and again thanks.

[Author]

Posts