Re: [Dev] [CEP] How to write a Siddhi query to get the total count from an Event Table

2014-11-14 Thread Supun Muthutantrige
It doesn't give any errors, but the output look like, ​ The query we have used as follows, from forCalculation join MarkovModel on forCalculation.initialState == MarkovModel.Initial_state select initialState as Event, sum(MarkovModel.countP) as totalCount group by forCalculation.initialState

Re: [Dev] [CEP] How to write a Siddhi query to get the total count from an Event Table

2014-11-14 Thread Supun Muthutantrige
Before executing the code, the Event table looks like, ​After executing the code, ​The results according to the above mentioned query ​ Thank you Regards *Supun Rasitha Muthutantrige* Software Engineer | Intern WSO2 Inc: http://wso2.com lean.enterprise.middleware Mobile: 0758374608

Re: [Dev] [CEP] How to write a Siddhi query to get the total count from an Event Table

2014-11-14 Thread Supun Muthutantrige
I have attached the execution plan and the input stream. The regex used to read from file adaptor, *state:(\S+)\.* Thank you Regards *Supun Rasitha Muthutantrige* Software Engineer | Intern WSO2 Inc: http://wso2.com lean.enterprise.middleware Mobile: 0758374608 ?xml version=1.0 encoding=UTF-8?

[Dev] [CEP] How to write a Siddhi query to get the total count from an Event Table

2014-11-13 Thread Supun Muthutantrige
Hii all, There is a mysql table with the following content. The format of the in stream state:HTS state:HFS state:HTM state:HTS state:HTL state:HFS state:MTS state:HTS state:HTL state:MFM state:HTS state:HFS​

Re: [Dev] [CEP] How to write a Siddhi query to get the total count from an Event Table

2014-11-13 Thread Supun Muthutantrige
Hi seshika, Yes tried that but it doesn't give the desired output. The query that we have used as follows, from forCalculation#window.length(1) join MarkovModel on forCalculation.initialState == MarkovModel.Initial_state select initialState as Event, sum(MarkovModel.countP) as totalCount insert

Re: [Dev] [Siddhi] Counting Patterns

2014-11-02 Thread Supun Muthutantrige
Hi Suho, Yes, the 3rd example worked for the above given scenario. And when more than 3 addresses are allowed, what Seshika has mentioned can also be used. Thank you, Regards *Supun Rasitha Muthutantrige* Software Engineer | Intern WSO2 Inc: http://wso2.com lean.enterprise.middleware Mobile:

Re: [Dev] [Siddhi] Counting Patterns

2014-10-31 Thread Supun Muthutantrige
Hi seshika Have you found any scalable approaches on this? We also came across some similar scenarios. Thank you Regards *Supun Rasitha Muthutantrige* Software Engineer | Intern WSO2 Inc: http://wso2.com lean.enterprise.middleware Mobile: 0758374608

Re: [Dev] [Siddhi] Counting Patterns

2014-10-31 Thread Supun Muthutantrige
One such scenario is, shipping to multiple addresses using a single credit card. The merchant should be able to set a max no of addresses. So when the no increases, query become complicated. Let's assume all the following transactions have the same credit card no, but with different addresses and

Re: [Dev] [Siddhi] Counting Patterns

2014-10-31 Thread Supun Muthutantrige
Hi Suho, The scenario is, we should be able to trigger an alert when multiple shipping's are being caused by applying a single credit card. In our case this should occur when third distinct address pop's up in an event. So in my previous example, if we consider the 4th transaction which is,

[Dev] [CEP] Appropriate Regex values to map CSV file fields into an event stream

2014-10-29 Thread Supun Muthutantrige
Hii, I am using a csv file which consists of several fields similar to pin12345678 ip192.168.10.2 mailt...@abc.com addcolombo pin34345678 ip192.168.10.3 mailt...@abc.com addcolombo1 pin12345678 ip192.168.10.2 mailt...@abc.com addcolombo2 and so on *Note: Ignore

Re: [Dev] Error establishing data source connection, Communications link failure

2014-10-15 Thread Supun Muthutantrige
Hi Manoj, The error occurred when I attempt to link to a mysql database using the CEP. The following error message was shown when the connection was tested. Error-- Error establishing data source connection: Communications link failure The last packet sent successfully

[Dev] Error establishing data source connection, Communications link failure

