teiid vdb with mysql data source

[paleris]

Hi i am new to Teiid and trying to build a MySQL data sources with vdb connect to these db servers.

So far i could get the data source and vdb running but for some DB, the vdb is fail to build the DDL schema for the mysql database, it show "No Content Available" in the JBoss Admin Panel model DDL tab, and show no error in server start up and reload VDB. The vdb is working fine if i change to other mysql schema with same mysql user and connection. 1. Are there a upper limit on the number of tables inside the MySQL schema? 2. will the mysql table engine type or encoding affect the Teiid on building the vdb?

Thanks a lot.

[rareddy]

Raymond,

1) There are no upper limits in number of tables that can be imported from MySQL or any other database.

2) You can connect to any type of MySQL engine. No restrictions. We used MyIsan, InnoDB before without any issues.

Based on your comments look like you have to sort of some user permission issues between your two instances of MySQL.

Ramesh..

[paleris]

Thanks for your reply.

It seems that the VDB and datasource is actually working and i can perform the test query on it.

It is just the JBoss EAP could not display the DDL schema for those datasource.

Are there any configuration property i could set to make the DDL Schema in JBoss EAP work again?

[rareddy]

There is no separate configuration for it, are you working with a Dynamic VDB or you built your VDB with Designer? were there any errors in log? If the VDB is working then metadata is loaded and it should provide the DDL without any issues.

Ramesh..