SqlQuery: Different behaviour when access DB Vs a

[derekwallace]

Hi,
We host our EA models in a MySQL DB.
I have created a shortcut .eap file to the DB.

When i run a Java program to perform a SqlQuery of the DB (via the shortcut .eap) file it works correctly.

org.sparx.Repository oRepos = new org.sparx.Repository()
oRepos.OpenFile(sReposName);

String sSqlQuery  = "SELECT t_object.ea_guid AS GUID  FROM t_object";
String sTmp = oRepos.SQLQuery(sSqlQuery);
System.out.println(sTmp);




If i "transfer" the DB to a .eap project (to create a local copy) with the
Tools - Data Management - Project Transfer
and re-run the same JAVA program to do a SqlQuery it returns the following with no data.
<?xml version="1.0"?>
<EADATA version="1.0" exporter="Enterprise Architect">
</EADATA>



Does the SQL query need to change depending on the database behind the scenes?

Thx
Derek

[KP]

Does the SQL query need to change depending on the database behind the scenes?

Yes, there are lots of subtle differences between varieties of SQL. For example, "GUID" is a reserved word in MS Access SQL so you need to put it inside square brackets:

Code: [Select]

SELECT t_object.ea_guid AS [GUID]  FROM t_object
It would probably help to test your queries first in EA's custom SQL query builder (Ctrl+Alt+A, click "Builder" and open the "SQL" tab).

[derekwallace]

thx.
Confirmed this works for MS and MySQL
SELECT t_object.ea_guid AS [GUID]  FROM t_object

[Geert Bellekens]

Better yet would be to avoid keywords in (alias) names altogether.

Geert