Hi Charini, I tried the release version of WSO2 SP 4.0 and works great with Oracle DB now with the add of AGG_ before the column name.
One thing that maybe you must add/change in the docs, is the that Oracle table name size that I pointed out before. Your example Tutorial 6: Streaming Data Summarization (Incremental Aggregation) <https://docs.wso2.com/pages/viewpage.action?pageId=80721826> has the name *SweetProductionAggregation *and this not work with Oracle because, for example, the name SweetProductionAggregation_SECONDS has 34 of length, and the limit is 30. Thank you for correct the problem of aggregation with Oracle DB, because we are doing some POCs and our clients has mainly Oracle. Juan Pablo Vadell | *VATROX* On Tue, Jan 9, 2018 at 1:52 AM, Charini Nanayakkara <[email protected]> wrote: > 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
