[Dev] Error gets when executing sql query in UES data-api.jag
Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
Hi Sajini, Try, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` limit 10}'); On Wed, Jun 18, 2014 at 9:25 PM, Sajini De Silva saj...@wso2.com wrote: Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
HI Kalpa, Yp it works fine with that query, but again there is an error with this query, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost' limit 10}'); In the backend i get the following error. js: /monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag, line 6: missing ) after argument list js:var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost}'); js: ^ [2014-06-18 22:11:16,998] ERROR {org.jaggeryjs.jaggery.core.manager.WebAppManager} - org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) org.jaggeryjs.scriptengine.exceptions.ScriptException: org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) On Wed, Jun 18, 2014 at 10:07 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Sajini, Try, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` limit 10}'); On Wed, Jun 18, 2014 at 9:25 PM, Sajini De Silva saj...@wso2.com wrote: Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
Hi Sajini, Did you also change the mappings as well? Because the generated jag file has the mappings as for your initial query. So processing of the data in to the format that flot accepts happens according to that mapping. Thanks, Tanya On Wed, Jun 18, 2014 at 9:48 AM, Sajini De Silva saj...@wso2.com wrote: HI Kalpa, Yp it works fine with that query, but again there is an error with this query, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost' limit 10}'); In the backend i get the following error. js: /monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag, line 6: missing ) after argument list js:var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost}'); js: ^ [2014-06-18 22:11:16,998] ERROR {org.jaggeryjs.jaggery.core.manager.WebAppManager} - org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) org.jaggeryjs.scriptengine.exceptions.ScriptException: org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) On Wed, Jun 18, 2014 at 10:07 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Sajini, Try, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` limit 10}'); On Wed, Jun 18, 2014 at 9:25 PM, Sajini De Silva saj...@wso2.com wrote: Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tanya Madurapperuma Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
Hi, It worked after changing the statement like below. var queryData = JSON.parse({\SQL Statement\ : \SELECT * FROM multiGraphTable2 where hostName = '41304041432.dmz.mgt.platformelb1.wso2.com' limit 10\}); Thank you. Sajini. On Wed, Jun 18, 2014 at 11:48 PM, Tanya Madurapperuma ta...@wso2.com wrote: Hi Sajini, Did you also change the mappings as well? Because the generated jag file has the mappings as for your initial query. So processing of the data in to the format that flot accepts happens according to that mapping. Thanks, Tanya On Wed, Jun 18, 2014 at 9:48 AM, Sajini De Silva saj...@wso2.com wrote: HI Kalpa, Yp it works fine with that query, but again there is an error with this query, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost' limit 10}'); In the backend i get the following error. js: /monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag, line 6: missing ) after argument list js:var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost}'); js: ^ [2014-06-18 22:11:16,998] ERROR {org.jaggeryjs.jaggery.core.manager.WebAppManager} - org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) org.jaggeryjs.scriptengine.exceptions.ScriptException: org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) On Wed, Jun 18, 2014 at 10:07 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Sajini, Try, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` limit 10}'); On Wed, Jun 18, 2014 at 9:25 PM, Sajini De Silva saj...@wso2.com wrote: Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tanya Madurapperuma Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev
Re: [Dev] Error gets when executing sql query in UES data-api.jag
Hi Sajini, Yes it should be a valid JSON string to get JSON.parse method to work, you can get more info about JSON.parse from [1][2] [1] - http://www.w3schools.com/json/json_eval.asp [2] - http://msdn.microsoft.com/en-us/library/ie/cc836466(v=vs.94).aspx On Thu, Jun 19, 2014 at 9:04 AM, Sajini De Silva saj...@wso2.com wrote: Hi, It worked after changing the statement like below. var queryData = JSON.parse({\SQL Statement\ : \SELECT * FROM multiGraphTable2 where hostName = ' 41304041432.dmz.mgt.platformelb1.wso2.com' limit 10\}); Thank you. Sajini. On Wed, Jun 18, 2014 at 11:48 PM, Tanya Madurapperuma ta...@wso2.com wrote: Hi Sajini, Did you also change the mappings as well? Because the generated jag file has the mappings as for your initial query. So processing of the data in to the format that flot accepts happens according to that mapping. Thanks, Tanya On Wed, Jun 18, 2014 at 9:48 AM, Sajini De Silva saj...@wso2.com wrote: HI Kalpa, Yp it works fine with that query, but again there is an error with this query, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost' limit 10}'); In the backend i get the following error. js: /monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag, line 6: missing ) after argument list js:var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` where `hostName` = 'nameOftheHost}'); js: ^ [2014-06-18 22:11:16,998] ERROR {org.jaggeryjs.jaggery.core.manager.WebAppManager} - org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) org.jaggeryjs.scriptengine.exceptions.ScriptException: org.jaggeryjs.scriptengine.exceptions.ScriptException: org.mozilla.javascript.EvaluatorException: Compilation produced 1 syntax errors. (/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag#1) On Wed, Jun 18, 2014 at 10:07 PM, Kalpa Welivitigoda kal...@wso2.com wrote: Hi Sajini, Try, var queryData = JSON.parse('{SQL Statement : SELECT * FROM `multiGraphTable2` limit 10}'); On Wed, Jun 18, 2014 at 9:25 PM, Sajini De Silva saj...@wso2.com wrote: Hi Udara, I copied mysql connector lib and this is the error I got. NetworkError: 500 Internal Server Error - https://localhost:9443/monitoring-tool/gadgets/_9c7f9a50-f167-46bc-9e60-2fedd19e6b6f/data-api.jag Thank you. On Wed, Jun 18, 2014 at 9:21 PM, Udara Rathnayake uda...@wso2.com wrote: Hi, Can you copy that error here? Hope you have relevant connector lib in Jaggery runtime. On Wed, Jun 18, 2014 at 8:57 PM, Sajini De Silva saj...@wso2.com wrote: Hi, I created a new gadget using a data source which worked fine. After creating the gadget I edited the sql query in data-api.jag like below. var queryData = JSON.parse('{SELECT * FROM `multiGraphTable2` limit 10}'); I run this query in mysql database and it gave me the correct results, but when I edited the data-api.jag with this query the gadget doesn't load and it gives an error in firebug. Any idea why this is happening? Thank you, Sajini. -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- *Udara Rathnayake* Software Engineer WSO2 Inc. : http://wso2.com Mobile : +94 772207239 Twitter : http://twitter.com/udarakr Blog: http://udarakr.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Best Regards, Kalpa Welivitigoda Software Engineer, WSO2 Inc. http://wso2.com Email: kal...@wso2.com Mobile: +94776509215 -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva ___ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev -- Tanya Madurapperuma Software Engineer, WSO2 Inc. : wso2.com Mobile : +94718184439 Blog : http://tanyamadurapperuma.blogspot.com -- Sajini De SIlva Software Engineer; WSO2 Inc.; http://wso2.com , Email: saj...@wso2.com Blog: http://sajinid.blogspot.com/ Git hub profile: https://github.com/sajinidesilva