Products

Home Forums eaDocX queries Accessing Repository causes error Accessing Repository causes error

Home Forums eaDocX queries Accessing Repository causes error Accessing Repository causes error

#7582
eadocX Support
Participant

When eaDocX accesses the EA repository directly – which it has to do because there aren’t the required APIs in EA – it uses upper-case table names. This works OK in all the major DBMSs, when they are configured normally. We’ve tried it with SQLServer, Oracle, MySQL and EAP files.
BUT, we know that it is possible to configure some DBMSs so that they are case sensitive, so, we issue SQL to look at T_OBJECTS, and it only has a t_objects table.
We have so far not found a pattern to when this happens, and it would be a MAJOR change to eaDocX to allow for case-sensitive SQL, as we will have to parse the results in mixed case as well.
So, have a look at the case sensitivity of your DBMS.
Also, EA itself seems to be OK with this, it’s just SQL issues via EA which has the problem.

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