calling servlet ( web service) through Teiid desinger gives error
amitagrawal Jul 18, 2013 6:31 PMHi,
I have a simple servlet which retuns xml respsone as mentioned in the consumerest_ws_datasource.pdf example. I am calling this servlet from VDB using REST service connection profile. However, I get the below error while exeucting the final query on the table. I have also attached the VDB.
servlet :
this is the query executed from Squirrel : select * from MyCustomers
below is the error long. appricate any help to resolve this issue.
18:05:53,585 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "WebConvdb.vdb"
18:05:53,616 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB WebConvdb.1 model "mywebsource" metadata is currently being loaded. Start Time: 7/18/13 6:05 PM
18:05:53,616 INFO [org.teiid.RUNTIME] (MSC service thread 1-4) TEIID50029 VDB WebConvdb.1 model "mywebview" metadata is currently being loaded. Start Time: 7/18/13 6:05 PM
18:05:53,663 INFO [org.jboss.as.server] (HttpManagementService-threads - 1) JBAS018559: Deployed "WebConvdb.vdb"
18:05:53,678 INFO [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50030 VDB WebConvdb.1 model "mywebsource" metadata loaded. End Time: 7/18/13 6:05 PM
18:05:53,678 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID50030 VDB WebConvdb.1 model "mywebview" metadata loaded. End Time: 7/18/13 6:05 PM
18:05:53,897 INFO [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB WebConvdb.1 is set to ACTIVE
18:06:43,772 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue13) START DATA SRC COMMAND: startTime=2013-07-18 18:06:43.772 requestID=Zlg3MjVw1uyv.6 sourceCommandID=4 txID=null modelName=mywebsource translatorName=ws sessionID=Zlg3MjVw1uyv principal= sql=EXEC mywebsource.invoke('HTTP', 'GET', 'http://ssc80049:8080/WebServiceSource/SampleServlet')
18:06:43,975 INFO [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (Worker1_QueryProcessorQueue13) Creating Service {http://teiid.org}teiid from class org.apache.cxf.jaxws.support.DummyImpl
18:06:44,303 WARNING [org.apache.cxf.phase.PhaseInterceptorChain] (Worker1_QueryProcessorQueue13) Interceptor for {http://teiid.org}teiid#{http://cxf.apache.org/jaxws/dispatch}Invoke has thrown exception, unwinding now: org.apache.cxf.interceptor.Fault: Could not write to XMLStreamWriter.
at org.apache.cxf.interceptor.StaxOutEndingInterceptor.handleMessage(StaxOutEndingInterceptor.java:75)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:530)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:463)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:366)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:319)
at org.apache.cxf.endpoint.ClientImpl.invokeWrapped(ClientImpl.java:354)
at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:385)
at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:243)
at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:135)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:177) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:174) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]
at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
Caused by: javax.xml.stream.XMLStreamException: Trying to write END_DOCUMENT when document has no root (ie. trying to output empty document).
at com.ctc.wstx.sw.BaseStreamWriter.throwOutputError(BaseStreamWriter.java:1518)
at com.ctc.wstx.sw.BaseStreamWriter.reportNwfStructure(BaseStreamWriter.java:1547)
at com.ctc.wstx.sw.BaseStreamWriter._finishDocument(BaseStreamWriter.java:1373)
at com.ctc.wstx.sw.BaseStreamWriter.writeEndDocument(BaseStreamWriter.java:532)
at org.apache.cxf.interceptor.StaxOutEndingInterceptor.handleMessage(StaxOutEndingInterceptor.java:56)
... 22 more
18:06:44,319 DEBUG [org.teiid.COMMAND_LOG] (Worker1_QueryProcessorQueue13) ERROR SRC COMMAND: endTime=2013-07-18 18:06:44.319 requestID=Zlg3MjVw1uyv.6 sourceCommandID=4 txID=null modelName=mywebsource translatorName=ws sessionID=Zlg3MjVw1uyv principal= finalRowCount=null
18:06:44,334 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue13) Connector worker process failed for atomic-request=Zlg3MjVw1uyv.6.4.0: org.teiid.translator.TranslatorException
at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:139)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:257) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:177) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:174) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]
at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]
at org.teiid.dqp.internal.process.DQPCore$FutureWork.run(DQPCore.java:118) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:123) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:298) [teiid-engine-8.2.0.Final.jar:8.2.0.Final]
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]
at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
Caused by: javax.xml.ws.http.HTTPException
at org.apache.cxf.jaxws.DispatchImpl.mapException(DispatchImpl.java:273)
at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:392)
at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:243)
at org.teiid.translator.ws.WSProcedureExecution.execute(WSProcedureExecution.java:135)
... 13 more
Caused by: org.apache.cxf.interceptor.Fault: Could not write to XMLStreamWriter.
at org.apache.cxf.interceptor.StaxOutEndingInterceptor.handleMessage(StaxOutEndingInterceptor.java:75)
at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:262)
at org.apache.cxf.endpoint.ClientImpl.doInvoke(ClientImpl.java:530)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:463)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:366)
at org.apache.cxf.endpoint.ClientImpl.invoke(ClientImpl.java:319)
at org.apache.cxf.endpoint.ClientImpl.invokeWrapped(ClientImpl.java:354)
at org.apache.cxf.jaxws.DispatchImpl.invoke(DispatchImpl.java:385)
... 15 more
Caused by: javax.xml.stream.XMLStreamException: Trying to write END_DOCUMENT when document has no root (ie. trying to output empty document).
at com.ctc.wstx.sw.BaseStreamWriter.throwOutputError(BaseStreamWriter.java:1518)
at com.ctc.wstx.sw.BaseStreamWriter.reportNwfStructure(BaseStreamWriter.java:1547)
at com.ctc.wstx.sw.BaseStreamWriter._finishDocument(BaseStreamWriter.java:1373)
at com.ctc.wstx.sw.BaseStreamWriter.writeEndDocument(BaseStreamWriter.java:532)
at org.apache.cxf.interceptor.StaxOutEndingInterceptor.handleMessage(StaxOutEndingInterceptor.java:56)
... 22 more
18:06:44,350 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue14) TEIID30020 Processing exception 'TEIID30504 mywebsource: null' for request Zlg3MjVw1uyv.6. Exception type org.teiid.core.TeiidProcessingException thrown from com.ctc.wstx.sw.BaseStreamWriter.throwOutputError(BaseStreamWriter.java:1518). Enable more detailed logging to see the entire stacktrace.
-
WebConvdb.vdb.zip 12.9 KB