> From: Wouter D'Haeseleer [mailto:wdhaesel...@vangenechten.com] > Subject: Tomcat and Oracle connections
Don't suppose you could be bothered to tell us the Tomcat version, JVM level, and OS you're running on? > And when I look at the connections itself in oracle I see that the > following connection is using more then 200 sessions ! Classic symptoms of bad webapp code failing to close connections in all circumstances. You *must* insure that result sets, statements, and connections are always closed (returned to the pool) by using finally clauses in the appropriate places. > type="oracle.jdbc.pool.OracleDataSource" > For me this is really strange since this connections says maxActive=10 Since you've specified a non-standard type, you're doing your own pooling rather than letting Tomcat do it. No telling what the proper attribute names are in that case. Read the Tomcat JDBC doc for whatever level you're using. - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
