Re: [Dev] rdbms table data view

[Grainier Perera]

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  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
> Dev@wso2.org
> 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
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

[Dev] rdbms table data view

[Aneela Safdar]

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
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev