Http Get Method for xml into oracle database

MDOTSHADBA — Sat, 16 Nov 2024 12:54:39 GMT

Here is our Scenario :
1) Dowload the xml file using get method from a internet website ( http://seeclickfix.com/api/issues.xml?at=baltimore,+MD)
2) Extract the xml file fields and Map the columns to a table in salesforce
3) Load the data into the salesforce table.
We are first trying to load the XML data into one of our oracle database before attempting to load into salesforce table. But this one is failing with following error message.
I have attached the document and xml files for the job
*******************************************************
Starting job http_get_xml at 09:16 19/05/2011.
connecting to socket on port 3449
connected
May 19, 2011 9:16:57 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection refused: connect
May 19, 2011 9:16:57 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request
May 19, 2011 9:16:58 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection refused: connect
May 19, 2011 9:16:58 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request
May 19, 2011 9:16:59 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: I/O exception (java.net.ConnectException) caught when processing request: Connection refused: connect
May 19, 2011 9:16:59 AM org.apache.commons.httpclient.HttpMethodDirector executeWithRetry
INFO: Retrying request
Exception in component tFileFetch_1
java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.commons.httpclient.protocol.ReflectionSocketFactory.createSocket(ReflectionSocketFactory.java:139)
at org.apache.commons.httpclient.protocol.DefaultProtocolSocketFactory.createSocket(DefaultProtocolSocketFactory.java:124)
at org.apache.commons.httpclient.HttpConnection.open(HttpConnection.java:706)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:386)
disconnected
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at sandbox_smunirathinam_project.http_get_xml_0_1.http_get_xml.tFileFetch_1Process(http_get_xml.java:402)
at sandbox_smunirathinam_project.http_get_xml_0_1.http_get_xml.tSetProxy_1Process(http_get_xml.java:327)
at sandbox_smunirathinam_project.http_get_xml_0_1.http_get_xml.runJobInTOS(http_get_xml.java:2684)
at sandbox_smunirathinam_project.http_get_xml_0_1.http_get_xml.main(http_get_xml.java:2555)
Job http_get_xml ended at 09:17 19/05/2011.

Re: Http Get Method for xml into oracle database

Anonymous — Mon, 23 May 2011 07:18:41 GMT

Hi
The problem is that you can't connect to your website, it is failed to create the server socket. Please check your network settings and permission. Test to open the file http://seeclickfix.com/api/issues.xml?at=baltimore,+MD in browser.
Best regards
Shong

Re: Http Get Method for xml into oracle database

MDOTSHADBA — Mon, 23 May 2011 13:52:18 GMT

Yes I am able to open the URL from the browser and able to see the xml file. In fact I was able to successfully complete this scenario using Jitterbit DI software, we were evaluating the same scenario in Talend.

Re: Http Get Method for xml into oracle database

_AnonymousUser — Mon, 23 May 2011 15:27:22 GMT

Can you please export the job and it's related items and send the zip file to me so I can import it and test it out here? To do this, just click on the job in the repository window, right mouse click and select "Export items". This will create an archive file that you can email to me. Please be sure to include all related items.

Re: Http Get Method for xml into oracle database

MDOTSHADBA — Mon, 23 May 2011 15:44:39 GMT

Thanks Terry, I just sent the job export to your email

topic Re: Http Get Method for xml into oracle database in Talend Studio

Http Get Method for xml into oracle database

Re: Http Get Method for xml into oracle database

Re: Http Get Method for xml into oracle database

Re: Http Get Method for xml into oracle database

Re: Http Get Method for xml into oracle database