DAO.Recordset [3077] error: XML Schema import

[Guillaume]

Hi,

I starting using the Schema composer and XML Schema import features as I need to import XSD files (not generated with EA).
As I had error messages, I created my own XSD using the Schema composer (using Rodrigo's blog http://bit.ly/1E3ylWs).

When I run an XML Schema import from the EA generated XSD, I still get the following error:
DAO.Recordset [3077]
Syntax error (missing operator) in expression.

I'm using the latest 1215 build from EA12 with an EAP file.

[Eve]

The error is bad sql. You'll need to get %appdata%\Sparx Systems\ea\DBError.txt and send it to Sparx support.

[Guillaume]

Thanks Simon, I wasn't aware of this file which is handy.
I noticed that it is reset everytime there's a new error (it is only possible to see the previous SQL error).

I will send the error to support.

[Guillaume]

I keep getting the same error with the following information showing in DBError file:

28/08/2015 09:24:59
DAO.Recordset [3077]

Syntax error (missing operator) in expression.

Context:
      SQL: select * from t_object where Stereotype='XSDschema' and Object_Type='Package'

Sparx Support hasn't been able to reproduce this issue so I'm still stuck

[Eve]

Just looked up that query.

I'm reasonably confident that the issue is that your file path contains an apostrophe.

Edit - Just tested it, adding an apostrophe when importing into an eap file that already contains XSDschema packages causes the problem.

[Guillaume]

Well spotted!

Removing the apostrophe from my folder's name fixed the issue.

Thanks Simon.

[Geert Bellekens]

Hmm, sounds like the input is not properly escaped.
You better not name your file ';drop table t_object  

Geert