cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

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

rodbastidas
7-Bedrock

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

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

ACCEPTED SOLUTION

Accepted Solutions

@rodbastidas

 

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

 

select * from WLM_METRICS_STREAM
 
 
 
 
 
 
 
 

 

Regards,

Himanshu

View solution in original post

4 REPLIES 4

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

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

@rodbastidas

 

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

 

select * from WLM_METRICS_STREAM
 
 
 
 
 
 
 
 

 

Regards,

Himanshu

he works, thanks so much!

Announcements


Top Tags