Have you read what resource definitions mean from - https://tomcat.apache.org/tomcat-8.5-doc/config/context.html ?
On 22 February 2018 at 08:32, Howlader, Aakash [GTSUS Non-J&J] < ahowl...@its.jnj.com> wrote: > 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 > > > > >