-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Alejandro,
On 6/21/18 11:54 AM, alejandro.var...@kymsolutions.com wrote: > I think you need to close resultsets, prepared statements and > finally close connections > > If not Oracle will hangout eventually by exceeded cursors or > connections. > > Open connection Open preparedstatements or callable statements Open > resultset Do resultset stuff Close resultset Close > preparedstatements or callable statements Close connection > > Try to follow allways this pattern, and don't forget to catch > sqlexceptions and close the appropiate process. +1 https://blog.christopherschultz.net/index.php/2009/03/16/properly-handli ng-pooled-jdbc-connections/ - -chris > -----Original Message----- From: Maxim Solodovnik > <solomax...@gmail.com> Sent: Wednesday, June 20, 2018 8:41 PM To: > Tomcat Users List <users@tomcat.apache.org> Subject: Re: oracle 12c > driver (UNCLASSIFIED) > > We are currently using ojdbc6 in production I would use ojdbc8 for > new project ( > http://www.oracle.com/technetwork/database/features/jdbc/jdbc-ucp-122- 3110062.html > > ) > > I believe the problem is caused by connection pool settings, not > the driver .... > > On Thu, Jun 21, 2018 at 2:38 AM Lueders, Paul T CIV USARMY NGIC > (US) < paul.t.lueders....@mail.mil> wrote: > >> CLASSIFICATION: UNCLASSIFIED >> >> 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. The question I have >> is the JDBC driver the best one for oracle 12c? If so what would >> be some configuration items that we need to set in order to >> ensure that the application releases the connections efficiently. >> Lastly is = there a monitor available to watch the database >> connections. >> >> Thanks a lot Paul CLASSIFICATION: UNCLASSIFIED >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org >> For additional commands, e-mail: users-h...@tomcat.apache.org >> >> > > -- WBR Maxim aka solomax > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlsr3/gACgkQHPApP6U8 pFhMOA//fqSYZ4ZFSySrzcuv71r9cg83tntmEypKLKFwRRPS0pUrE1h+oj2LqTwy 3n9W+kxWhGaz863Vi3bQebItMx2qKMl8jDIthrS03KOwyWKniXzfYKUV/6OorSwJ 41RYNGjO+JJgsG2kfrxpVJcn1KuNstAQOPIuWjYq77dN1RypEWrvFP2fpZGDjOqg 6xjXfW8HiiPwvggmabaKt1JsnGOVj+lZUJHxteh2dQ3HcnNGhBa12TazGH/dfG2n Rnwm0uNd2FdEi+JHXFWgWiPjcTi7WdCyMrYciH1gs+jj3kDhcXbYb6FPPHj14D/j G9YfQ4RNcugwOnl6EN7LfrZxSpj0T4MzdwG2JxdXpV3+IXJ0GKEBsYhJaKu0h1YZ LNMTkIQHMP56mFvkvRlC68EmLa3QdNN13y6wdEreHE38RwA8ov7fPTj9hka9hjZm YdPSR7i16We0X8rE5gsAUFf9QNPdzinCOJAZpPrZlGtnGZUbY/1yDh1e1Q0cKzdp yZEeNd/XkHUDhS5Kg7wUpekDZ7k2HxSfy2qcs1InCT/14nB84dmp65yXQOt4RXvJ xWqlGQz6vdQOGyCYyfw169+wi+ZlOQYP/pOccc1nKFVP92P4Esm11XSJaW2ePmKu EzrW1417VzaT5PpdOx75W8VMd4/XfzmHegvsTdsAAEcFM3xJnWU= =46TL -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org