DS problem with BAM DS

View: New views
8 Messages — Rating Filter:   Alert me  

DS problem with BAM DS

by Samisa Abeysinghe-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I am pulling my hair to figure out why the DS that worked on trunk is not working on 2.0.2

Ii have verified that the DS MR gets the message (the hard way):

[2009-11-07 18:54:35,672] DEBUG -  DS MR invokeBusinessLogic SOAP Envelope <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org
/2003/05/soap-envelope"><soapenv:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"><wsa:To>https://10.202.120.28:9444/greg/services/BAMDataCollectionDS</wsa:
To><wsa:ReplyTo><wsa:Address>http://www.w3.org/2005/08/addressing/none</wsa:Address></wsa:ReplyTo><wsa:MessageID>urn:uuid:CA20DBD64A31ED47101257600278250</wsa:Mess
ageID><wsa:Action>urn:addOperationData</wsa:Action></soapenv:Header><soapenv:Body><ns1:addOperationData xmlns:ns1="http://ws.wso2.org/dataservice"><ns1:operationID
>6</ns1:operationID><ns1:timestamp>2009-11-07 18:54:34</ns1:timestamp><ns1:avgResTime>4.541666666666667</ns1:avgResTime><ns1:maxResTime>62.0</ns1:maxResTime><ns1:m
inResTime>0.0</ns1:minResTime><ns1:cumReqCount>24</ns1:cumReqCount><ns1:cumResCount>23</ns1:cumResCount><ns1:cumFaultCount>1</ns1:cumFaultCount></ns1:addOperationD
ata></soapenv:Body></soapenv:Envelope>

But when I look at them at createProcessedPreparedStatement in SQLQuery class, the paramValue appears to be null, and it picks the param name correctly though. 

Can someone please have a look. 

Thanks,
Samisa...



--
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Samisa Abeysinghe-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The problem DS is here; https://wso2.org/repos/wso2/people/dumindu/scratch/bam/bam-2009-11-07-v001/bam/modules/distribution/bam/dataservice/BAMDataCollectionDS.dbs

Thanks,
Samisa...

On Sat, Nov 7, 2009 at 7:00 PM, Samisa Abeysinghe <samisa@...> wrote:
I am pulling my hair to figure out why the DS that worked on trunk is not working on 2.0.2

Ii have verified that the DS MR gets the message (the hard way):

[2009-11-07 18:54:35,672] DEBUG -  DS MR invokeBusinessLogic SOAP Envelope <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org
/2003/05/soap-envelope"><soapenv:Header xmlns:wsa="http://www.w3.org/2005/08/addressing"><wsa:To>https://10.202.120.28:9444/greg/services/BAMDataCollectionDS</wsa:
To><wsa:ReplyTo><wsa:Address>http://www.w3.org/2005/08/addressing/none</wsa:Address></wsa:ReplyTo><wsa:MessageID>urn:uuid:CA20DBD64A31ED47101257600278250</wsa:Mess
ageID><wsa:Action>urn:addOperationData</wsa:Action></soapenv:Header><soapenv:Body><ns1:addOperationData xmlns:ns1="http://ws.wso2.org/dataservice"><ns1:operationID
>6</ns1:operationID><ns1:timestamp>2009-11-07 18:54:34</ns1:timestamp><ns1:avgResTime>4.541666666666667</ns1:avgResTime><ns1:maxResTime>62.0</ns1:maxResTime><ns1:m
inResTime>0.0</ns1:minResTime><ns1:cumReqCount>24</ns1:cumReqCount><ns1:cumResCount>23</ns1:cumResCount><ns1:cumFaultCount>1</ns1:cumFaultCount></ns1:addOperationD
ata></soapenv:Body></soapenv:Envelope>

But when I look at them at createProcessedPreparedStatement in SQLQuery class, the paramValue appears to be null, and it picks the param name correctly though. 

Can someone please have a look. 

Thanks,
Samisa...



--
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"



--
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Anjana Fernando-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello,

I'll take a look.