2014-10-14 Thread Supun Muthutantrige
Hi all, While attempting to relate to an RDBMS data source [Driver*:* *com.mysql.jdbc.Driver*, URL: *jdbc:mysql://localhost:3306/testdb*] in CEP, the following error occurs Error--- Error establishing data source connection: Communications link failure The last packet

Re: [Dev] Error establishing data source connection, Communications link failure

2014-10-14 Thread Supun Muthutantrige
Hi Rajeevan, Yes, I tried by adding *mysql-connector-Java-5.1.33. tar.gz*, and then with only having *mysql-connector-Java-5.1.33-bin.jar* in that folder. But neither worked. Regards *Supun Rasitha Muthutantrige* *supunr* *Intern WSO2 Inc: http://wso2.com

Re: [Dev] Error establishing data source connection, Communications link failure

2014-10-14 Thread Supun Muthutantrige
Hi Yasassri, It worked :) Thank you all for helping me out with this. Regards *Supun Rasitha Muthutantrige* *supunr* *Intern * *WSO2 Inc: http://wso2.com http://wso2.com* *lean.enterprise.middleware* *Mobile: 0758374608* ___ Dev mailing list

Re: [Dev] ClassNotFoundException : org.wso2.carbon.student.mgt.GetStudents when creating carbon component.

2014-10-09 Thread Supun Muthutantrige
Hi Hemika, Can you attach the StudentManagerClient.java file. It seems the problem is caused from there. Regards *Supun Rasitha Muthutantrige* *supunrWSO2 Inc: http://wso2.com http://wso2.com lean.enterprise.middleware* *Mobile: 0758374608* ___

Re: [Dev] How to add a link to a different page in a carbon ui component

2014-10-08 Thread Supun Muthutantrige
Hi Lahiru, DO you want to link two .jsp pages? From one of your .jsp pages to another one? is that what you are trying to achieve? Regards *Supun Rasitha Muthutantrige* *supunr WSO2 Inc: http://wso2.com http://wso2.com lean.enterprise.middleware* *Mobile: 0758374608*

Re: [Dev] How to add a link to a different page in a carbon ui component

2014-10-08 Thread Supun Muthutantrige
you can simple add an anchor tag in you jsp file. or you can add a button to redirect it into the relevant page Anchor tag a href=*your_jsp**link text*/a *Supun Rasitha Muthutantrige* *supunrIntern WSO2 Inc: http://wso2.com http://wso2.com lean.enterprise.middleware* *Mobile: 0758374608*

Re: [Dev] How to add a link to a different page in a carbon ui component

2014-10-08 Thread Supun Muthutantrige
Is your problem solved then? Regards *Supun Rasitha Muthutantrige* *supunrIntern WSO2 Inc: http://wso2.com http://wso2.com lean.enterprise.middleware* *Mobile: 0758374608* ___ Dev mailing list Dev@wso2.org

Re: [Dev] [DEV] WSDL error when writing the carbon component

2014-10-02 Thread Supun Muthutantrige
Hii Nishali, Just check your wsdl again. It seems there is a problem in saving it. Try to save it from the browser as a wsdl file instead of copying and then saving in a different file. Regards *Supun Rasitha Muthutantrige* *supunrWSO2 Inc: http://wso2.com http://wso2.com

[Dev] Could not resolve dependencies Error in writing Student-Manager Carbon component

2014-10-01 Thread Supun Muthutantrige
Hii, I went through the following article to write a Carbon Component [01]. http://wso2.com/library/tutorials/2014/03/how-to-write-a-wso2-carbon-component/ I have completed most of the steps in [01], but when trying to *mvn clean install* the *pom.xml* under *org.wso2.carbon.student.mgt.ui*,

Re: [Dev] Could not resolve dependencies Error in writing Student-Manager Carbon component

2014-10-01 Thread Supun Muthutantrige
@Rajith Thank you, but the problem still exists. Error it gives this time - *Begin Error Stack* -- [INFO] Scanning for projects... [WARNING] [WARNING] Some problems were encountered while building the effective model for

Re: [Dev] Could not resolve dependencies Error in writing Student-Manager Carbon component

2014-10-01 Thread Supun Muthutantrige
Thank you all. Finally it worked :) Regards *Supun Rasitha Muthutantrige* *supunrWSO2 Inc: http://wso2.com http://wso2.com lean.enterprise.middleware* *Mobile: 0758374608* ___ Dev mailing list Dev@wso2.org