can't access rest-API after a while because of DB connection is closed.

HasanSyed.4377

Hi guys,
Newbie here. I've an app written which is calling rest API deployed in AWS (both mysql DB and web app).
I've posted a question in AWS forum as well:
https://forums.aws.amazon.com/thread.jspa?messageID=842493&#842493
but didn't get any response yet.

Can you guys pls have a look and help me.
Thanks a lot.

Ahsan_Siddique

Create RESTful API, rather than using any JDBC drivers, which I hope would be available, which in short, is not recommended.

Follow my tutorials.

Developing RESTful API in ASP.Net With Azure Database.

Part 1
https://c-sharpcorner.com/article/creating-sql-database-in-azure-portal/

part 2
https://c-sharpcorner.com/article/developing-restful-api-in-asp-net-with-add-method/

Part 3
https://c-sharpcorner.com/article/developing-restful-apis-in-asp-net-with-retrieve-update-and-delete-functions/

Consuming RESTful API in Xamarin.Android

part 4
https://c-sharpcorner.com/article/consuming-restful-apis-in-xamarin-android/

HasanSyed.4377

@Ahsan_Siddique , I've already created my rest-APi using java. And its working fine and dandy if I access it from browser. But, once I access it from xamarin-forms app, after a while, I get connection-closed exception.

Ahsan_Siddique

Let's try with this code and add HttpClient nuget package in your app.

        `public async Task<List<Hospital>> getHospitalsByCityAsync(string city){
                    List<Hospital> hospitals = null;
                HttpClient client = new HttpClient();
                    string encodedCity = System.Net.WebUtility.UrlEncode(city);
                    string RestUrl = Constants.REST_API_URL+"/city/" + encodedCity;
                var result = await client.GetAsync(RestUrl);
                    var json = await result.Content.ReadAsStringAsync();
                    try {

                hospitals = JsonConvert.DeserializeObject<List<Hospital>>(json);
         }catch (Exception ex) { }
                        if (hospitals == null)
                        {

                            Toast.MakeText(this, json, ToastLength.Short).Show();
                        }
                 else   

                    {
                        Toast.MakeText(this, "Record found", ToastLength.Short).Show();
                    }

                    return hospitals;
                }`

ChrisColeTech

it appears you have a nasty memory leak.

Im assuming this is for an Android device/simulator? Does this happen on iOS also?

you may have to just do some garbage collecting between api calls.

check out the xamarin documentation on memory management, especially the part on garbage collection

https://docs.microsoft.com/en-us/xamarin/cross-platform/deploy-test/memory-perf-best-practices

it tells you how to setup the profiler - i'd start there

good luck

HasanSyed.4377

@ChrisColeTech ,
Thanks a lot for pointing me to this direction. I never thought of it. Truly appreciate it.
May Almighty Allah reward you.