Hi Aneela, First of all if you haven't change 'WSO2_CARBON_DB' data-source configurations, by default it will use H2 db. Therefore, the 'ftp_log_table' table will get created in H2. You can enable and use built-in H2 browser to view the data [1]. Moreover, data added to the RDBMS tables will be stored permanently. However, you can have a delete query from Siddhi to purge data.
[1] http://www.vitharana.org/2012/04/how-to-browse-h2-database-of-wso2.html Regards, On Thu, Aug 18, 2016 at 9:24 PM, Aneela Safdar <[email protected]> wrote: > I have created an rdbms table in an execution plan and write below query > > @from(eventtable = 'rdbms' , datasource.name = 'WSO2_CARBON_DB' , > table.name ='ftp_log_table') > define table ftp_log_table (ts string, uid string, id_orig_h string, > id_orig_p int, id_resp_h string, id_resp_p int, user string, password > string,command string, arg string, mime_type string, file_size string, > reply_code int, reply_msg string); > > from FTPInStream > select * > insert into ftp_log_table; > > There is no error of invalidity but I haven't created this table before in > the database. Also how can I view data in it? Is it going to store data > permanently or a long period of time for further correspondence? > > Regards, > Aneela Safdar > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- Grainier Perera Software Engineer Mobile : +94716122384 WSO2 Inc. | http://wso2.com lean.enterprise.middleware
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
