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
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
