Re: client write waits on postgresql RDS

2021-06-15 Thread Ayub Khan
Chris, below is the method responsible for returning the data to the service api, and its returned from service to the Rest controller public MenuList getMenuMobileListNormalizedCombo(long a, long b, boolean c, long d) throws Exception { Connection con = null; CallableStatement callableStatement

RE: Tomcat SSL stops working after an undetermined amount of time

2021-06-15 Thread Mysore, Raghunath
This is nice to know. Thank you for the details. You may want to check the contents of the "java.security" file, to assess, if they have configured BC like this : security.provider.10=org.bouncycastle.jce.provider.BouncyCastleProvider Number 10 can be some other number in your environment.

Re: Tomcat SSL stops working after an undetermined amount of time

2021-06-15 Thread Christopher Schultz
Ezsra, On 6/15/21 17:43, Ezsra McDonald wrote: Sorry for the delay. I was finally able to track down the location of the BouncyCastle library. It is located in the individual application libraries and cannot be disabled. There are newer versions of BC available and I have asked the software

Re: client write waits on postgresql RDS

2021-06-15 Thread Christopher Schultz
Ayub, On 6/15/21 17:27, Ayub Khan wrote: Chris, I am getting the connection from the connection pool, defined using HikariCP. What I have noticed is, as soon as database results are fetched I am printing it in the log, and I see there is a delay between when the results are printed in the log

Re: Tomcat SSL stops working after an undetermined amount of time

2021-06-15 Thread Ezsra McDonald
Sorry for the delay. I was finally able to track down the location of the BouncyCastle library. It is located in the individual application libraries and cannot be disabled. There are newer versions of BC available and I have asked the software developers to consider upgrading the applications.

Re: Jasper's use of deprecated boxed primitive constructors

2021-06-15 Thread Adam Rauch
On 6/14/2021 12:38 PM, Mark Thomas wrote: On 14/06/2021 20:31, Adam Rauch wrote: As you're probably aware, all Boolean, Byte, Character, Double, Float, Integer, Long, and Short constructors were deprecated in JDK 9,

Re: client write waits on postgresql RDS

2021-06-15 Thread Ayub Khan
Chris, I am getting the connection from the connection pool, defined using HikariCP. What I have noticed is, as soon as database results are fetched I am printing it in the log, and I see there is a delay between when the results are printed in the log to that of the response received by the

Re: client write waits on postgresql RDS

2021-06-15 Thread Christopher Schultz
Ayub, On 6/15/21 11:33, Ayub Khan wrote: Would it be a cursor issue, as there seems to be how cursors are handled in postgres and Oracle database. Below are the steps we take from jdbc side 1. open connection 2. set auto commit to false 3. create callable statement 4. execute

Re: client write waits on postgresql RDS

2021-06-15 Thread Ayub Khan
Chris, Would it be a cursor issue, as there seems to be how cursors are handled in postgres and Oracle database. Below are the steps we take from jdbc side 1. open connection 2. set auto commit to false 3. create callable statement 4. execute the call 5. get the results 6.

Re: client write waits on postgresql RDS

2021-06-15 Thread Christopher Schultz
Ayub, On 6/14/21 17:10, Ayub Khan wrote: On Thu, 10 Jun 2021, 08:10 Ayub Khan, wrote: Seeing client write waits on postgresql as attached in the image. Is there any bottle neck which is causing the client write waits on postgresql ? Below is the test setup Jmeter-->(load balanced tomcat on