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