I have been using the Oracle Cloud Service for the last 10-15 days. I deployed a JAVA Web service application which is connected with the Oracle Cloud Database. I am consuming that web service in my Oracle ADF Mobile Application. But when I try to request the any web method of the service more than 4-5 times then the database connection goes unavailable and it respond me NullPointerException. After 10-15 minutes, The Database connection is available but when I request again more than 4-5 times to any web method of Web service then I face same issue.
I have been facing this problem for last 2-3 Days.
Java Cloud Service basic (S1) and trial provides 5 DB connections in your connection pool. Make sure that your application is releasing the connections after each requests.
Your application seems to be holding on to the connections and running out of it after 4-5 attempts,
To adjust tuning parameters for ADF BC for cloud, it's recommended to change the following in the AM configuration:
Can you please try these.