Table ..t_xrefSystem doesn't exist

This topic has 2 replies, 2 voices, and was last updated 10 years, 5 months ago by Andreas Jehle.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
24 June 2014 at 6:07 am #7707

Andreas Jehle
Participant

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

24 June 2014 at 8:33 am #7708

eadocX Support
Participant

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?

24 June 2014 at 8:48 am #7709

Andreas Jehle
Participant

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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Compare licence prices

Choose the licence that’s right for you and your team

Prices

Download a free trial

Download eaTeamWorks today for several free for life features, plus no obligation, 30-day trials of all the products: eaDocX, ea Revision Manager, eaSheets, Model Expert and PortfolioManager. Discover for yourself why we sell the world’s best-selling Enterprise Architect extension.

Download