Hi Juan, Thanks again for reporting this issue. We will look into it.
Best Regards Charini On Tue, Jan 9, 2018 at 10:18 AM, Juan Pablo Vadell <[email protected]> wrote: > 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> >> > > -- *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
