Table ..t_xrefSystem doesn’t exist

[Andreas Jehle]

Hello,

I’m currently evaluating eaDocX for usage in our project. We have set up our model in EA using odbc and mysql on a Linux machine.

While we have no problem in document generation with eap files – we run into errors when trying this on our operational model using odbc connection.

As soon as we try to use the “insert” pulldown of eaDocX we will get the error message
“Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC5.2(w)][mysqld-5.1.73] Table “project.t_xrefSystem” doesn’t exist.

It seems to be a upper/lower case problem in trying to access the mysql tables.

Is there any recommended solution for this problem?

regards
Andreas

[eadocX Support]

Hi Andreas,
The simplest solution to this is to use all upper-case table names. This issue seems to happen when we install MySQL onto Linux servers, which seem to default to lower-case names AND also case about the case of any SQL which they receive. On Windows MySQL implementations – which is how we test MySQL – everything is OK, as the Windows implementation seems to be relaxed about the case of table names.
Are you using Linux?

[Andreas Jehle]

Yes we use Linux.
Is there any difference to use all upper-case table names or to use all lower-csae table names or doesn’t it matter which of these 2 configurations will be used.

Currently we have on Linux the following setting in mysql.

mysql> show variables like “lower_case_table_names”;
+————————+——-+
| Variable_name | Value |
+————————+——-+
| lower_case_table_names | 0 |
+————————+——-+

It seems to be the case that EA has created all table names in lower case – so we think that it might be a good idea to set the value of the variable lower_case_table_names to 1.

[Author]

Posts