CODEWITHSUNDEEP
oracle-databasewso2datasourcewso2-cep
sriramjothimani
sriramjothimani

Reputation: 1

SQL Syntax error while trying WSO2 CEP getting started sample

Am new to W2 CEP and trying to run the samples given in the Wso2 CEP documentation. I was actually following the getting started guide and almost through with all the steps without any issues. But stuck with the last but one step while creating a personalized dash board.

Am using Oracle database as my datasource and I was able to refer the datasource created in CEP while creating the dashboard and the connection is validated successfully. But when I enter my sql "select * from delivered_orders" and upon running it gives me an error of "You have an error in your SQL syntax". In the console I can see a corresponding ORA error "java.sql.SQLException: ORA-00933: SQL command not properly ended"

The sql statement as you have seen is a very basic statement to have any syntax errors. Am not sure whats wrong with my setup, any help regarding this would be great.

I have read couple of other titles from stack overflow on this which suggest I should not use composite primary keys which was bug with WSO2 CEP. I tried that but still no good.

Additional Details : 0ct 3'rd

I tried the same sample with MySql and it works like a charm. And thanks for Colinr for the ticket, I see the documentation updated. But still I have issues while connecting with Oracle.

Upvotes: 0

Views: 243

Answers (1)

Colinr
Colinr

Reputation: 201

Your command may be missing a terminator ';'
If that solves your issue, I'll try to get the document updated.

Upvotes: 0

Related Questions