Hello, The jdbc url "url="jdbc:postgresql://itsusralsp06829:5432/spectra" points to a postgre db in another host. We tried to modify the maxActive parameter. The other parameters were left untouched.
This is what the property was in the original context.xml ><Resource name="jdbc/E2EMFPostGres" auth="Container" > type="javax.sql.DataSource" maxActive="50" maxIdle="30" > maxWait="10000" username="saevdcep" password="xxxxxx" > driverClassName="org.postgresql.Driver" > url="jdbc:postgresql://itsusralsp06829:5432/spectra"/> > > <Resource name="jdbc/EVDSEARCH" auth="Container" > type="javax.sql.DataSource" maxActive="50" maxIdle="30" > maxWait="10000" username="saevdcep" password="xxxxxxx" > driverClassName="org.postgresql.Driver" > url="jdbc:postgresql://itsusralsp06829:5432/evidencesearch"/> This is the change we made. ><Resource name="jdbc/E2EMFPostGres" auth="Container" > type="javax.sql.DataSource" maxActive="2" maxIdle="30" > maxWait="10000" username="saevdcep" password="xxxxxx" > driverClassName="org.postgresql.Driver" > url="jdbc:postgresql://itsusralsp06829:5432/spectra"/> > > <Resource name="jdbc/EVDSEARCH" auth="Container" > type="javax.sql.DataSource" maxActive="2" maxIdle="30" > maxWait="10000" username="saevdcep" password="xxxxxxx" > driverClassName="org.postgresql.Driver" > url="jdbc:postgresql://itsusralsp06829:5432/evidencesearch"/> Not sure why the jdbc url should change. Could you shed some light on this? -----Original Message----- From: M. Manna [mailto:manme...@gmail.com] Sent: Thursday, February 22, 2018 4:09 AM To: Tomcat Users List <users@tomcat.apache.org> Cc: DL-MD-R&D-SUPPORT <DL-HCSUS-MD-R&d-supp...@its.jnj.com> Subject: [EXTERNAL] Re: Tomcat throwing 404 error after modifying context.xml Your jdbc url and context path have changed. Have you updated how and where you are requesting it? 404 means Not Found. So your requesting for something non-existent. Please chill and confirm. On Wed, 21 Feb 2018 at 22:32, Howlader, Aakash [GTSUS Non-J&J] < ahowl...@its.jnj.com> wrote: > Hello, > > We were facing a "pool error timeout waiting for idle object" issue. > To replicate that in lower environments and perform tests, we tried to > make changes to the contex.xml file located under the conf directory > of tomcat. > The path is /apps/apache-tomcat-7.0.67/conf/context.xml > > The properties we were modifying are given below . > > > <Resource name="jdbc/E2EMFPostGres" auth="Container" > > type="javax.sql.DataSource" maxActive="50" maxIdle="30" > > maxWait="10000" username="saevdcep" password="xxxxxx" > > driverClassName="org.postgresql.Driver" > > url="jdbc:postgresql://itsusralsp06829:5432/spectra"/> > > > > <Resource name="jdbc/EVDSEARCH" auth="Container" > > type="javax.sql.DataSource" maxActive="50" maxIdle="30" > > maxWait="10000" username="saevdcep" password="xxxxxxx" > > driverClassName="org.postgresql.Driver" > > url="jdbc:postgresql://itsusralsp06829:5432/evidencesearch"/> > > However, on restarting the tomcat server after making changes to > values in these, the application is throwing a 404: Resource not Found > error. The tomcat server is up and running but on hitting the > application URL, we are getting the 404 error. > > We even tried restoring the context.xml file to its original values > but that did not seem to make a difference. > > Can you please let us know what steps we need to follow in order to > be able to make modifications to the file and perform our tests? > > Best Regards, > Aakash > >
