Hi Charini, You must take care of Oracle table names Max Length, that is 30 until 12.1 and 128 bytes from 12.2.
I created an issue at github before you, but in the wrong place. https://github.com/wso2/siddhi/issues/717 Thank you, Juan Pablo Vadell | *VATROX* On Tue, Jan 9, 2018 at 12:35 AM, Charini Nanayakkara <[email protected]> wrote: > Hi Juan, > > Thank you for reporting this issue. > > SP aggregation has only been tested with MySql so far. We have updated > that information in SP documentation [1] > > As explained by you, the reported issue arises in Oracle, due to not > specifying attributes starting with underscore (such as _TIMESTAMP) within > quotation marks. We have created an issue in github for this [2]. We will > work on fixing it. > > [1] https://docs.wso2.com/display/SP400/Incremental+Analysis > [2] https://github.com/wso2-extensions/siddhi-store-rdbms/issues/72 > > Thank you > Charini > > On Sun, Jan 7, 2018 at 10:01 AM, Juan Pablo Vadell <[email protected]> > wrote: > >> 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 >> >> > > > -- > *Charini Vimansha Nanayakkara* > Software Engineer at WSO2 > > Mobile: 0714126293 > E-mail: [email protected] > Blog: http://www.charini.me/ > > <http://wso2.com/signature> >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
