Skip to main content
R
rodbastidas1-Visitor
1-Visitor
April 5, 2018
Solved

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

  • April 5, 2018
  • 1 reply
  • 6218 views

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

Best answer by hchanana

@rodbastidas

 

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

 

select * from WLM_METRICS_STREAM
 
 
 
 
 
 
 
 

 

Regards,

Himanshu

1 reply

M
mnarang5-Regular Member
5-Regular Member
April 6, 2018

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

    R
    rodbastidas1-VisitorAuthor
    1-Visitor
    April 6, 2018

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

    H
    hchanana16-PearlAnswer
    16-Pearl
    April 6, 2018

    @rodbastidas

     

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

     

    select * from WLM_METRICS_STREAM
     
     
     
     
     
     
     
     

     

    Regards,

    Himanshu

    Terms & ConditionsAccessibility statement