-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 David,
David kerber wrote: | David kerber wrote: | Looking at these other posts, and the reference Charles posted, it's | apparent that I've been getting away without using pooling, even though | I though I was using it... Some drivers actually do perform their own pooling (certain Oracle drivers IIRC), so you might be using pooling even though you have not explicitly had to do any explicit configuration. The JDBC API itself neither provides nor promises any pooling services, so it's up to the implementor of the driver to decide to add that capability. JDBC 2.0 added the javax.sql.DataSource interface, which is basically the basis for pooling (instead of using java.sql.DriverManager). If you are already using an instance of a DataSource in your own code, you are probably using pooled (or at least re-usable) JDBC connections whether you know it or not. Tomcat's configuration allows you to specify pool size, etc. in a standard way. It's unclear to me how to configure a connection pool for, say, MySQL's Connector/J directly, though MySQL provides a DataSource that claims to support connection pooling. The bottom line is that if you are calling DriverManager.getConnection, you are probably not maximizing the your use of database connections. Hope that helps, - -chris References: http://java.sun.com/products/jdbc/download.html#spec http://dev.mysql.com/tech-resources/articles/connection_pooling_with_connectorj.html (old but still relevant) http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.html -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkgHuAwACgkQ9CaO5/Lv0PDnEgCffLPfoSSsHej5H80OEyUTV7Hy VFUAn3A00oHCv29SSdLeHENqMF9+0zDt =AwL7 -----END PGP SIGNATURE----- --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