Anjana.

On Sat, Nov 7, 2009 at 7:09 PM, Samisa Abeysinghe <samisa@...> wrote:

> The problem DS is
> here; https://wso2.org/repos/wso2/people/dumindu/scratch/bam/bam-2009-11-07-v001/bam/modules/distribution/bam/dataservice/BAMDataCollectionDS.dbs
> Thanks,
> Samisa...
>
> On Sat, Nov 7, 2009 at 7:00 PM, Samisa Abeysinghe <samisa@...> wrote:
>>
>> I am pulling my hair to figure out why the DS that worked on trunk is not
>> working on 2.0.2
>> Ii have verified that the DS MR gets the message (the hard way):
>> [2009-11-07 18:54:35,672] DEBUG -  DS MR invokeBusinessLogic SOAP Envelope
>> <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope
>> xmlns:soapenv="http://www.w3.org
>> /2003/05/soap-envelope"><soapenv:Header
>> xmlns:wsa="http://www.w3.org/2005/08/addressing"><wsa:To>https://10.202.120.28:9444/greg/services/BAMDataCollectionDS</wsa:
>>
>> To><wsa:ReplyTo><wsa:Address>http://www.w3.org/2005/08/addressing/none</wsa:Address></wsa:ReplyTo><wsa:MessageID>urn:uuid:CA20DBD64A31ED47101257600278250</wsa:Mess
>>
>> ageID><wsa:Action>urn:addOperationData</wsa:Action></soapenv:Header><soapenv:Body><ns1:addOperationData
>> xmlns:ns1="http://ws.wso2.org/dataservice"><ns1:operationID
>> >6</ns1:operationID><ns1:timestamp>2009-11-07
>> > 18:54:34</ns1:timestamp><ns1:avgResTime>4.541666666666667</ns1:avgResTime><ns1:maxResTime>62.0</ns1:maxResTime><ns1:m
>>
>> inResTime>0.0</ns1:minResTime><ns1:cumReqCount>24</ns1:cumReqCount><ns1:cumResCount>23</ns1:cumResCount><ns1:cumFaultCount>1</ns1:cumFaultCount></ns1:addOperationD
>> ata></soapenv:Body></soapenv:Envelope>
>> But when I look at them at createProcessedPreparedStatement in SQLQuery
>> class, the paramValue appears to be null, and it picks the param
>> name correctly though.
>> Can someone please have a look.
>> Thanks,
>> Samisa...
>>
>>
>> --
>> Samisa Abeysinghe
>> Director, Engineering - WSO2 Inc.
>>
>> http://www.wso2.com/ - "The Open Source SOA Company"
>
>
>
> --
> Samisa Abeysinghe
> Director, Engineering - WSO2 Inc.
>
> http://www.wso2.com/ - "The Open Source SOA Company"
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev@...
> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Samisa Abeysinghe-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The exception:

