Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
Hi Nuwan,
We want that fix to our new release. we are going to switch to jaggery
version 5. did you host that in maven repository?
thank you
On Tue, May 14, 2013 at 11:47 AM, Nuwan Bandara nu...@wso2.com wrote:
yap, fixed it
Regards,
/Nuwan
On Tue, May 14, 2013 at 11:46 AM, Sumedha Rubasinghe sume...@wso2.comwrote:
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 nu...@wso2.com 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
ayashkan...@wso2.com wrote:
Hi,
On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara nu...@wso2.com 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
nameWSO2BAM_DATASOURCE/name
descriptionThe datasource used for analyzer
data/description
definition type=RDBMS
configuration
urljdbc:oracle:thin:@10.100.3.227:1521/daniddb
/url
usernameayash_db/username
passwordayash_db/password
driverClassNameoracle.jdbc.driver.OracleDriver/driverClassName
maxActive50/maxActive
maxWait6/maxWait
testOnBorrowtrue/testOnBorrow
validationQuerySELECT 1/validationQuery
validationInterval3/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
ayashkan...@wso2.com 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
Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
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 nu...@wso2.com 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
ayashkan...@wso2.com wrote:
Hi,
On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara nu...@wso2.com 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
nameWSO2BAM_DATASOURCE/name
descriptionThe datasource used for analyzer
data/description
definition type=RDBMS
configuration
urljdbc:oracle:thin:@10.100.3.227:1521/daniddb/url
usernameayash_db/username
passwordayash_db/password
driverClassNameoracle.jdbc.driver.OracleDriver/driverClassName
maxActive50/maxActive
maxWait6/maxWait
testOnBorrowtrue/testOnBorrow
validationQuerySELECT 1/validationQuery
validationInterval3/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
ayashkan...@wso2.com 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
Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
yap, fixed it
Regards,
/Nuwan
On Tue, May 14, 2013 at 11:46 AM, Sumedha Rubasinghe sume...@wso2.comwrote:
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 nu...@wso2.com 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
ayashkan...@wso2.com wrote:
Hi,
On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara nu...@wso2.com 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
nameWSO2BAM_DATASOURCE/name
descriptionThe datasource used for analyzer
data/description
definition type=RDBMS
configuration
urljdbc:oracle:thin:@10.100.3.227:1521/daniddb
/url
usernameayash_db/username
passwordayash_db/password
driverClassNameoracle.jdbc.driver.OracleDriver/driverClassName
maxActive50/maxActive
maxWait6/maxWait
testOnBorrowtrue/testOnBorrow
validationQuerySELECT 1/validationQuery
validationInterval3/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
ayashkan...@wso2.com 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
[Dev] Jaggery is not querying data properly from oracle-DBs.
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
Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
Hi,
What is WSO2BAM_DATASOURCE, thats wrong syntax for DB API
Regards,
/Nuwan
On Mon, May 13, 2013 at 7:16 PM, Ayashkantha Ramasinghe
ayashkan...@wso2.com 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
Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
Hi,
On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara nu...@wso2.com 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
nameWSO2BAM_DATASOURCE/name
descriptionThe datasource used for analyzer data/description
definition type=RDBMS
configuration
urljdbc:oracle:thin:@10.100.3.227:1521/daniddb/url
usernameayash_db/username
passwordayash_db/password
driverClassNameoracle.jdbc.driver.OracleDriver/driverClassName
maxActive50/maxActive
maxWait6/maxWait
testOnBorrowtrue/testOnBorrow
validationQuerySELECT 1/validationQuery
validationInterval3/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
ayashkan...@wso2.com 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
Re: [Dev] Jaggery is not querying data properly from oracle-DBs.
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
ayashkan...@wso2.com wrote:
Hi,
On Mon, May 13, 2013 at 9:10 PM, Nuwan Bandara nu...@wso2.com 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
nameWSO2BAM_DATASOURCE/name
descriptionThe datasource used for analyzer data/description
definition type=RDBMS
configuration
urljdbc:oracle:thin:@10.100.3.227:1521/daniddb/url
usernameayash_db/username
passwordayash_db/password
driverClassNameoracle.jdbc.driver.OracleDriver/driverClassName
maxActive50/maxActive
maxWait6/maxWait
testOnBorrowtrue/testOnBorrow
validationQuerySELECT 1/validationQuery
validationInterval3/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
ayashkan...@wso2.com 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
