Execute Query failed: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

[rodbastidas]

Hi everyone!

I'm very new in Thingworx, I have an Oracle Database setup as a thing, and when creating a service as a SQL Query I can see all of the tables within the database (so I have a connection) however, when I try to run a query I get the following error message:

Execute Query failed: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

Thanks in advance

[mnarang]

Can you please paste the query you are trying .It is because of there is some inappropriate clause in your query .

[rodbastidas]

It's a simple query, select * from <table_name>;

[hchanana · Accepted solution]

@rodbastidas

Please try executing the query without semi-colon in the end.

select * from WLM_METRICS_STREAM

Regards,

Himanshu

[rodbastidas]

he works, thanks so much!