yap, fixed it Regards, /Nuwan
On Tue, May 14, 2013 at 11:46 AM, Sumedha Rubasinghe <[email protected]>wrote: > Nuwan, > I think the problem is > org.jaggeryjs.hostobjects.db.DatabaseHostObject.getValue(DatabaseHostObject.java:607). > You should not try to read if the value is null. But rather set one back > to response being returned. > > > On Tue, May 14, 2013 at 10:47 AM, Nuwan Bandara <[email protected]> wrote: > >> Hi, >> >> We might have to debug the DB Api and look into it. what is you query ? >> >> Regards, >> /Nuwan >> >> >> On Tue, May 14, 2013 at 10:22 AM, Ayashkantha Ramasinghe < >> [email protected]> wrote: >> >>> Hi, >>> >>> On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara <[email protected]> wrote: >>> >>>> Hi, >>>> >>>> What is "WSO2BAM_DATASOURCE", thats wrong syntax for DB API >>>> >>> >>> >>> "WSO2BAM_DATASOURCE" is configured in >>> $BAM_HOME/repository/conf/datasources/master-datasources.xml. this is the >>> configuration of that. >>> >>> <datasource> >>> <name>WSO2BAM_DATASOURCE</name> >>> <description>The datasource used for analyzer >>> data</description> >>> <definition type="RDBMS"> >>> <configuration> >>> <url>jdbc:oracle:thin:@10.100.3.227:1521/daniddb >>> </url> >>> <username>ayash_db</username> >>> <password>ayash_db</password> >>> >>> <driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName> >>> <maxActive>50</maxActive> >>> <maxWait>60000</maxWait> >>> <testOnBorrow>true</testOnBorrow> >>> <validationQuery>SELECT 1</validationQuery> >>> <validationInterval>30000</validationInterval> >>> </configuration> >>> </definition> >>> </datasource> >>> >>> I think the problem is processing the data retrieved, because, i think, >>> it connects to the database properly. >>> >>> >>> >>> On Mon, May 13, 2013 at 7:16 PM, Ayashkantha Ramasinghe < >>> [email protected]> wrote: >>> >>>> Hi, >>>> >>>> query() function is being failed to return the result while oracle DB >>>> consisted of null values in it. >>>> >>>> I am getting this error, >>>> >>>> >>>> [2013-05-13 18:04:38,014] ERROR >>>> {org.jaggeryjs.jaggery.core.manager.WebAppManager} - >>>> org.mozilla.javascript.WrappedException: Wrapped >>>> java.lang.NullPointerException >>>> (/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag#53) >>>> org.jaggeryjs.scriptengine.exceptions.ScriptException: >>>> org.mozilla.javascript.WrappedException: Wrapped >>>> java.lang.NullPointerException >>>> (/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag#53) >>>> at >>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:446) >>>> at >>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.exec(RhinoEngine.java:191) >>>> at >>>> org.jaggeryjs.jaggery.core.manager.WebAppManager.execute(WebAppManager.java:269) >>>> at >>>> org.jaggeryjs.jaggery.core.JaggeryServlet.doPost(JaggeryServlet.java:29) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:755) >>>> at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) >>>> at >>>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) >>>> at >>>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) >>>> at >>>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) >>>> at >>>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) >>>> at >>>> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) >>>> at >>>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) >>>> at >>>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) >>>> at >>>> org.wso2.carbon.tomcat.ext.valves.CompositeValve.invoke(CompositeValve.java:177) >>>> at >>>> org.wso2.carbon.tomcat.ext.valves.CarbonStuckThreadDetectionValve.invoke(CarbonStuckThreadDetectionValve.java:161) >>>> at >>>> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936) >>>> at >>>> org.wso2.carbon.tomcat.ext.valves.CarbonContextCreatorValve.invoke(CarbonContextCreatorValve.java:57) >>>> at >>>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) >>>> at >>>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) >>>> at >>>> org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) >>>> at >>>> org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) >>>> at >>>> org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1653) >>>> at >>>> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) >>>> at >>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) >>>> at java.lang.Thread.run(Thread.java:662) >>>> Caused by: org.mozilla.javascript.WrappedException: Wrapped >>>> java.lang.NullPointerException >>>> (/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag#53) >>>> at >>>> org.mozilla.javascript.Context.throwAsScriptRuntimeEx(Context.java:1654) >>>> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:175) >>>> at >>>> org.mozilla.javascript.FunctionObject.call(FunctionObject.java:411) >>>> at >>>> org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1._c2(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag:53) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1.call(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag) >>>> at >>>> org.mozilla.javascript.optimizer.OptRuntime.callName(OptRuntime.java:97) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1._c0(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag:65) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1.call(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag) >>>> at >>>> org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:401) >>>> at >>>> org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3003) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1.call(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag) >>>> at >>>> org.jaggeryjs.rhino.bamdashboards.activity_monitoring.gadgets.c1.exec(/bamdashboards/activity_monitoring/gadgets/dataSource.ajaxProcessor.jag) >>>> at >>>> org.jaggeryjs.scriptengine.engine.RhinoEngine.execScript(RhinoEngine.java:441) >>>> ... 24 more >>>> Caused by: java.lang.NullPointerException >>>> at >>>> org.jaggeryjs.hostobjects.db.DatabaseHostObject.getValue(DatabaseHostObject.java:607) >>>> at >>>> org.jaggeryjs.hostobjects.db.DatabaseHostObject.processResults(DatabaseHostObject.java:581) >>>> at >>>> org.jaggeryjs.hostobjects.db.DatabaseHostObject.executeQuery(DatabaseHostObject.java:505) >>>> at >>>> org.jaggeryjs.hostobjects.db.DatabaseHostObject.jsFunction_query(DatabaseHostObject.java:195) >>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>>> at >>>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>>> at >>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>>> at java.lang.reflect.Method.invoke(Method.java:597) >>>> at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:160) >>>> ... 36 more >>>> >>>> >>>> >>>> >>>> while executing following code snippet >>>> >>>> >>>> >>>> >>>> var db; >>>> if(dbType == "RDBMS"){ >>>> db = new Database("WSO2BAM_DATASOURCE"); >>>> } else if(dbType == "cassandra"){ >>>> var config = { >>>> >>>> "driverClassName":"org.apache.cassandra.cql.jdbc.CassandraDriver" >>>> } >>>> db = new >>>> Database("jdbc:cassandra://localhost:9160/EVENT_KS", "admin", "admin", >>>> config); >>>> } >>>> * result = db.query(q);*//this is the line 53 and q is query >>>> log.info(result); >>>> >>>> >>>> >>>> >>>> -- >>>> Ayashkantha Ramasinghe >>>> Software Engineer >>>> >>>> Tel: +94 777 487 669 >>>> >>> >>> >>> >>> -- >>>> *Thanks & Regards, >>>> >>>> Nuwan Bandara >>>> Associate Technical Lead & Member, MC, Development Technologies >>>> WSO2 Inc. - lean . enterprise . middleware | http://wso2.com >>>> blog : http://nuwanbando.com; email: [email protected]; phone: +94 11 763 >>>> 9629 >>>> * >>>> <http://www.nuwanbando.com/> >>>> >>> >>> >>> >>> -- >>> Ayashkantha Ramasinghe >>> Software Engineer >>> >>> Tel: +94 777 487 669 >>> >> >> >> >> -- >> *Thanks & Regards, >> >> Nuwan Bandara >> Associate Technical Lead & Member, MC, Development Technologies >> WSO2 Inc. - lean . enterprise . middleware | http://wso2.com >> blog : http://nuwanbando.com; email: [email protected]; phone: +94 11 763 >> 9629 >> * >> <http://www.nuwanbando.com/> >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> > > > -- > /sumedha > m: +94 773017743 > b : bit.ly/sumedha > -- *Thanks & Regards, Nuwan Bandara Associate Technical Lead & Member, MC, Development Technologies WSO2 Inc. - lean . enterprise . middleware | http://wso2.com blog : http://nuwanbando.com; email: [email protected]; phone: +94 11 763 9629 * <http://www.nuwanbando.com/>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
