Hi,
I am trying to test the Siddhi Aggregation feature and found that don't
work with Oracle DB.
The error I think is because you are trying to use _TIMESTAMP as column
name, and with Oracle you need to use double quotes at the column name like
"_TIMESTAMP", if not you will receive a
*ORA-00911: invalid character*
This is the complete error
*[2018-01-07_01-13-51_009] ERROR {org.wso2.siddhi.core.table.Table} - Error
on 'AggProductionHistoryApp'. Failed to initialize store for table name
'SweetProdAgg_MONTHS': Unable to initialize table 'SweetProdAgg_MONTHS':
ORA-00911: invalid character_ Error while connecting to Table
'SweetProdAgg_MONTHS', will retry in '5 sec'.
(Encoded)org.wso2.siddhi.core.exception.ConnectionUnavailableException:
Failed to initialize store for table name 'SweetProdAgg_MONTHS': Unable to
initialize table 'SweetProdAgg_MONTHS': ORA-00911: invalid character*
And other thing is that Oracle don't support long table names... so we must
take care of that.
Thank you,
Juan Pablo Vadell | *VATROX*
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
