Hi Juan, Just to keep you informed that any issues we get to know about in future, would be fixed through our update process (https://wso2.com/updates/wum)
Thank you Charini On Sat, Jan 13, 2018 at 8:26 AM, Charini Nanayakkara <[email protected]> wrote: > Hi Juan, > > Thank you very much for pointing this out. > > I have mentioned the concern regarding table name length in the > documentation [1] > > [1] https://docs.wso2.com/display/SP400/Incremental+Analysis > > Best Regards > Charini > > On Fri, Jan 12, 2018 at 9:35 PM, Juan Pablo Vadell <[email protected]> > wrote: > >> 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> >>> >> >> > > > -- > *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
