Skip to main content
rodbastidas1-Visitor
1-Visitor
Apr 5, 2018 7:32 PM UTC
Solved

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

hchananaAnswer
16-Pearl
Apr 6, 2018 8:55 PM UTC

@rodbastidas

 

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

 

select * from WLM_METRICS_STREAM
 
 
 
 
 
 
 
 

 

Regards,

Himanshu

View in thread

4 replies

mnarang5-Regular Member
5-Regular Member
Apr 6, 2018 6:36 AM UTC

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

Translate
    rodbastidas1-VisitorAuthor
    1-Visitor
    Apr 6, 2018 8:18 PM UTC

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

    Translate
    hchanana16-PearlAnswer
    16-Pearl
    Apr 6, 2018 8:55 PM UTC

    @rodbastidas

     

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

     

    select * from WLM_METRICS_STREAM
     
     
     
     
     
     
     
     

     

    Regards,

    Himanshu

    Translate
    Terms & ConditionsAccessibility statement