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 <[email protected]> wrote:
> Hello,
>
> I'll take a look.
>
> Anjana.
>
> On Sat, Nov 7, 2009 at 7:09 PM, Samisa Abeysinghe <[email protected]> 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 <[email protected]>
> 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
> > [email protected]
> > https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
> >
> >
>
> _______________________________________________
> Carbon-dev mailing list
> [email protected]
> 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
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