org.h2.jdbc.JdbcSQLException: NULL not allowed for column BAM_OPERATION_ID; SQL statement:
INSERT INTO BAM_OPERATION_DATA (BAM_OPERATION_ID, BAM_TIMESTAMP, BAM_AVG_RES_TIME, BAM_MAX_RES_TIME, BAM_MIN_RES_TIME, BAM_CUM_REQ_COUNT, BAM_CUM_RES_COUNT, BAM_CU
M_FAULT_COUNT) VALUES (?, ?, ?, ?, ?, ?, ?, ?); [90006-112]
        at org.h2.message.Message.getSQLException(Message.java:107)
        at org.h2.message.Message.getSQLException(Message.java:118)
        at org.h2.message.Message.getSQLException(Message.java:77)
        at org.h2.table.Column.validateConvertUpdateSequence(Column.java:279)
        at org.h2.table.Table.validateConvertUpdateSequence(Table.java:582)
        at org.h2.command.dml.Insert.update(Insert.java:97)
        at org.h2.command.CommandContainer.update(CommandContainer.java:71)
        at org.h2.command.Command.executeUpdate(Command.java:207)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdateInternal(JdbcPreparedStatement.java:139)
        at org.h2.jdbc.JdbcPreparedStatement.executeUpdate(JdbcPreparedStatement.java:128)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
        at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.processNormalQuery(SQLQuery.java:241)
        at org.wso2.carbon.dataservices.dispatch.query.SQLQuery.runQuery(SQLQuery.java:967)
        at org.wso2.carbon.dataservices.dispatch.query.Query.execute(Query.java:110)
        at org.wso2.carbon.dataservices.dispatch.CallQuery.execute(CallQuery.java:72)
        at org.wso2.carbon.dataservices.dispatch.operation.Operation.execute(Operation.java:50)
        at org.wso2.carbon.dataservices.dispatch.DataService.invoke(DataService.java:186)
        at org.wso2.carbon.dataservices.dispatch.DSOMDataSource.serialize(DSOMDataSource.java:87)
        at org.wso2.carbon.dataservices.DBUtils.doNormalRequest(DBUtils.java:185)
        at org.wso2.carbon.dataservices.DBUtils.xinvoke(DBUtils.java:131)
        at org.wso2.carbon.dataservices.DBInOnlyMessageReceiver.invokeBusinessLogic(DBInOnlyMessageReceiver.java:45)
        at org.apache.axis2.receivers.AbstractMessageReceiver.receive(AbstractMessageReceiver.java:114)
        at org.apache.axis2.engine.AxisEngine.receive(AxisEngine.java:178)
        at org.apache.axis2.transport.http.HTTPTransportUtils.processHTTPPostRequest(HTTPTransportUtils.java:167)
        at org.apache.axis2.transport.http.AxisServlet.doPost(AxisServlet.java:142)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.eclipse.equinox.http.servlet.internal.ServletRegistration.handleRequest(ServletRegistration.java:90)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:111)
        at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:67)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.wso2.carbon.bridge.BridgeServlet.service(BridgeServlet.java:135)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
        at java.lang.Thread.run(Thread.java:619)


On Sat, Nov 7, 2009 at 7:12 PM, Anjana Fernando <anjana@...> wrote:
Hello,

I'll take a look.

Anjana.

On Sat, Nov 7, 2009 at 7:09 PM, Samisa Abeysinghe <samisa@...> wrote:
> The problem DS is
> here; https://wso2.org/repos/wso2/people/dumindu/scratch/bam/bam-2009-11-07-v001/bam/modules/distribution/bam/dataservice/BAMDataCollectionDS.dbs
> Thanks,
> Samisa...
>
> On Sat, Nov 7, 2009 at 7:00 PM, Samisa Abeysinghe <samisa@...> wrote:
>>
>> I am pulling my hair to figure out why the DS that worked on trunk is not
>> working on 2.0.2
>> Ii have verified that the DS MR gets the message (the hard way):
>> [2009-11-07 18:54:35,672] DEBUG -  DS MR invokeBusinessLogic SOAP Envelope
>> <?xml version='1.0' encoding='utf-8'?><soapenv:Envelope
>> xmlns:soapenv="http://www.w3.org
>> /2003/05/soap-envelope"><soapenv:Header
>> xmlns:wsa="http://www.w3.org/2005/08/addressing"><wsa:To>https://10.202.120.28:9444/greg/services/BAMDataCollectionDS</wsa:
>>
>> To><wsa:ReplyTo><wsa:Address>http://www.w3.org/2005/08/addressing/none</wsa:Address></wsa:ReplyTo><wsa:MessageID>urn:uuid:CA20DBD64A31ED47101257600278250</wsa:Mess
>>
>> ageID><wsa:Action>urn:addOperationData</wsa:Action></soapenv:Header><soapenv:Body><ns1:addOperationData
>> xmlns:ns1="http://ws.wso2.org/dataservice"><ns1:operationID
>> >6</ns1:operationID><ns1:timestamp>2009-11-07
>> > 18:54:34</ns1:timestamp><ns1:avgResTime>4.541666666666667</ns1:avgResTime><ns1:maxResTime>62.0</ns1:maxResTime><ns1:m
>>
>> inResTime>0.0</ns1:minResTime><ns1:cumReqCount>24</ns1:cumReqCount><ns1:cumResCount>23</ns1:cumResCount><ns1:cumFaultCount>1</ns1:cumFaultCount></ns1:addOperationD
>> ata></soapenv:Body></soapenv:Envelope>
>> But when I look at them at createProcessedPreparedStatement in SQLQuery
>> class, the paramValue appears to be null, and it picks the param
>> name correctly though.
>> Can someone please have a look.
>> Thanks,
>> Samisa...
>>
>>
>> --
>> Samisa Abeysinghe
>> Director, Engineering - WSO2 Inc.
>>
>> http://www.wso2.com/ - "The Open Source SOA Company"
>
>
>
> --
> Samisa Abeysinghe
> Director, Engineering - WSO2 Inc.
>
> http://www.wso2.com/ - "The Open Source SOA Company"
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev@...
> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>
>

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev



