One Star

Http Get Method for xml into oracle database

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.
4 REPLIES
Community Manager

Re: Http Get Method for xml into oracle database

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
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Http Get Method for xml into oracle database

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.
One Star

Re: Http Get Method for xml into oracle database

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.
One Star

Re: Http Get Method for xml into oracle database

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