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
