can we use HttpClient.execute(httpGet) to insert data

[shawn peter]

I need to know can we use HttpClient.execute(httpGet) to insert data.
because below code doesn't work for me.Also it doesn't give any exception too.

HttpClient client = new DefaultHttpClient();
HttpGet httpGet = new HttpGet("http://172.22.229.137:9763/services/CitiService.HTTPEndpoint/addLeaves?"+leave.trim());
HttpResponse response = client.execute(httpGet);
HttpGet httpGet1=httpGet;

when i debug the code it stop the below line .It doesn't return anything.

HttpResponse response = client.execute(httpGet);

[Ulf Dittmer]

And by "insert data" you mean...

[shawn peter]

I am calling web service method which insert data to database table.

[E Armitage]

Read up on the HTTP methods GET,PUT,POST (just those for now) to find out the differences between them and which one to use for which tasks.
Also, you should urlencode your request url in case there are special parameters.
You should also test your service via simple tools like a web browser to determine that the server is reachable and the services available.
Then you should verify that the environment running your Java client can connect to the server with the services.

[Paul Clapham]

sam liyanage wrote:when i debug the code it stop the below line .It doesn't return anything.

So what does that mean? Does the code hang? Is an ignored exception thrown?

[shawn peter]

@Armitage

I tried with below in url.Then its working fine.Data inserting to the database.

http://172.22.229.137:9763/services/CitiService.HTTPEndpoint/addLeaves?Rtype=1&FromDate=2013-11-26&ToDate=2013-11-27&FromPerson=Arunaaa&team=1&project=1&Details=sffffffffffff

Code doesn't go.Its hand and no output or any exception.


Then i change the code to below

HttpClient httpclient = new DefaultHttpClient();
		    HttpPost httppost = new HttpPost("http://172.22.229.137:9763/services/CitiService.HTTPEndpoint/addLeaves");

		    try {
		        // Add your data
		        List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
		        nameValuePairs.add(new BasicNameValuePair("Rtype", leaveobj.getRequestType().trim()));
		        nameValuePairs.add(new BasicNameValuePair("FromDate", leaveobj.getFromDate().trim()));
		        nameValuePairs.add(new BasicNameValuePair("ToDate", leaveobj.getToDate().trim()));
		        nameValuePairs.add(new BasicNameValuePair("FromPerson", leaveobj.getFromPerson().trim()));
		        nameValuePairs.add(new BasicNameValuePair("team", leaveobj.getTeam().trim()));
		        nameValuePairs.add(new BasicNameValuePair("project", leaveobj.getProject().trim()));
		        nameValuePairs.add(new BasicNameValuePair("Details", comment.toString().trim()));
		        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

		        // Execute HTTP Post Request
		        HttpResponse response = httpclient.execute(httppost);
		        Log.i("posting", "Insert data to the Database");

when i debug it also stuck in below line and not insert data to the database.

HttpResponse response = httpclient.execute(httppost);

[E Armitage]

You have a try but what happens in the catch of that try? Also read all parts of all the replies you are getting. Don't jyst handpick what you think is important. All of it is very important.

[shawn peter]

I am getting below in the Logcat

01-15 19:09:00.189: D/SntpClient(60): request time failed: java.net.SocketException: Address family not supported by protocol

I am using WSO2 DSS server to create Web services.It uses Axis2 in the back end to generate Web Services.Anyway i don't know why it gives me this error?