Talend community forum / Webservice call

arunshankar · 2012-06-21 10:19:27

Hi All,

I was experimenting if we can do the below scenario :

1) select a Data From a Database, say Oracle

2) pass the output of above Query as input to an Web service call (tWebService). This will query for input parameter in another database (as configured) and provide if the data is existing in database or not.

I tried as below :

tOracleInput_1 --> tWebService_1 --> tLogRow_1

But, am getting too many compile time errors.

Can you please suggest in implementing it.

Thanks,
Arun

shong · 2012-06-21 11:37:48

Hi
The job design is OK, but please provide more details of your job settings. Some screenshots of job are always helpful for us understanding the problem.

Best regards
Shong

arunshankar · 2012-06-21 12:10:53

Hi Shong,

Thank you so much for your reply.

Below is the way I have configured :

1) tOracleInput_1 component contains the below Query :

"select 'cpacadm','10','Available' from dual"

and schema contains 3 columns : Msg_id, Quantity, State (each corresponding to values to be passed to WebService call). Please find the screenshot tOracleInput_schema

2) on Main connector, pass to tWebService_1

Please see snapshots

WSDL_WS
Input_Mapping
Output_Mapping

3) On Main, to tLogRow_1

Please see snapshot :

Log_row_Schema

4) The Overall job is in screenshot "Job"

I am getting the below error after execution :

Code:

Exception in component tWebService_1
java.lang.ClassCastException: oracle.xml.parser.v2.DTD cannot be cast to org.w3c.dom.Element
    at java.util.XMLUtils.load(XMLUtils.java:61)
    at java.util.Properties.loadFromXML(Properties.java:852)
    at org.apache.cxf.common.util.PropertiesLoaderUtils.loadAllProperties(PropertiesLoaderUtils.java:71)
    at org.apache.cxf.wsdl11.WSDLManagerImpl.registerInitialExtensions(WSDLManagerImpl.java:224)
    at org.apache.cxf.wsdl11.WSDLManagerImpl.registerInitialExtensions(WSDLManagerImpl.java:219)
    at org.apache.cxf.wsdl11.WSDLManagerImpl.<init>(WSDLManagerImpl.java:109)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at java.lang.Class.newInstance0(Class.java:355)
    at java.lang.Class.newInstance(Class.java:308)
    at org.apache.cxf.bus.extension.Extension.load(Extension.java:86)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.loadAndRegister(ExtensionManagerImpl.java:153)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.processExtension(ExtensionManagerImpl.java:129)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.loadFragment(ExtensionManagerImpl.java:122)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.load(ExtensionManagerImpl.java:114)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.<init>(ExtensionManagerImpl.java:83)
    at org.apache.cxf.bus.extension.ExtensionManagerImpl.<init>(ExtensionManagerImpl.java:57)
    at org.apache.cxf.bus.extension.ExtensionManagerBus.<init>(ExtensionManagerBus.java:91)
    at org.apache.cxf.bus.CXFBusFactory.createBus(CXFBusFactory.java:41)
    at org.apache.cxf.bus.CXFBusFactory.createBus(CXFBusFactory.java:37)
    at org.apache.cxf.bus.CXFBusFactory.createBus(CXFBusFactory.java:33)
    at org.apache.cxf.BusFactory.getDefaultBus(BusFactory.java:69)
    at org.apache.cxf.BusFactory.getThreadDefaultBus(BusFactory.java:106)
    at org.apache.cxf.BusFactory.getThreadDefaultBus(BusFactory.java:97)
    at org.apache.cxf.endpoint.dynamic.DynamicClientFactory.newInstance(DynamicClientFactory.java:132)
    at org.talend.webservice.helper.ServiceInvokerHelper.<init>(ServiceInvokerHelper.java:75)
    at org.talend.webservice.helper.ServiceInvokerHelper.<init>(ServiceInvokerHelper.java:107)
    at org.talend.webservice.helper.ServiceInvokerHelper.<init>(ServiceInvokerHelper.java:102)
    at arun.webservice_0_1.Webservice.tOracleInput_1Process(Webservice.java:732)
    at arun.webservice_0_1.Webservice.runJobInTOS(Webservice.java:1250)
    at arun.webservice_0_1.Webservice.main(Webservice.java:1118)

Please advise for any changes.

Thanks & BR,
Arun

Uploaded Images

arunshankar · 2012-06-21 12:13:47

Hi Shong,

I am sorry that the snapshots are not in proper order though I uploaded them correctly ..

Thanks,
Arun

arunshankar · 2012-06-21 14:00:42

I got answer in below link :
http://www.talendforge.org/forum/viewto … 312#p88312

Announcement

Unanswered posts

#1 2012-06-21 10:19:27

Webservice call

#2 2012-06-21 11:37:48

Re: Webservice call

#3 2012-06-21 12:10:53

Re: Webservice call

Code:

#4 2012-06-21 12:13:47

Re: Webservice call

#5 2012-06-21 14:00:42

Re: Webservice call

Board footer