-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Paul,
On 6/20/18 3:34 PM, Lueders, Paul T CIV USARMY NGIC (US) wrote: > We have configured an oracle 12c connection using the Oracle jdbc > connector . What we are experiencing is that the application is > locking up and the database requires a restart. We believe that > the issue is that application is not releasing the connections and > the database runs out of connections. That is almost certainly true. > The question I have is the JDBC driver the best one for oracle > 12c? I don't see why not. My recommendation would be that you (a) use a pure-Java (Type 4) JDBC driver and (b) use the latest version available. > If so what would be some configuration items that we need to set > in order to ensure that the application releases the connections > efficiently. If you are using a connection pool (such as DBCP-2 or Tomcat-pool, both of which can be used easily by configuring a container-provided JNDI <Resource> for your application), you should read the documentation for the pool, especially the "abandoned" resources management. Often, the pool itself can recover from sloppy resource-management on the part of the application. > Lastly is = there a monitor available to watch the database > connections. Everything is available through JMX. Have a look at the presentation titled "Monitoring Apache Tomcat with JMX" on this page: http://tomcat.apache.org/presentations.html Hope that helps, - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlsr4PkACgkQHPApP6U8 pFhc3g/+LAqb+OFgoCUs6k4x2qBiFXuDNUF7x0CbWz3w1kwy0yUj49EL4Vzd9/js KVWAgE1WYkoeFLlbOHxkgG3S8AjRpcTagF7Q/HPoIdyU66TDl3fLmfFn4yteZSP4 8Az5jPlleFcqdVd9sHPtxJWIJRlV7JX+qH4j5/UQjSLzlZ/vCTD4J1sIbjqSQ0Dn 20OBkVcRLpgDZ0lh1veL3qbPGzNVPw8vMh9gArkvUPTSLB/zqDKdj3tmzUqT0kVA tEnqVJHqurimLfi33Q+lDb4UYo2jDIkt1j5nQX7fD3NrqffJGDRQSMV3c8nwo4ER nfkgynikXtHbd8DM1zWXK3dVufup7ezmHv0WkusqDGjY3hyxJk7x8OHk19aicl1d WW9nTdsH32uPsz+nE8M/UND/AlpqpuBm+ujXJTTYFEERFR9ZqMc4aUJ2mwDRGfFr 6BIQNTmV2IjfdJyjurUBwX4/h8HlrxU86yQjk+VE4Tb9u8risptgYqepP/fP+gIC Kjxr/+31EHB6/AAVRNzD5udZ/AfXL88C1fKvBmlOh6YOUN30JyWN0h3ST+A5bJp9 u6Ty01l++1AYM43l3FixjjyVv7Y4si2hyAvI1gn7KRPMIuHysZKtioEGiNMVLKkF rFuKYIk0kJVBlWSYOeLA/DUdR6MiBNPhMqBF5hFlniILZyTj16c= =YdqQ -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org