--
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by sumedha rubasinghe :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Samisa Abeysinghe wrote:
> The problem DS is
> here; https://wso2.org/repos/wso2/people/dumindu/scratch/bam/bam-2009-11-07-v001/bam/modules/distribution/bam/dataservice/BAMDataCollectionDS.dbs 
>
>
There is a syntax error in this dbs file. 'with-aram' should be
'with-param'. So this couldn't have worked on the trunk even. ;-)

I have fixed this (around 50 occurrences) & committed.
/sumedha


> Thanks,
> Samisa...
>
> On Sat, Nov 7, 2009 at 7:00 PM, Samisa Abeysinghe <samisa@...
> <mailto:samisa@...>> wrote:
>
>     I am pulling my hair to figure out why the DS that worked on trunk
>     is not working on 2.0.2
>
>     Ii have verified that the DS MR gets the message (the hard way):
>


_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Anjana Fernando-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi,

There are also "query-paramc" occurrences in the dbs, which should be
just "query-param". Please do a search and replace those.

Cheers,
Anjana.

On Sat, Nov 7, 2009 at 8:22 PM, sumedha <sumedha@...> wrote:

> Samisa Abeysinghe wrote:
>> The problem DS is
>> here; https://wso2.org/repos/wso2/people/dumindu/scratch/bam/bam-2009-11-07-v001/bam/modules/distribution/bam/dataservice/BAMDataCollectionDS.dbs
>>
>>
> There is a syntax error in this dbs file. 'with-aram' should be
> 'with-param'. So this couldn't have worked on the trunk even. ;-)
>
> I have fixed this (around 50 occurrences) & committed.
> /sumedha
>
>
>> Thanks,
>> Samisa...
>>
>> On Sat, Nov 7, 2009 at 7:00 PM, Samisa Abeysinghe <samisa@...
>> <mailto:samisa@...>> wrote:
>>
>>     I am pulling my hair to figure out why the DS that worked on trunk
>>     is not working on 2.0.2
>>
>>     Ii have verified that the DS MR gets the message (the hard way):
>>
>
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev@...
> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Dumindu Pallewela :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message



On Sat, Nov 7, 2009 at 8:22 PM, sumedha <sumedha@...> wrote:
There is a syntax error in this dbs file. 'with-aram' should be
'with-param'.

ops! that didn't give any error when working with trunk.
 

So this couldn't have worked on the trunk even. ;-)

Actually, it does work on trunk. Perhaps some DS change that was not committed to the trunk?

Regards,
Dumindu.


_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev

Re: DS problem with BAM DS

by Anjana Fernando-2 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

> Actually, it does work on trunk. Perhaps some DS change that was not
> committed to the trunk?
>
> Regards,
> Dumindu.

The current code in trunk and the branch should be identical, I'm
guessing, you haven't taken an update on the trunk for sometime :) ..

Cheers,
Anjana.

_______________________________________________
Carbon-dev mailing list
Carbon-dev@...
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev